Troubleshooting Performance Problems in SQL Server 2008
SQL Server Technical Article
Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel
Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya
Published: March 2009
It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL Server database software. The reasons can range from a poorly designed database to a system that is improperly configured for the workload. As an administrator, you want to proactively prevent or minimize problems; if they occur, you want to diagnose the cause and take corrective actions to fix the problem whenever possible. This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as:
- SQL Server Profiler
- System Monitor (in the Windows Server 2003 operating system) or Performance Monitor (in the Windows Vista operating system and Windows Server 2008), also known as Perfmon
- Dynamic management views (sometimes referred to as DMVs)
- SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2008.
Download “Troubleshooting Performance Problems in SQL Server 2008” from the Microsoft Download Center.
Abstract courtesy : Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)
3 Comments. Leave new
When I import image field (long binary data) from ms access to ms sql server 2008 (image/var binary/binary)….color images are not comming;only b&W images are importing…color images rows are comming blank..
plz help to solve this.
Hi Pinal
Thanks for the article
I’m asked questions like this in many interviews, how to trouble shoot sql server performance problem or how to trouble shoot stored procedure performance problem.
It would be very nice if you write one about this in short(not that much wide in the document specified in this article). If you already written please specify here
Come on! keep writing, we shall keep learning !
Asharaf
Really helpfu!