Author: Sharon Bjeletich
The following flowchart will address the majority of the most common performance and scalability issues that can arise in SQL Server-based applications.
http://sqlcat.com/files/folders/280/download.aspx
Please note that to be able to accurately use this flow chart you should put your system under load, and it should only be done in a test environment. For more information on how to load test SQL Server see Visual Studio Team System documentation.
Pingback from Performance troubleshooting flowchart | BrentOzar.com
Pingback from SQL Server Performance Troubleshooting | VM-Aware
This is only one among so many great content that can be found at the SQL Cat site. But what is CAT ?
At position "Faster in SSMS":
There are situations in that the query run faster in SSMS than in from the application because there are different session handling (Using Options in SQL Server)
Pingback from flow chart troubleshooting
Pingback from Flowchart for troubleshooting SQL Server 2005/2008 performance issues « Systems Engineering and RDBMS
Thank you for sharing ^^
We too are trying to develop a methodology to troubleshoot any performance case with SQL Server 2005 or SQL Server 2008 with all available tools. Please feel free to review and comment upon.
www.sqlfundas.com/.../Troubleshoot-High-CPU-Performance-issue-in-SQL-Server-2005.aspx
www.sqlfundas.com/.../Troubleshoot-High-CPU-performance-issue-in-SQL-Server-2005-SQL-Server-2008-(Part-2).aspx
www.sqlfundas.com/.../Troubleshoot-High-CPU-performance-issue-in-SQL-Server-2005-SQL-Server-2008-(Part-3).aspx
Pingback from SQLCAT – Diagrama de problemas mais comuns de performance « Just a quick chat about SQL Server
לפני כמה שבועות הייתי נוכח בפגישה נכבדה של DBAs והייתה חגיגה ממש J. בפגישה הציגו מספר בעיות שכל אחת מהן
Very informative. Thanks for sharing!