Database Performance

Question 1

Performance Counter Acceptance over 24 hours: average latency expectations: disc Sec/Read?

Answer 1

Below 10ms is good
Between 10 and 20ms is acceptable
Between 20 and 50ms needs attention
Over 50ms is serious bottleneck

Question 2

Performance Counter Acceptance over 24 hours:

avg Disk Queue Length

Answer 2

Below 2 is acceptable and anything over 2 indicates a bottleneck

Question 3

Performance Counter Acceptance over 24 hours: percent of processor time

Answer 3

Lower than 80%

Question 4

Performance Counter Acceptance over 24 hours: buffer cache hit ratio

Answer 4

Greater than 95-97%

Question 5

Performance Counter Acceptance over 24 hours: number of deadlocks per second

Answer 5

<1

Question 6

Performance Counter Acceptance over 24 hours: Memory-Available megabytes

Answer 6

> 100MB

Question 7

Performance Counter Acceptance over 24 hours:

Paging File % Usage

Answer 7

<70%

Question 8

Performance Counter Acceptance over 24 hours:

Access Method - Worktables created/sec

Answer 8

<20

Question 9

Performance Counter Acceptance over 24 hours:

Buffer Manager: Page life expectancy

Answer 9

> 300 (or 5 minutes)

Question 10

Performance Counter Acceptance over 24 hours:

Locks: Lock Waits / Sec: _Total

Answer 10

0 or as close to 0 as possible