CODEWITHSUNDEEP
sql-serversql-server-2012sqlperformance
RPM1984
RPM1984

Reputation: 73113

How to get better insights on slow-running SQL queries

In certain periods, we are seeing slow queries on our SQL Server 2012 instance (on an Azure VM).

When analysing these queries (execution plan), there is nothing obvious wrong with the plan, and running them in management studio yields instant results.

My guess here is that there is lock contention issues.

My question is: how can i get better insights into why these queries are running slow?

Is there a third-party tool that's great for this job? (e.g Redgate SQL monitor)

From experience, the built-in SQL queries/tools that help diagnose these sorts of issues aren't very easy to use (manual queries, deadlock graphs, etc).

Can anyone point me in the right direction of either a great tool i can use, or a simple way within SQL Server to find out why they are running slow.

Thanks!

Upvotes: 2

Views: 114

Answers (1)

Doug B
Doug B

Reputation: 11

The best "free" tool that I've found is Blitz tools provide by Brent Ozar (part of first responder kit) found here.

With these tools, you should be able to spot a problem very quickly, and sp_blitzindex will give all kinds of info on indexes. You can automate/notify as you see fit.

Upvotes: 1

Related Questions