Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is still slow on newer, faster hardware, but not as a slow as it was.
However, sooner or later, you’re going to have to start to spend time fixing queries. In fact, you can find that fixing queries actually is more cost effective than buying more hardware. The problem is, query tuning is not easy.
So, what do you do?
Microsoft Can Help
There are a number of tools available to you, right now, provided by Microsoft that can help you better and more easily tune your queries. This ranges from extended events to query store, and absolutely includes execution plans and other tools in and around SQL Server Management Studio.
However, even using these tools well requires time and knowledge. I want to help. That’s why I put together my all day seminar on query tuning tools. I’ve given this seminar around the world. In April, I’m presenting it at SQLIntersection/DevIntersection (this is a great session for developers, tell your friends).
To help you get there, I’ve got a discount code. Register for the event using the code FRITCHEY and you’ll save $50. Follow this link.
Scroll to the bottom here to read about the seminar (and see what other sessions I’m presenting). I know I can make it at least a little bit easier for you to learn how to identify and fix queries.