?????????????????????

3?????????????????

??棺

1??UNIX????????????????????????Paging rate??????????????????????????????????檔???????????????????????????????????????????????

2??Windows???????У????ProcessPrivate Bytes????????ProcessWorking Set???????????????????????????MemoryAvailable bytes??????????????????????????????й???

?????????????????????????:

????????(high pageout rate);

???????????;

?????????д????????????;

?????????CPU??????;

??治??????(out of memory errors)

????????

1??UNIX???????Windows???????????????CPU??????CPU utilization??????????????????95%???????????CPU?????????????????????????????????????????????????????SQL Server???????????????80-85%

?????????Χ??60%??70%??

2??Windows???????У????SystemProcessor Queue Length????2?????????????????Processor Time??????????????????????????

CPU??????????????????????:

????????????(slow response time)

CPU??????????(zero percent idle CPU)

???????????CPU???(high percent user CPU)

??????????CPU???(high percent system CPU)

???????к???????н??????(large run queue size sustained over time)

????I/O??

1??UNIX???????Windows????????????????????????Disk rate????????ò??????????????I/O??????????????????????????

2??Windows???????У???? Disk Time??Avg.Disk Queue Length?????????Page Reads/sec????????????????????????????????

I/O?????????????????????? :

??????????????(high disk utilization)

??????????????(large disk queue length)

???????I/O?????????????????(large percentage of time waiting for disk I/O)

????????I/O????:large physical I/O rate(not sufficient in itself)

??????????????(low buffer cache hit ratio(not sufficient in itself))

????????н?????У???CPU?????(large run queue with idle CPU)

4??????????????

SQL Server?????

1??SQLServer??????????????????Cache Hit Ratio????????????á????????????80%?????????????檔

2?????Full Scans/sec????????/????????????????1??2?????????????????????????????????裬???SQL???????????????

3??Number of Deadlocks/sec(??????????/??)??????????ó??????????????к????????????????????顣?ü?????????????0??

4??Lock Requests/sec(??????/??)????????????????????????????????ü??????????

Oracle?????

1????????????????0????????????????????????С??0.90????????????SHARED_POOL_SIZE???С??

2???????????????????С??0.90???????????DB_BLOCK_BUFFERS???????????λ???飩??

3?????????????????????????????LOG_BUFFER?????????

4??????????????????С??0.95????????SORT_AREA_SIZE???????????? ??

?:???????51Testing???????????http://www.51testing.com/html/21/n-191621.html