RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Jun 19 2008 9:39 PM GMT
by Mrdenny
Here are the basic definitions.
Full Scans/sec - Number of table or index scans done per second.
Checkpoint pages/sec - Number of data pages written to disk per second during the checkpoint process
Transactions/sec - Number of active transactions per second in the database
User Connections - Number of sessions currently active in the server
Average Wait Time (ms) = Average amount of time sessions are waiting for resources to become available (locks, disk, cpu, etc)
Lock Waits/sec - The number of locks which are initialed per second
Number of Deadlocks/sec - The number of deadlocks per second
Target Server Memory(KB) - The maximum amount of memory the SQL Server can use.
Total Server Memory (KB) - The total amount of memory the server has installed
Batch Requests/sec - The number of baches being executed per second against the SQL Server instance.
Here are some numbers to keep in mind.
Full Scans/sec - As low as possible. The closer to 0 the better.
Checkpoint pages/sec - This is really out of your control.
Transactions/sec - This is really out of your control
User Connections - This is really out of your control
Average Wait Time (ms) - You want this as low as possible. The longer this is the longer your queries take to run
Lock Waits/sec - You want this as low as possible. The longer this is the longer your queries take to run
Number of Deadlocks/sec - This should be 0.
Target Server Memory(KB) - How ever much memory you set SQL Server for. About 75% of physical memory.
Total Server Memory (KB) - This is how much memory is installed.
Batch Requests/sec - This is really out of your control
SQL Server, Performance monitoring, Performance counters
Could you please describe the following performance monitoring counters, what they mean and the range to which they are acceptable?
