Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when.
In this full day seminar, a proven methodology will be illustrated through complete demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper―pinpointing the exact problem and helping you to quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.
Courseware booklets, lunch, and morning/afternoon coffee included.
Module 1: Baselining Methodology
- What is a baseline, and why should you care?
- How do you create meaningful benchmarks?
- How should you collect baseline data?
- What kinds of testing should be done?
Module 2: Performance Counters
- Which counters, specifically, should you look at?
- What, exactly, do all of these counters actually indicate?
- How should you analyze counter data?
- How should you not analyze counter data?
Module 3: Waits and Queues
- What is a wait? What is a queue? Why should you care?
- How do you collect the waits data that SQL Server exposes?
- How do you baseline wait stat information?
- What are the most important wait stats to pay attention to, and what do they actually indicate?
Module 4: Real-Time Activity DMVs
- How do you get more pointed and in-depth information about what’s happening in your SQL Server instance?
- Why are there so many DMVs? Which ones are actually important to understand?
- How do you baseline some of the data from the DMVs?
- What information will help you solve real problems, in your real SQL Server instances, when those problems are actually occurring?
Module 5: Query Plan Analysis
- What are the top 5 things that you can quickly look for to identify problems with query plans?
- How can you understand when and why plan regressions occur?
Intended AudienceDatabase professionals, including both DBAs and developers, who are interested in learning how to attain better SQL Server performance.
PrerequisitesAt least two years of experience is recommended.
What You Will LearnIn this full day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues.
Adam Machanic is a Boston-based database consultant, writer, and speaker, as well as the founder of Data Education. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications.
Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press, 2009) and Expert SQL Server 2005 Development (Apress, 2007).
Address: Your City?
Registration: TBD Click here to request this course
Data Educaiton accepts Visa, MasterCard, Discover, American Express, PayPal, eCheck, personal & business checks and purchase orders.
Course Time: 9:00 AM to 4:30 PM
Download the full course details in a convenient PDF
Using a Purchase Order or Check?
If a purchase order is required for invoice, please send us the P.O. number using our contact form. Be sure to indicate the course title and attendee name(s) in your message.
We accept personal and business checks for course registrations up to 15 business days before the start date of the desired course. If paying by check, remember that it can take up to 5 business days to arrive at our office through postal mail depending on your location. Please include a note telling us the course title and attendee name(s), and make your check payable to:
15 Lincoln Street
Wakefield, MA 01880