October 2, 2013 at 11:56 pm
Comments posted to this topic are about the item Find Top 5 expensive Queries from a Write IO perspective
October 3, 2013 at 8:44 am
So, I ran this query, and I got 5 create statements returned. Since create statements only occur 1 time (at least, I hope I'm not recreating these statements over and over) how could the query be changed to look at recurring queries like updates and inserts?
October 3, 2013 at 8:46 am
Hi Alan,
It is basically picking up the SP's which are causing the IO. SO what u can do is scan the SP and check what is causing the io in that.
October 3, 2013 at 1:40 pm
What you're seeing is the CREATE statement which created the SP, not a new CREATE SP.
October 3, 2013 at 1:45 pm
OK, good. It makes sense that these are costly, as they're running over work tables with few indexes
April 27, 2016 at 1:59 pm
Thanks for the script.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply