programming, sql server

SQL Server (2008) Performance Tuning Resources

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

Missing Indexes

Duplicate Indexes

Unused Indexes/Index Usage

Re-indexing

Inefficient Queries

Performance Counters

Performance Data Collector

Database Engine Tuning Advisor

Updating Statistics

Deadlocks

Leave a Reply

Your email address will not be published. Required fields are marked *