Found this informative article which provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server Profiler, System Monitor, and the new Dynamic Management Views in SQL Server 2005.
Source: Microsoft Technet Website
Click Here for Direct Link to 108 pages of Word Document
No comments:
Post a Comment