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

Content with tag Processes Rss

   Items 1 to 10 of 10   
 

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,855 reads

SQL Monitor Metric: Processes in a runnable state (scheduler query)

Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.   Read more...
By Press Release 2013/12/03 | Source: SQL Monitor Metrics | Category: monitoring
Rating:  Rate this |   Briefcase | 2,973 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,855 reads

Quick check SQL connection and process details with current SQL text

This script will be useful to quickly check incase of any blocking or log wait occurs  Read more...
By Venugopal Saride 2011/12/30 | Source: SQLServerCentral.com | Category: connections
Rating: |  Discuss |   Briefcase | 1,421 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,855 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,222 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,855 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,855 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,222 reads

Terminate All User Processes Without Stored Procedure in SQL Server

This script kill all connections on the specified database without stored procedure.  Read more...
By andre.brunaldi 2008/09/10 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 249 reads
   Items 1 to 10 of 10   
 
Tags
monitoring (3)    
blocking (2)    
connections (2)    
activity (1)    
enhancement (1)    
kill (1)    
locking (1)    
metrics (1)    
performance monitoring (1)    
schedulers (1)    
sp_who (1)    
sp_who2 (1)    
users (1)