Kurt Survance is a senior consultant and president of SQL Consulting. Microsoft certified since 1993, Kurt served as a subject matter expert (SME) for the preparation of the SQL Server 2008 certification exams.
Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management Studio or review in XML for more detailed information.
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More