How to turn find out duration of SQL Query execution time

Hi everybody,

Want to share two important commands for MS SQL:

SET STATISTICS IO ON

SET STATISTICS TIME ON

After you turn it on, you may see following in the output window:

with this ouptut window you may see how long it took actually to execute some query, and if added indexes improved or didn't execution time.

What is important to pay attention to is Logical reads. Each logical read is equal to reading a chunk of 8Kb

Add comment

Loading