Speeding up database access - part 8 Fixing memory, disk and CPU issues

by Matt Perdeck 1. December 2011 20:16
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]

Speeding up database access - part 7 Fixing fragmentation

by Matt Perdeck 1. December 2011 20:13
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]

Speeding up database access - part 6 Fixing execution plan reuse

by Matt Perdeck 30. November 2011 21:32
In part 2, we saw how to identify suboptimal reuse of execution plans. In this part 6, we'll look at improving this. [More]

Speeding up database access - part 5 Fixing locking issues

by Matt Perdeck 29. November 2011 19:25
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]

Speeding up database access - part 4 Fixing expensive queries

by Matt Perdeck 28. November 2011 19:42
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]

Speeding up database access - Part 3: Fixing missing indexes

by Matt Perdeck 20. August 2011 12:54
In part 1 you saw how to identify missing indexes. In part 3 you'll see how to add those indexes. [More]

Speeding up database access - Part 2: Pinpointing other bottlenecks

by Matt Perdeck 20. August 2011 12:49
In part 2, we'll pinpoint a number of other bottlenecks, including locking issues, lack of execution plan reuse, fragmentation and hardware issues. [More]

Speeding up database access - Part 1: Missing indexes

by Matt Perdeck 20. August 2011 12:38
In the first part of this series, learn how to pinpoint missing indexes and expensive queries in your databases. [More]

Books

Book: ASP.NET Site Performance Secrets

ASP.NET Site Performance Secrets

By Matt Perdeck

Details and Purchase

About Matt Perdeck

Matt Perdeck PresentingMatt has written extensively on .Net and client side software development.

more >>