Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sys.dm_exec_query_plan Rss

   Items 1 to 6 of 6   
 

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,532 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,532 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,691 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,532 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,900 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,691 reads
   Items 1 to 6 of 6   
 
Tags
sys.dm_exec_requests (3)    
administration (2)    
lock and connection management (2)    
maintenance (2)    
maintenance and management (2)    
performance tuning (2)    
sql server 2005 (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
troubleshooting (2)    
t-sql (2)    
utility (2)    
sp_who2 (1)    
spid (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
sys.sysprocesses (1)