glen berrys script results

• PearlJammer1

  SSCrazy Eights

  Points: 8495

  More actions

  November 18, 2014 at 4:17 am

  #292570

  Hi

  I am using Glen Berry's sql server diagnostics scripts and was wondering how I tell if the results returned are in micro seconds or milli seconds.

  One the scipts im using is :

  SELECT TOP(25) p.name AS [SP Name], qs.total_elapsed_time/qs.execution_count AS [avg_elapsed_time],

  qs.total_elapsed_time, qs.execution_count, ISNULL(qs.execution_count/DATEDIFF(Second, qs.cached_time,

  GETDATE()), 0) AS [Calls/Second], qs.total_worker_time/qs.execution_count AS [AvgWorkerTime],

  qs.total_worker_time AS [TotalWorkerTime], qs.cached_time

  FROM sys.procedures AS p WITH (NOLOCK)

  INNER JOIN sys.dm_exec_procedure_stats AS qs WITH (NOLOCK)

  ON p.[object_id] = qs.[object_id]

  WHERE qs.database_id = DB_ID()

  ORDER BY avg_elapsed_time DESC OPTION (RECOMPILE);

  How do you tell ??

  Thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 18, 2014 at 5:09 am

  #1759222

  Microseconds.

  See sys.dm_exec_procedure_stats

  -- Gianluca Sartori