-
kekline
4.71
Description:
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:
Performance Monitor (PerfMon)SQL Profiler/Server-side TraceCorrelating PerfMon and Profiler resultsGraphic Explain Plan and Transact-SQL ShowplanSQL Server 2005 and 2008 DMVsWhen 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.
Links: Slides
Comments on this Talk
Kevin presented a great overview of an end-to-end troubleshooting methodology. The talk progressed well from beginner to intermediate topics and I felt that the pace and information covered were well suited to the topic and audience. Audience questions were handled well. I was immediately able to apply the material and add to my personal methodology when I returned to work.
dschutz,
18 Aug 16:40
Kevin did a great presentation. Information was presented in an interesting format and style. Topics were covered in sufficient detail for all involved and included lots of examples. He answered all questions succintly and expertly. The material applied well to the group and to me personally.
Jeremiah Peschka,
18 Aug 01:04
This user has yet to validate her/his profile with LinkedIn. It is therefore simple to assume that she/he is but a charlatan or common hoaxster.