PERFMON COUNTERS
|
Memory
Resources
|
||
|
No
|
Counter Name
|
Threshold value
|
|
1
|
Memory Available Bytes
|
>20MB
|
|
2
|
Memory Pages/sec
|
<50MB
|
|
3
|
Memory Free system page
Entries
|
>7000
|
|
4
|
Memory Pages input/sec
|
<10
|
|
Processor
Resources
|
||
|
1
|
Processor:%processor time
|
<80%
|
|
2
|
Processor:%Privileged time
|
<30% of Total Processor Time
|
|
3
|
Processor(sqlserver):%processor time
|
<80%
|
|
4
|
Processor(sqlserver):% Privileged time
|
<30% of Total Processor Time (Sql server)
|
|
5
|
Processor(sqlserver) page Faults
|
Near 0 normal operations
|
|
Sql server Buffer Manager
|
||
|
1
|
Sql server Buffer Manager:
page life Expectancy
|
>300 sec
|
|
2
|
Sql server Buffer Manager:
page Reads /sec
|
<90
|
|
3
|
Sql server Buffer Manager:
page Writes /sec
|
<90
|
|
4
|
Sql server Buffer Manager:
Buffer Cache Hit Raito
|
>90
|
|
5
|
Sql server Buffer Manager:
Total Server Memory
|
< Target Server Memory
|
|
6
|
Sql server Buffer Manager:
Target Server Memory
|
>Total Server Memory
|
|
7
|
Sql server Buffer Manager:
Lazy Writes/sec
|
<20
|
|
8
|
Sql server Buffer Manager:
Free Pages
|
>640
|
|
Sql Server Access Methods: Resouuces
|
||
|
1
|
Sql Server Access Methods: Page Splits/sec
|
<20
|
|
2
|
Sql Server Access Methods: Work Tables Created/sec
|
<20
|
|
3
|
Sql Server Access Methods: Work Files Created/sec
|
<20
|
|
4
|
Sql Server Access Methods: Full
Scan/sec
|
<1
|
|
Network interface
|
||
|
1
|
Network Interface :Bytes/sec
|
<50% Network Bandwidth
|
|
Physical Disk
|
||
|
1
|
Physical Disk : Average Disk sec/Read
|
<8ms
|
|
2
|
Physical Disk : Average Disk sec/Write
|
<8ms
|
|
3
|
Physical Disk : Average Disk sec/Transfer
|
<0.3 sec
|
|
4
|
Physical Disk:% Disk Time
|
<55%
|
|
5
|
Physical Disk : Average Disk Bytes/Read
|
>8192
|
|
6
|
Physical Disk : Average Disk Bytes/Write
|
>8192
|
|
7
|
Physical Disk : Average Disk Bytes/Transfer
|
>8192
|
|
8
|
Physical Disk : Current Disk Queue Length
|
<3
|
|
9
|
Physical Disk : Current Disk Read Queue Length
|
<2 Spindles
|
|
10
|
Physical Disk : Current Disk write Queue Length
|
<2 Spindles
|
|
Sql Server
|
||
|
1
|
Sql Server : General Statistics : Logins/sec
|
<2
|
|
2
|
Sql Server : General Statistics : Logouts/sec
|
<2
|
|
3
|
Sql Server : SQL Statistics: Batch Requests/sec
|
<1000
|
|
4
|
Sql Server : SQL Statistics :Sql Compilations/sec
|
<10% of the number of Compilations/sec
|
|
5
|
Sql Server : SQL Statistics :Sql Re-Compilations/sec
|
<10% of the number of Re-Compilations /sec
|
|
6
|
Sql Server : Latches : Average latch Wait Time (ms)
|
<300
|
|
7
|
Sql Server :locks : Number of Deadlocks/sec
|
<1
|
|
8
|
Sql Server :locks : lock Request/sec
|
<1000
|
|
9
|
Sql Server :locks : Average Wait time/sec
|
<500
|
|
System
|
||
|
1
|
System : context Switches/sec
|
<3000
|
|
2
|
System: Processor Queue Length
|
2 per CPU
|
|
Paging Files
|
||
|
1
|
Paging File: %usage
|
<70%
|
No comments:
Post a Comment