In part 2, we saw how to pinpoint bottlenecks related to the database server hardware - memory, disks and CPU. In this last part 8, we'll look at fixing those hardware issues. [More]

In part 2, we looked at what fragmentation is and how to pinpoint excessive fragmentation. In this part 7, we'll look at fixing excessive fragmentation. [More]

In part 2, we saw how to identify suboptimal reuse of execution plans. In this part 6, we'll look at improving this. [More]

Looks at fixing any locking issues you found in part 2. You'll see how to determine which queries are involved in excessive locking delays, and how to prevent those delays from happening. [More]

In part 1 we saw how to identify the most expensive queries. In this part 4, we'll look at fixing those
expensive queries. [More]

In part 1 you saw how to identify missing indexes. In part 3 you'll see how to add those indexes. [More]

In part 2, we'll pinpoint a number of other bottlenecks, including locking issues, lack of execution plan reuse, fragmentation and hardware issues. [More]

In the first part of this series, learn how to pinpoint missing indexes and expensive queries in your databases. [More]