January 8, 2018 at 1:07 pm
Comments posted to this topic are about the item SQL Server Long Query Script
SQL Server Consultant
yusufkahveci@sqlturkiye.com
www.sqlturkiye.com
May 30, 2018 at 4:11 am
Seems really useful thanks, but what unit of time are the max elapsed time and avg elapsed time in? (seconds, milliseconds etc)
Thank you
Joe
May 30, 2018 at 5:45 am
joseph.williams 87509 - Wednesday, May 30, 2018 4:11 AMSeems really useful thanks, but what unit of time are the max elapsed time and avg elapsed time in? (seconds, milliseconds etc)Thank you
Joe
As from BOL / MSDN / docs:
"max_elapsed_time........bigint........Maximum elapsed time, reported in microseconds (but only accurate to milliseconds), for any completed execution of this plan."
If you repace the max-duration and avg fields with the SQL code below, the result will show the values converted to the TIME datatype (which is more human friendly readable)
-- ,eqs.max_elapsed_time AS sqltr_maxelapsedTime
,cast(dateadd(MILLISECOND, eqs.max_elapsed_time/1000, '0:00:00') as time(3)) AS sqltr_maxelapsedTime
-- ,ISNULL(eqs.total_elapsed_time / NULLIF(eqs.execution_count, 0), 0) AS sqltr_avgElapsedTime
,cast(dateadd(MILLISECOND, ISNULL(eqs.total_elapsed_time / NULLIF(eqs.execution_count, 0), 0)/1000, '0:00:00') as time(3)) AS sqltr_avgElapsedTime
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy