??θ????????????λ

????2????÷???????????м????????????CACHE??

????3?????????????????????÷???????????????????????????CPU????棬????????

????4??????????????ORACLE?????SYS???????Щ????????

????5????ó??????????

????????????????????e?????????????????У????????????????????????????????????????????????????????????ó????????????????????WEB???????????HTTP400??500??????????Щ???????????????????????????????·??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????+?????????????????????????????????????????????????????????????????????????????????????????????Щ???????????????

??????÷??????????λ????????????У??????????к?????????ο?????????tomcat??weblogic??????????????????о???????????????????????????Щ?????Щ???????????????????????????????????????????????????????????JAVA_OPTS???????maxThreads??time_out?????????????????loadrunner/" target="_blank" >LR??Jemeter??webload????????????????????????????÷??????????????????÷??????????????????????log4j.properties???????????????????????????????????????÷????????

????????????????λ???????????????к????????????ο??????????????????LR????У?????????????????еó??Щ??????????nagios??cacti???????????????????Щ??????????Щ???????????á????????????????????????????ó??????????????????????????λ???????????ó???????????????λ???

??????????????е?????????????????????????????????????????????????????????????????????????????????????????????????????λ??????????磺??????V$sys_event??V$sysstat??v$syssql???????????????????????μ??????????????????????????????棬???????????

??????ó??????????????????????????????????????????????????????У????λ???????????????????????????н??????У????????????jprofiler???????????????????????????????????????????????????????????????????

???????????????????????Щ????????CPU????棬????????????????????????????????????????????????г???????λ????????????????????????????

??????????治?????

????????1??

??????????????Memory Available MBytes ??Memory??Pages/sec?? page read/sec?? Page Faults/sec

???????ο??????

??????? Page Reads/Sec ???????????? 5???????????治??

????Page/sec ???00-20(??????????????????洦???乤???????????????????????????80???????????)??

????????2??????Physical Disk ????????????

??????????????Memory Available MBytes ??Pages read/sec??%Disk Time ?? Avg.Disk Queue Length

???????ο??????%Disk Time???????90%

????????治??????е??????????????????У?????????????????????????????????????????????CPU?????????????????????????棬??????е?????????????

???????????й??

??????????????Memory Available MBytes ??ProcessPrivate Bytes??ProcessWorking Set??PhysicalDisk/%Disk Time

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

????Windows???????У????ProcessPrivate Bytes????????ProcessWorking Set???????????????????????????MemoryAvailable bytes??????????????????????????????й??????й??????????????????????о?????????????涼????????ó?????????????????顣

????CPU????

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

????System %Processor Time CPU??Processor %Processor Time CPU

????Processor%user time ??Processor%Privileged Time

????systemProcessor Queue Length

????Context Switches/sec ??%Privileged Time

???????ο??????

????System\%Total processor time??????????90%????????????????SQLServer???????????????80-85% ???????????Χ??60%??70%??

????Processor %Processor TimeС??75%

????systemProcessor Queue Length???С??CPU??????????+1

????CPU???????

????1??System\%Total processor time??????????????90%??????洦????????????????????????????????????????.

??????????Щ??CPU???У?????????????????????CPU??????????????????????????????????????????????????.

????2????????????????Processor %Processor Time???????????????????????????????????????????CPU ?????(??治??????е??????????????????У?????????????????????????????????????????????CPU?????????????????????????棬??????е?????????????)

????????CPU?????????

?????????г????????????????????CPU????

?????????????臨????????? where ???order by?? group by ??????CPU??????????

??????治??IO???????????CPU?????????

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