List of all transactions that are running in SQL Server’s instance

microsoft_sql_server_icon (1)

     SELECT sqltext.TEXT
     ,req.session_id
     ,req.status
     ,req.command
     ,req.cpu_time
     ,req.total_elapsed_time
     ,req.blocking_session_id
     ,req.percent_complete
     ,req.estimated_completion_time/1000/60  estimated_completion_time_Min
     ,start_time
    FROM sys.dm_exec_requests req
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
    ORDER BY start_time


Categories: SQL Server, SQL Server Administration

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: