☰

SQL Server Management Studio, how to get execution time down to milliseconds Ask Question

tag-icon • tag-icon sql-server ssms sql-server-2008
SQL Server Management Studio, how to get execution time down to milliseconds Ask Question

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:

ここに画像の説明を入力してください

ベストアンサー1

What you want to do is this:

set statistics time on

-- your query

set statistics time off

That will have the output looking something like this in your Messages window:

SQL Server Execution Times: CPU time = 6 ms, elapsed time = 6 ms.

おすすめ記事