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

Content with tags Monitoring, Processes Rss

   Items 1 to 9 of 9   
 

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 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 | 3,040 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 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,245 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,442 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,245 reads
   Items 1 to 9 of 9   
 
Tags
activity (1)    
blocking (1)    
enhancement (1)    
locking (1)    
metrics (1)    
performance monitoring (1)    
schedulers (1)    
sp_who (1)    
sp_who2 (1)