Triaged Tester

February 16, 2009

Performance Counters – 2

Filed under: Performance,Tips — Triaged Tester @ 1:07 pm
Tags:

Performance monitor for SQL Server

Counter Name Collection Notes Comments
SQLServer:Access Methods – Full Scans / sec   Value greater than 1 or 2 indicates that we are having table / Index page scans. We need to analyze how this can be avoided. 
SQL Server:Cache Manager – Cache hit ratio   The ratio between the cache hits and misses. This counter is a good indicator of our caching mechanism in SQL Server. This value needs to be high in the system
SQL Server:Databases – Transactions/sec   This number indicates how active our SQL Server system is. A higher value indicates more activity is occurring
SQL Server:Databases – Log growths   The number of times the log files have been extended. If there is lot of activity in this counter we need to allocate static and large enough space for our log files. 
SQL Server:General Statistics – User Connections   The number of users currently connected to the SQL Server. 
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: