Have SQL Server performance problems? What are you going to look at? Can you quickly isolate the root cause? Or do you ever find yourself stuck, not sure of what to do next?
That's what the No More Guessing seminar is all about.
This seminar teaches you to use:
- Baselining: An analytical methodology based on statistical analysis and evidence rather than graphs and your eyes.
- Performance counters. The right set of counters to get you where you need to be without being overwhelmed.
- Wait stats: Including what waits really mean and an extremely in-depth overview of the 15 most common waits you will encounter on real production systems.
- DMVs: The 15 DMVs that you can use to find out why things are slow on your server right now
- Query plans: The top things to look for in your biggest, most confusing plans so that you can quickly find the culprit. And, naturally, how to fix the problem.
All of these techniques will work with any version of SQL Server after 2005, although 2008 and beyond are recommended. (The seminar covers some specific very useful features added in both 2008 and 2012. As soon as 2014 is ready, I look forward to adding some really cool stuff from there as well. SQL Server 2005 just isn't as exciting as it once was.)
This November I am pleased to be teaching this seminar twice in Europe, at the two SQLRally events:
I'm also delivering two breakout sessions at each show. More information on those soon.
Hope to see you in Europe!