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

Content with tags Administration, Troubleshooting Rss

   Items 1 to 7 of 7   
 

sp_who3

A compatibility view for DBAs used to using sp_who2  Read more...
By gerhard-356547 2011/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,937 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,495 reads

View Errors in the Default Trace

Returns records with errors from the default trace ordered by most recent first  Read more...
By Jon Morisi 2009/11/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 645 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,495 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,648 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,495 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,648 reads
   Items 1 to 7 of 7   
 
Tags
maintenance and management (3)    
utility (3)    
lock and connection management (2)    
maintenance (2)    
performance tuning (2)    
sql server 2005 (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
t-sql (2)    
dba (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)