I got a report using ignite tool which stated that one of my stored procedure 开发者_JS百科(on sql server 2008) is taking 40.2% of total sql execution time.
It is possible if the proc is called tens of thousand of times a day or if the proc is running for 16 hours with 30 nested cursors...take a look at how many times it was executed...you can also drill down per hour in ignite and take a look at IO
精彩评论