End-to-End Troubleshooting for SQL Server
Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. This session will detail and demonstrate:
– Wait Statistics
– Performance Monitor (PerfMon)
– SQL Profiler/Server-side Trace
– Correlating PerfMon and Profiler results
– Graphic Explain Plan and Transact-SQL Showplan
– SQL Server Dynamic Management Views
These tools and techniques can make your long days shorter and make difficult troubleshooting activities much faster and easier. Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need these skills to do it.
Download it! Download the zipped slide deck here.
Rate it! Rate my session and offer feedback here.