Post reply

sys.dm_exec_requests showing negative total_elapsed_time

  • June 1, 2011 at 12:40 pm

    #96406

    Hi all,

    I need help on the below issue.

    I am executing the below query to see the current sessions percentage of completion, estimated completion time & total_elapsed_time.

    Query:

    select R.session_id, R.blocking_session_id, T.text, r.status, DB = db_name(R.database_id),

    R.total_elapsed_time, R.percent_complete, R.estimated_completion_time

    from sys.dm_exec_requests R cross apply sys.dm_exec_sql_text(R.sql_handle) T

    Problem: : The issue im facing is the query output showing negative "total_elapsed_time" (-547334562)

    Can any one please tell me what meant by this negative time... what exactly it is showing.

    Thanks in advance.

  • June 1, 2011 at 12:43 pm

    #1332710

    Duplicate post.

    reply here

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply