???????????1
??
?????????????????????????????????????????????CPU???????????????????????aggregate functions??????sum??min??max??count??????????????????????????????????????????????ü???????????????????????????????
??
???????????2
??
???????????????????????????????????????????????Web??????????÷???????????????????????????????Web???????????????????????β?????????????????????????????
??
???????????3
??
????UNIX???????NT????????????????????????????Paging rate??????????????????????????????????檔?????????????????????????????????????????????????Swap in rate?????Swap out rate??????????????
??
???????????4
??
????UNIX???????NT???????????????CPU??????CPU utilization??????????????????95%???????????CPU.??????????????????????????????????? .?????????Χ??60%??70%.
??
???????????5
??
????UNIX???????NT????????????????????????Disk rate????????ò??????????????I/O?????????????????????????????2????????????????????Tempdb in RAM??????"max async IO"??"max lazy writer IO"??????????????
??
???????????6
??
????Tuxedo???????????????е????????Bytes on queue???????г??????????????????1.5~2?????????????????????????????Raid Disk????ж???????
??
???????????7
??
????SQLServer??????????????????Cache Hit Ratio????????????á????????????80%?????????????檔???ò???????SQL Server??????????????????????о?????????????????????????????