Title: Performance Baselining, Benchmarking, and Monitoring ILL
Abstract: It’s impossible to truly tune a SQL Server without a good understanding of its performance profile and work load. This instructor-led lab will interactively teach you the techniques and procedures to assess the baseline performance profile of a SQL Server, benchmark the performance of the server under varying work loads, and how to continuously monitor the server for maximum availability and performance. You will learn how to use the native Microsoft tools to run baseline and benchmark tests. In addition to the main objectives, this session will help you:
- Learn how to set up baselines, benchmarks, and monitoring
- Learn major PerfMon counters that are important for baselining, benchmarking, and monitoring
- Learn how to correlate results from PerfMon, SQL Profiler, and other tools to get a cohesive understanding of testing results
- How to use the native Microsoft tools for long-term alert monitoring of the SQL Server instance
Audience: DBA, Developer
Track: DBA, AppDev
Prerequisites: Basic database administration skills and Windows Server OS management skills.
Will the presentation include real world examples? No, examples from the TPC-H benchmark will be used.
Was the presentation delivered before? Yes, a spotlight session at previous PASS events and as a standard session on TechEd 2007 in Orlando. The session scored a 7.45.
Rate it! Rate my session and offer feedback here.