Andrew Calvett

A performance analysis example

My blog has moved to: http://sqlblogcasts.com/blogs/acalvett/
The full version of this post can be found here.

Last week i was dragged kicking and screaming away from my allocated SQL 2005 days to spend 2 days diagnosing performance problems on one of the firms Systems and write a report.

Due to the sensitive nature of the data on the system it has been managed by another team and this was the first time i had looked at it. I thought i'd share my thought process to identifying the problem on the server and reference tools i used. Its the first iteration of the review and once my recommendations are implemented there will be another review to see what else may need dealing with. Please note however i have not included every single step i took otherwise i'd be writing a novel..................

To read the complete version of this post go to here.