Wednesday, 25 September 2013

COUNTER_THRESHOLD_VALUES


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: