All geek questions in one place

What is SQL Server runtime?

I have a query that I run in two equivalent databases, but is hosted on separate MS SQL 2005 servers. I want to measure the query time on both servers and thus tried the following:

SET STATISTICS TIME ON GO SELECT TOP 10000 * FROM table GO SET STATISTICS TIME OFF; GO

And got the following result:

 SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 2 ms. (10000 row(s) affected) SQL Server Execution Times: CPU time = 16 ms, elapsed time = 8143 ms. SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 0 ms.

My question is: what does SQL Server runtime mean? Is this a query execution only in the database, or is it a query execution, including transferring data back to a client running SQL Server Management Studio?

Thanx in advance!

+4
source share
1 answer

Elapsed time = total request execution time (including I / O pending)

CPU time = total CPU time.

A useful article on this subject is at http://www.sqlservercentral.com/articles/Performance+Tuning/measuringperformance/1323/

+3
source

Source: https://habr.com/ru/post/1313506/

More articles:


All Articles