???????????ζ?λ???????

???????????? ???????[ 2012/7/19 16:37:52 ] ????????

??????????????????????????????????????????????????????????????????????????????????е???????????????????????????У?????????????????????????????????????????????????????????Щ???????????????????????????????????????!

???????????????????????????????????У?????????????????????????й????е????????ж?λ?????????λ?????????λ??????????????????????“???”????????????????????????????????????????????????棺

????1????????????????????????γ?????繃??

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

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

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

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

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

??????÷??????????λ????????????У? ?????????к?????????ο?????????tomcat??weblogic??????????????????о???????????????????????????Щ?????Щ????? ??????????????????????????????????????????????????????JAVA_OPTS???????maxThreads??time_out????????? ????????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????

??????????????PhysicalDisk/%Disk time??PhysicalDisk/%Idle Time??Physical Disk Avg.Disk Queue Length?? Disk sec/Transfer

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

????Windows???????У????% Disk Time??Avg.Disk Queue Length?????????Page Reads/sec????????????????????????????????
????Processor%Privileged Time?ò????????????????? Physical Disk ???????У????%Disk time ?????????????????У??????????????????????????? ???????????????????????????80%????????????й?????? Physical Disk ??????????????ü????????(Processor%Privileged Time)??????? ??????????????Ч???????????????
????Disk sec/Transfer ?????????????С??15ms????????15-30ms?????????30-60ms????????????????60ms??????????????????????RAID?????.
????Average Transaciton Response Time(?????????????)???????????仯???????????????????????????????????????????????仯????????????????????????
????Transactions per Second(????????????/TPS)????????????????/TPS????????仯??????????????????????п????????????????????
????Hits per Second(?????????)??????“?????????”???????ж???????????????????????????????????????????????????????????????????????????
????Throughput(??????)????????????????????????????????????????????????????????????????????????????????????????????
????Connections(??????)???????????????????????????????????????????????????????????????(?????????佫????)
????Time to First Buffer Breakdown(Over Time)(????λ?????????(?????仯))????????????????????????????????????????????????????
????????????????????
????1. ????????????￡?????????????(???磺?????????????????????????????????????????????????????)
????2. ???й?(???磺???????????￡???????????????????崻???)
????3. CPU??????(???磺?????????CPU????????)
????4. ???????????????????????
??????ζ?λ??Щ????????
????1. ???????????????λ???????????????????????????棬????????????????????
???????磬??崻??????????????????????????out of memory???????????????????????λ????????????????????????
????2. ?????????????????磺JAVA????B/S????????????????JDK?????Jconsole??????JProfiler?????????????????Jconsole????????????????CPU????棬??????????????仯???????