Performance troubleshooting flowchart

Last Updated May 17, 2008

Junior DBAs, warm up your printers. The Microsoft SQL Customer Advisory Team, aka SQLCAT, has published a flowchart explaining how to troubleshoot performance issues with SQL Server. This is by far the best visual representation I’ve seen into how a senior DBA’s brain works:

SQL Customer Advisory Team’s Troubleshooting SQL Server 2005/2008 Performance and Scalability Flowchart

And just think – the rest of us had to learn this stuff the hard way – by reading manuals!

pritam
October 20, 2014 11:43 pm

Hi Brent,

Thanks for all those wonderful posts and blog articles. A long time read of your articles and videos.

Do you have this Performance troubleshooting flowchart? Microsoft SQLCAT has removed this page!

Regards,
Pritam

Reply
- Brent Ozar
  October 22, 2014 7:20 am
  
  Pritam – no, sorry.
  
  Reply
Stephane
April 13, 2016 3:11 am

old post but you can find at :

https://web.archive.org/web/20081011132716/http://sqlcat.com/files/folders/280/download.aspx

Hope this helps!

Stephane

Reply
Rainer
February 1, 2021 2:01 am

Thanks for the link, Stephane!

Reply