????

     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???????????? .