SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag sys.dm_exec_requests Rss

Search for any content tagged sys.dm_exec_requests

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   

Using sys.dm_exec_requests to estimate completion time for a process

The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.  Read more...
By Smitha Reddy 2011/10/05 | Source: SQLServerCentral.com | Category: sys.dm_exec_requests
Rating: |  Discuss |   Briefcase | 1,722 reads

SQL Process % Complete

Display %complete SQL using SYS.DM_EXEC_REQUESTS 
By Mehernosh 2011/08/05 | Source: SQLServerCentral.com | Category: sys.dm_exec_requests
Rating: |  Discuss |   Briefcase | 2,145 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...
By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,621 reads

Indepth SPID information

This SP gives you most of the detail you need on a long running query. Simply pass the SPID.  Read more...
By Amar P 2009/01/09 | Source: SQLServerCentral.com | Category: sp_who2
Rating: (not yet rated) |  Discuss |   Briefcase | 1,939 reads

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...
Rating: |  Discuss |   Briefcase | 5,768 reads
   Items 1 to 5 of 5