Main Content

Performance Baselining, Benchmarking, and Monitoring ILL

A talk by kekline

About the Talk

July 31, 2010 3:40 PM



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

Level: 200

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.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus