Demo: Query tuning a SQL Server using Azure Monitor

So, when we’re looking at these different integrations, and looking specifically at the database ones, being able to identify which queries are running slowly, which ones need to be optimized, which ones need, you know, we’re going to want to take a look at becomes on the main use cases. We break it down in a couple of different ways.

The first one is our query execution time. So on the query execution time, we’re going to show you which queries are running the slowest based on our average execution time. So we can see here, very quickly, you know, in milliseconds…here’s the ones that are taking the longest and then a pretty steep drop off. If you’re going to try to optimize a query or take a look at which queries are going to be running the best or the worst these are two that we’re going to want to take a look at why they are running so slowly and address those immediately.

Now sometimes, it’s not just which ones run slowest, but we also want to take a look at how often they are executing. There may be something that only executed once, but they took a really long time, so that average execution time can still be very high. We also break down all these queries here by which ones are being executed the most often and we’ll also continue break it down here where by things like reads and writes. So very quickly we can take a look at “hey this one is being executed often and it’s doing a ton of reads.” Maybe we’re okay with that, maybe that’s something we wantaddress. We can see one over here that is taking a bunch of time, but let’s see where it is in the execution. So that we can just determine if it’s worth our time to drill down and try and optimize a query like that.

You’ll notice up here, the top two, we break each of these down by the databases are a part of it as well. We have two pretty pretty passive databases, I guess I call it, not doing a whole bunch here. If we do want to address that as well we can see, you know maybe this is a test database and we don’t need to care about it, or maybe this is a prod database and things are being executed much more frequently than we thought or at a much slower pace, so let’s go take a look at it that way.

Get started

Try BindPlane for free for 30 days. No credit card required.

Sign up
Have questions?
Meet BindPlane

Dive deep into documentation, data sheets, videos and more.

Ready to buy?
Let us answer your questions

Want to talk to an expert? We’re ready!

Thank you for contacting us. Your information was received. We'll be in touch shortly.