COUNTER_THRESHOLD_VALUES
S.no
|
Counter
Name
|
Threshold
Value
|
Action
to be taken
|
1
|
Memory:Available Bytes
|
> 20MB
|
|
2
|
Memory:Pages/sec
|
< 50
|
|
3
|
Memory: Free System Page Table
Entries
|
> 7000
|
|
4
|
Memory: Pages Input/sec
|
< 10
|
|
5
|
SQLServer Buffer Manger:Page Life
Expectancy
|
> 300 sec
|
|
6
|
SQL Server Buffer Manager: Page
Reads/Sec
|
< 90
|
|
7
|
SQL Server Buffer Manager: Page
Writes/Sec
|
< 90
|
|
8
|
SQL Server Buffer Manager: Buffer
Cache Hit Ratio
|
> 90%
|
|
9
|
SQL Server Buffer Manager: Total
Server Memory
|
< Target Server Memory
|
|
10
|
SQL Server Buffer Manager: Target
Server Memory
|
> Total Server Memory
|
|
11
|
SQL Server Buffer Manager: Lazy
Writes/sec
|
< 20
|
|
12
|
SQL Server Buffer Manager: Free
Pages
|
> 640
|
|
13
|
Processor: %Processor Time
|
< 80%
|
|
14
|
Processor: %Privileged Time
|
< 30% of Total Processor Time
|
|
15
|
Process(sqlserver):%Processor Time
|
< 80%
|
|
16
|
Process(sqlserver):%Privileged
Time
|
< 30% of Total Processor Time
(SQL Server)
|
|
17
|
Process(sqlservr)\Page Faults
|
Near 0 during Normal Operations
|
|
18
|
System: Context Switches/sec
|
< 3000
|
|
19
|
System: Processor Queue Length
|
2 Per CPU
|
|
20
|
SQL Server Access Methods: Page
Splits/sec
|
< 20
|
|
21
|
SQL Server Access Methods:
WorkTables created/sec
|
< 20
|
|
22
|
SQL Server Access Methods:
WorkFiles created/sec
|
< 20
|
|
23
|
SQL Server Access Methods: Full
Scans/sec
|
< 1
|
|
24
|
Network Interface : Bytes
Total/sec
|
< 50% of Network Bandwidth.
|
|
25
|
Physical Disk: Average Disk
sec/Read
|
< 8 ms
|
|
26
|
Physical Disk: Average Disk
sec/Write
|
< 8 ms
|
|
27
|
Physical Disk: Average Disk
sec/Transfer
|
< 0.3 sec
|
|
28
|
Physical Disk\%Disk Time
|
< 55%
|
|
29
|
Physical Disk:Average Disk
Bytes/Read
|
> 8192
|
|
30
|
Physical Disk:Average Disk
Bytes/Transfer
|
> 8192
|
|
31
|
Physical Disk:Average Disk
Bytes/Write
|
> 8192
|
|
32
|
Physical Disk\Current Disk Queue
Length
|
< 3
|
|
33
|
Physical Disk\Average Disk Read
Queue Length
|
< 2 * spindles
|
|
34
|
Physical Disk\Average Disk Write
Queue Length
|
< 2 * spindles
|
|
35
|
Paging File: %Usage
|
< 70%
|
|
36
|
SQLServer:General Statistics: User
connections
|
||
37
|
SQL Server: General Statistics:
Logins/sec
|
< 2
|
|
38
|
SQL Server: General Statistics:
Logouts/sec
|
< 2
|
|
39
|
SQLServer:SQL Statistics:Batch
Requests/Sec
|
< 1000
|
|
40
|
SQLServer:SQL Statistics:SQL
Compilations/sec
|
< 10% of the number of Batch
Requests / sec
|
|
41
|
SQLServer:SQL Statistics:SQL
Re-Compilations/sec
|
< 10% of the number of SQL
Compilations/sec
|
|
42
|
SQL Server:Latches:Average Latch
Wait Time (ms)
|
< 300
|
|
43
|
SQL Server:Locks:Number of
Deadlocks/sec
|
< 1
|
|
44
|
SQL Server:Locks:Lock Requests/sec
|
< 1000
|
|
45
|
SQL Server:Locks:Average Wait Time
(ms)
|
< 500
|
No comments:
Post a Comment