SQL performance tuning is a never ending
battle. I’m not a DBA, but I am a developer who has pretended to be one for 15
years. I have worked with SQL Server databases with terrabytes of RAM all
the way down to Stackify’s massive fleet of little SQL Azure databases. I have
seen a little bit of everything over the years.
In this article, I’m going to provide some
tips for how developers can find slow SQL queries and do performance tuning in
SQL Server.
4 Ways to Find Slow SQL
Queries
4. SQL Azure Query Performance Insights
I am going to assume that SQL
Azure’s performance reporting is built on top of Extended Events. Within the
Azure Portal you can get access to a wide array of performance reporting and
optimization tips that are very helpful.
Note: These reporting
capabilities are only available for databases hosted on SQL Azure.
In the screenshot below you
can see how SQL Azure makes it easy to use your queries that use the most CPU,
Data IO, and Log IO. It is has some great basic reporting built into it.
You can also select an
individual query and get more details to help with SQL performance tuning.
Pros: Great basic
reporting.
Cons: Only works on
Azure. No reporting across multiple databases.
Next time you need to do some
performance tuning with SQL Server, you will have a few options at your
disposal to consider. Odds are, you will use more than one of these tools
depending on what you are trying to accomplish.
No comments:
Post a Comment