Flowchart for troubleshooting SQL Server 2005/2008 performance issues
Posted by decipherinfosys on July 8, 2008
SQL CAT (Customer Advisory Team) from Microsoft posted a flowchart to address the common performance and scalability issues with SQL Server 2005/2008. You can access the post over here. It has links to different KB articles and is very nicely done. It is easy to read and follow and offers the resolutions for the issues in the last column of the spreadsheet. Using this, you can train your development and support personnel in troubleshooting issues in your SQL Server environments in a methodical fashion as well as prepare a performance baseline for your different environments.