SQL Server (2008) Performance Tuning Resources
·2 min read
━━━
Here is a (running) list of some SQL Server Performance Tuning resources that I've compiled over the past week or so. These have been helpful in educating me on the black art of database performance tuning. I realize the title states SQL Server 2008, but really most of these probably apply for SQL Server 2005 and 2008. I, particularly am working with 2008, which is why I've put them into that category.
General
- SQL Server Central - Scripts with tag Index Management
- SQL Server Performance Tuning Tips
- SQL Server queries with DMVs for examining bottlenecks
- General Tips on Optimizing SQL Server Indexes
Missing Indexes
- The Ultimate Missing Index Finder
- Using SQL Server DMVs to Identify Missing Indexes
- Using Missing Index Information to Write CREATE INDEX Statements
- Limitations of the Missing Indexes Feature
- sys.dm_db_missing_index_group_stats - Returns summary information about groups of missing indexes, excluding spatial indexes
- Are you using SQL's Missing Index DMVs?
Duplicate Indexes
Unused Indexes/Index Usage
- The Ultimate Index Usage Reporter
- Deeper insight into unused indexes for SQL Server
- Using SQL Server DMVs to Identify Missing Indexes
- Finding a better candidate for your clustered indexes
- Index with Included Columns
- The Ultimate Index Lister (Pivoted)
- Find Unused Indexes of Current Database
Re-indexing
Inefficient Queries
Performance Counters
- SQL Server Database Specific Performance Counters
- Introduction to Three Important Performance Counters