End-to-End Troubleshooting for Microsoft SQL Server 2005/2008
Play End-to-End Troubleshooting for Microsoft SQL Server 2005/2008
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 takes 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 details and demonstrates: -Performance Monitor (PerfMon) -SQL Profiler/Server-side Trace -Correlating PerfMon and Profiler results -Graphic Explain Plan and Transact-SQL Showplan -SQL Server 2005 and 2008 DMVs -When to use Trace Flags 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.