???????????????????Щ???????????????????????????Щ??????????????windows????????C/S????sql server???????WEB??.net???????????Щ?????????????????????????unix????oracle?????????J2EE?????WEBLOGIC???????????????????????????????????????????????
??????????????Щ?????????????????????????????????????з?????
????Memory:??????????????????????????????????????“?????”??????????治??“?????”????ó??“???”???λ?????????С????????????RAM?????????????????????????????????????Щ??????Windows 2000????????????????棬??????????????????????????????????????????????????????????????????????治??????????????μ??????????????
????Available Mbytes:?????????????.???Available Mbytes?????С??4 MB???С???????????????????????????????????????????檔
????page/sec:????????????????????????????????????????????????д????????????????????????????????pages/sec???????????????????y?????о???????????п????????????棬?????????????????????????????4k??????????????????????????Pages/sec????????????????????????????????????????????????????????
????page read/sec:?????????page/sec?????????????????????????????????????????????>5.?????á??????????????????????????
???????????????????????????????????п????????????????治????????????????????????????????о???治?????????????????????????????????μ????????????????????????????
????Physical Disk\%Disk Time
????Physical Disk\Avg.Disk Queue Length
???????磬????Page Reads/sec??%Disk Time??Avg.Disk Queue Length???????????????????????%Disk Time??Avg.Disk Queue Length?????????????д???????????????????г????????????????????δ?????????治??
???????????????????????????????Physical Disk\Avg.Disk sec/Transfer??Memory\Pages/sec????????????????????????Щ????????????????????0.1????????????????????????????????????????????????????????????????????????檔
????Page Faults/sec:???????????Ч?????????????Щ?????????????????????Щ??????????????page/sec???????????????????????????????????á?
????Cache Bytes??????????棨File System Cache?????????????50%???????????檔??IIS5.0??????治??????????????????檔???????ü???????????仯
??????????????????й????????Memory\Available Bytes??Memory\Committed Bytes???????????????????????????????й?????????Process\Private Bytes??Process\Working Set??Process\Handle Count???????????????????????????й???????ü???Memory\Pool Nonpaged Bytes??Memory\Pool Nonpaged Allocs??Process(process_name)\Pool Nonpaged Bytes??
????Pages per second:?????????????????????????????????
????Process??
????%Processor Time:?????????????????????????????????????????sql server???????????????80-85%
????Page Faults/sec:??????????????????????????????????ж????????????????????????
????Work set:???????????????????????????????????????????????????????????????????棬?????????????У????????????????????????????????????????????
????Inetinfo:Private Bytes:???????????????????????????????????????????????????????????????????????????????й??????????
????Processor??????“??????”??“??”?????????????????????????????м??????????????????????????????
????%Processor Time:??????????????95%???????????CPU???????????????????????????????????????
????%User Time:??????CPU?????????????????????aggregate functions??????????????????????????????????ü???????????????????????????????
????%Privileged Time????CPU????????????????′????????д???????????????????ò??????"Physical Disk"???????????????I/O??????????????????????????????????Tempdb in RAM??????"max async IO"??"max lazy writer IO"??????????????
??????????????????????????????е???????Server Work Queues\Queue Length???????????????????????????г??????????4???????????????????????????????????????????????????????????
????%DPC Time:?????á???????????У????????????50%????Processor:%Processor Time????????????????????????????????????????????????
????Thread
????ContextSwitches/sec:(?????inetinfo??dllhost????)??????????????????????С??????ü??????????????????????????????????????????????????????????л???????????????????????????????????????????????????л??????????ü?С?????????С??
????Physical Disk:
????%Disk Time%:??????????????????????д??????????????????????????????????????????????????????????????
????%Disk Time????????????????????У????????????????????ü?????????????Windows 2000???????д?????????diskperf-yD???????????????80%????????????й???
????Avg.Disk Queue Length:??????д??????(???????????????????ж??)???????????????????????????1.5~2?????????????????????????????Raid Disk????ж???????
????Average Disk Read/Write Queue Length:????(д??)????(?ж?)?????????
????Disk Reads(Writes)/s:????????????????????д????????????????С??????豸????????
????Average Disksec/Read:?????????????????????????????????
????Average Disk sec/Transfer:????????????????д?????????????????
????Network Interface??
????Bytes Total/sec:????????????????????????????????ж????????????????????????????ü??????????????????????
????SQLServer???????????
????Access Methods(???????)????????????????е????????????
????Full Scans/sec(??????/??)????????????????????????????????????????衣????????????????????1??2?????÷??????????????????????????裬???S Q L???????????????
????Page splits/sec(????/??)??????????2??????????????????????
????Buffer Manager(????????????)??????Microsoft®SQL Server???????????洢?????????????????????????棻????????SQL Server??????????????????????д??????????????I/O??????SQL Server??????????????????????????????????????????????洢????????о????????????????????????????????????SQL Server?????????????????????????????????????????????????????????SQL Server?????????????????
????SQL Server????????????????????????????????????????????????I/O???????????????????????I/O??????????????
????.Page Reads/sec?????????????????????????????????????????????????????????????????????????????I/O??????????????????????????????楨??????????????Ч?????????????????????????????????С??
????.Page Writes/sec(.д???/??)?????е??????????д???????
????.Buffer Cache Hit Ratio.??“?????”??Buffer Cache/Buffer Pool??????б???????????????????????????????????????????????????????????ж????????????????????????????????????????SQL Server????????????????????????????????????????????仯??С??????????????ж???????????ж??????????С??????????????????Щ??????????????????SQL Server?????????????????????????????????????????ó????????????????90%??????????????????????????????90%?????90%???????????????????????????л???????????
????Lazy Writes/sec(????д/??)????д???????д???????????????????0??
????Cache Manager(????????????)?????????????????????Microsoft®SQL Server??????????洢??????洢????????????????Transact-SQL??????????????
????Cache Hit Ratio(??????????????????Cache”???????????SQL Server?У?Cache???????Log Cache??Buffer Cache???Procedure Cache????????????????)??????????д??????????????????????SQL Server????????????????????Ч?????????????????????????????????????????80%???????????????檔
????Latches(??)??????????????????SQL Server????????????????????????????????????????????????????????
????Average Latch Wait Ti m e(m s)(??????????(????))???SQL Server????????????????????????????λ????????????????????????????????????
????Latch Waits/sec(????/??)?????????????????????????????????????????????????????????
????Locks(??)???й??????????????SQL Server???????????????SQL Server??????????????????н??е??ж??????????????????????????????????磬??????????(X)??????????????????????????????????????????????????????????????С???????????????????????????????????????????????Locks??????????????????????????????????????????
????Number of Deadlocks/sec(??????????/??)?????????????????????
????Average Wait Time(ms)(?????????(????))??????????????????????????
????Lock Requests/sec(??????/??)??????????????????????????
????Memory manager:?????????????????????????????????????????????????????????????????????SQL Server???????????????????????
????????????????????????洢????????о????????????????????????????????????SQL Server????????????????
???????????????????????????????????????????????SQL Server?????????????????
????Lock blocks:???????????????????????????????л?????????????????????????????????????
????Total server memory??sql server??????????????????????????.
????????IIS??????Щ??????
????Internet Information Services Global:
????File Cache Hits%??File CacheFlushes??File Cache Hits
????File Cache Hits%??????????????л??????д??????????????????IIS????????????????????????????????????????????????????????????80%???????File Cache Hits????????????е???????File CacheFlushes????????????????????????′???????????????????????棻??????????????е???????????????????????????????á???????File Cache Hits??File Cache Flushes??ó???????????????????????????????????????????????????????????????ο?IIS??????ObjectTTL??MemCacheSize??MaxCacheFileSize??
????Web Service:
????Bytes Total/sec:???Web???????????????????????????????????IIS??????????????????????
????Connection Refused??????????á???????????????????????????????????
????Not Found Errors????????????????????????????????????????????????HTTP??????404??