SQL Server Management Studio,如何将执行时间缩短到毫秒 [英] SQL Server Management Studio, how to get execution time down to milliseconds
本文介绍了SQL Server Management Studio,如何将执行时间缩短到毫秒的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我在 SSMS 中提交批处理(例如,执行查询)时,我会在状态栏中看到执行所需的时间.是否可以配置 SSMS 以显示毫秒分辨率的查询时间?
When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. Is it possible to configure SSMS to show the query time with millisecond resolution?
这是我正在谈论的栏,用红色圈出的兴趣部分:
Here is the bar I am talking about with the section of interest circled in red:
推荐答案
我一直在努力解决这个问题,直到我发现了这个...
I was struggling with that until i found this...
此外,如果您打开属性"窗口,您可能会发现一些神奇的连接已用时间",这可能会给您一些执行时间...希望能帮到你...
Also, if you open the Properties window you may find some magical "Connection elapsed time" that may give you some execution time... Hope it helps...
这篇关于SQL Server Management Studio,如何将执行时间缩短到毫秒的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文