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

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

???????????????????????????????У?????????????????????????й????е????????ж?λ?????????λ?????????λ????????????????????????????????????????????????????????????????????????????棺

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%????????????????SQL Server???????????????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????????λ???????????????仯????????????????????????????????????????????????????????

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