THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Hey Amsterdam and Stockholm: Just Say No to Guessing About Performance!

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!

Published Friday, September 20, 2013 9:36 AM by Adam Machanic

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



S.E. said:

Hi Adam,

I'm a follower of you - why don't you come somewhat closer - for example, Vienna? Or even Budapest?

I'm sure you could still fill a conference room here as well.


September 28, 2013 5:12 PM

Adam Machanic said:

Hi S.E.,

I would love to visit either or both of those cities! Are there any local conferences, training events, or companies you can introduce me to?

Feel free to drop me a line at adam [at] sqlblog


September 29, 2013 9:07 PM

Adam Machanic said:

As previously mentioned , I'll be delivering my full-day "No More Guessing" performance troubleshooting

October 4, 2013 9:29 AM

Inge van der Zouw-Beumer said:

Thx very much! Loved your seminar in Amsterdam last Wednesday :)

November 11, 2013 5:56 AM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. 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). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement