SolutionCottage.com
Posted  03 Feb 2009 - 11:38:55

Category: SQL


See last query time MSSQL

Issue:
You want to see the execution time of the last query you performed to MSSQL server.

Solution:

SELECT TOP 1 Total_Elapsed_Time/CAST(1000000 AS Float) AS ExecutionTime, * FROM master.sys.dm_exec_query_stats ORDER BY Creation_Time desc








0 comments:








© SolutionCottage 2008-2011 9/24/2017 1:05:10 PM