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

Content with tag performance metrics Rss

   Items 1 to 3 of 3   
 

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,295 reads

SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB

Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.  Read more...
By Press Release 2013/10/15 | Source: Red-Gate | Category: custom metrics
Rating: (not yet rated)  Rate this |   Briefcase | 3,083 reads

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,295 reads
   Items 1 to 3 of 3   
 
Tags
custom metrics (1)    
performance tuning (1)    
profiler (1)    
server side trace (1)    
sql monitor (1)    
trace (1)