October 7, 2015 at 10:47 am
How to find what query caused performance issues in last 30 mins. I do load top 10 queries in temp table every 15 mins. However, it does not help much.
Thanks
October 7, 2015 at 11:02 am
have you checked out Find Most Expensive Queries Using DMV[/url]
Gerald Britton, Pluralsight courses
October 7, 2015 at 1:28 pm
Yes, i did. It will give me the top 10 current running queries. However, i am looking for something like 30 mins before.
Thanks
October 7, 2015 at 3:44 pm
If you don't have something like Extended Events already capturing your data, then you're completely dependent on what is currently in cache accessed through the Dynamic Management Views (DMVs). The problem with the DMVs is that they only show aggregate information. It won't show individual query calls. So while you can see which queries are currently in cache and you can see which queries have been called within the last 30 minutes, you won't be able to tell which of these queries is the highest cost within the last 30 minutes.
However, the place to start is sys.dm_exec_query_stats and then go from there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply