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

Articles with tag performance metrics Rss

Search for any content tagged performance metrics

   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,361 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,094 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,361 reads
   Items 1 to 3 of 3