Database Performance Flashcards Preview

70-464 Certification > Database Performance > Flashcards

Flashcards in Database Performance Deck (10)
Loading flashcards...
1

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

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

2

Performance Counter Acceptance over 24 hours:
avg Disk Queue Length

Below 2 is acceptable and anything over 2 indicates a bottleneck

3

Performance Counter Acceptance over 24 hours: percent of processor time

Lower than 80%

4

Performance Counter Acceptance over 24 hours: buffer cache hit ratio

Greater than 95-97%

5

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

<1

6

Performance Counter Acceptance over 24 hours: Memory-Available megabytes

>100MB

7

Performance Counter Acceptance over 24 hours:
Paging File % Usage

<70%

8

Performance Counter Acceptance over 24 hours:
Access Method - Worktables created/sec

<20

9

Performance Counter Acceptance over 24 hours:
Buffer Manager: Page life expectancy

>300 (or 5 minutes)

10

Performance Counter Acceptance over 24 hours:
Locks: Lock Waits / Sec: _Total

0 or as close to 0 as possible