????2???????????λ?????????

????2.1 ???????????

??????????????????????飬??AIX????????????????????￡?????????????ο??????л??????

????2.2 ??????????????

???????????

?????????????????????????TPS??仯??????????￡?????????????????????????????????????????????????????????????仯???????????????????????????????????????з???????????????????????????????

???????????

????????????????е??????????????Paging rate?????????????????????????????檔?????????????λ????????????????????????????????????????????????????“Swap in rate”??“Swap out rate”?????????з?????

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

???????CPU??????CPU utilization?????????????95%???????????CPU?????????????????????????????????????????????CPU?????????Χ??60%??70%??

???????????

????????????????Disk rate???????????????I/O?????????????????????????????2????????????????????Tempdb in RAM??????“max async IO”??“max lazy writer IO”??????????????

?????????壺

????Tuxedo???????????????е????????Bytes on queue???????г??????????????????1.5~2???????????????????????

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

????SQLServer??????????????????Cache Hit Ratio????????????á????????????80%?????????????檔???ò???????SQL Server??????????????????????о?????????????????????????????