开发者

Ignite - How does it work?

开发者 https://www.devze.com 2023-03-12 23:32 出处:网络
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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消