Brent Ozar - SQL Server DBA Rotating Header Image

Performance troubleshooting flowchart

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!

0 Comments on “Performance troubleshooting flowchart”

Leave a Comment