?й?????????????????????
???????????? ???????[ 2011/8/31 11:41:05 ] ????????
?????????????????
????????????????????????????????????????????????????????????
?????????????????????????
????????????-??????????????????????????????-????????????????????????????-???м?????????????????????web?????????-??????????SQL?????????????????????????
???????????????????????ж????????????????????????????????????????Щ????????????????????????????????????????????????????????£?????????????????????
??????????????У????????? ????Ч
??????????????
1????????????й????е??????????
2???????????????????????????
????????????????????????
?????????
1??Error: Failed to connect to server ??payment.baihe.com?壺 [10060] Connection
Error: timed out Error: Server ??user.baihe.com?? has shut down the connection prematurely
??????
A????÷????????
??С????????????????????????????????????
B????÷????????
????÷??????????????
?????????????????Weblogic??÷?????????????????????????д???????????п?????Weblogic?е?server????AcceptBacklog???????ù???????????????connection refused???????????????????????25??
C????????????
??1??????÷????????????????С?? 2????????????????????????????????й????
2??Error: Page download timeout ??120 seconds?? has expired
??????????????????????
A????÷??????????????·??????????
B????????????
C???????????????????????
???????????????????????????
1.???????????
???????????????????????????繃??????????????????????????????????????????
??????????У?????????????3?????????????????????????????shutdown?????????????????????£?????????????????????????????????????????????????г??????????????????????
??????????????????????????????????????????????????????????????????????????OK????????????????????????????????????????????????????????
2.????????????
????????????????????????????????????????????????????á?????????????????????????????????????????????????
???????????????????????????????????????????????????Щ????????????????????????????????й??
????????????????????????????????????????????????????????????????????????????????????????????????á?????????????????????????????????????
2-5-10???????????????????2????????????????о??????????????????2-5???????????????о????????????????????????5-10????????????????о?????????????????????????????????????????10????????????????????о??????????????????????????????????????Web??????????????????
3.???????????????
??棺
1??UNIX????????????????????????Paging rate??????????????????????????????????檔???????????????????????????????????????????????
2??Windows???????У????ProcessPrivate Bytes????????ProcessWorking Set???????????????????????????MemoryAvailable bytes??????????????????????????????й???
??????????????????????????
?????????high pageout rate????
?????????????
?????????д?????????????
?????????CPU???????
??治???????out of memory errors??
????????
1??UNIX???????Windows???????????????CPU??????CPU utilization??????????????????95%???????????CPU?????????????????????????????????????????????????????SQL Server???????????????80-85%
?????????Χ??60%??70%??
2??Windows???????У????SystemProcessor Queue Length????2?????????????????Processor Time??????????????????????????
CPU???????????????????????
????????????slow response time??
CPU??????????zero percent idle CPU??
???????????CPU???high percent user CPU??
??????????CPU???high percent system CPU??
???????к???????н?????У?large run queue size sustained over time??
????I/O??
1??UNIX???????Windows????????????????????????Disk rate????????ò??????????????I/O??????????????????????????
2??Windows???????У???? Disk Time??Avg.Disk Queue Length?????????Page Reads/sec????????????????????????????????
I/O?????????????????????? :
???????????????high disk utilization??
?????????????У?large disk queue length??
???????I/O??????????????????large percentage of time waiting for disk I/O??
????????I/O?????large physical I/O rate??not sufficient in itself??
???????????????low buffer cache hit ratio??not sufficient in itself????
????????н?????У???CPU????У?large run queue with idle CPU??
4.????????????
SQL Server?????
1??SQLServer??????????????????Cache Hit Ratio????????????á????????????80%?????????????檔
2?????Full Scans/sec????????/????????????????1??2?????????????????????????????????裬???SQL???????????????
3??Number of Deadlocks/sec????????????/????????????ó??????????????к????????????????????顣?ü?????????????0??
4??Lock Requests/sec????????/??????????????????????????????????ü??????????
Oracle?????
1????????????????0????????????????????????С??0.90????????????SHARED_POOL_SIZE???С??
2???????????????????С??0.90???????????DB_BLOCK_BUFFERS???????????λ???飩??
3?????????????????????????????LOG_BUFFER?????????
4??????????????????С??0.95????????SORT_AREA_SIZE???????????? ??
????????????????????????????????????????????????????????????
?????????????????????????
????????????-??????????????????????????????-????????????????????????????-???м?????????????????????web?????????-??????????SQL?????????????????????????
???????????????????????ж????????????????????????????????????????Щ????????????????????????????????????????????????????????£?????????????????????
??????????????У????????? ????Ч
??????????????
1????????????й????е??????????
2???????????????????????????
????????????????????????
?????????
1??Error: Failed to connect to server ??payment.baihe.com?壺 [10060] Connection
Error: timed out Error: Server ??user.baihe.com?? has shut down the connection prematurely
??????
A????÷????????
??С????????????????????????????????????
B????÷????????
????÷??????????????
?????????????????Weblogic??÷?????????????????????????д???????????п?????Weblogic?е?server????AcceptBacklog???????ù???????????????connection refused???????????????????????25??
C????????????
??1??????÷????????????????С?? 2????????????????????????????????й????
2??Error: Page download timeout ??120 seconds?? has expired
??????????????????????
A????÷??????????????·??????????
B????????????
C???????????????????????
???????????????????????????
1.???????????
???????????????????????????繃??????????????????????????????????????????
??????????У?????????????3?????????????????????????????shutdown?????????????????????£?????????????????????????????????????????????????г??????????????????????
??????????????????????????????????????????????????????????????????????????OK????????????????????????????????????????????????????????
2.????????????
????????????????????????????????????????????????????á?????????????????????????????????????????????????
???????????????????????????????????????????????????Щ????????????????????????????????й??
????????????????????????????????????????????????????????????????????????????????????????????????á?????????????????????????????????????
2-5-10???????????????????2????????????????о??????????????????2-5???????????????о????????????????????????5-10????????????????о?????????????????????????????????????????10????????????????????о??????????????????????????????????????Web??????????????????
3.???????????????
??棺
1??UNIX????????????????????????Paging rate??????????????????????????????????檔???????????????????????????????????????????????
2??Windows???????У????ProcessPrivate Bytes????????ProcessWorking Set???????????????????????????MemoryAvailable bytes??????????????????????????????й???
??????????????????????????
?????????high pageout rate????
?????????????
?????????д?????????????
?????????CPU???????
??治???????out of memory errors??
????????
1??UNIX???????Windows???????????????CPU??????CPU utilization??????????????????95%???????????CPU?????????????????????????????????????????????????????SQL Server???????????????80-85%
?????????Χ??60%??70%??
2??Windows???????У????SystemProcessor Queue Length????2?????????????????Processor Time??????????????????????????
CPU???????????????????????
????????????slow response time??
CPU??????????zero percent idle CPU??
???????????CPU???high percent user CPU??
??????????CPU???high percent system CPU??
???????к???????н?????У?large run queue size sustained over time??
????I/O??
1??UNIX???????Windows????????????????????????Disk rate????????ò??????????????I/O??????????????????????????
2??Windows???????У???? Disk Time??Avg.Disk Queue Length?????????Page Reads/sec????????????????????????????????
I/O?????????????????????? :
???????????????high disk utilization??
?????????????У?large disk queue length??
???????I/O??????????????????large percentage of time waiting for disk I/O??
????????I/O?????large physical I/O rate??not sufficient in itself??
???????????????low buffer cache hit ratio??not sufficient in itself????
????????н?????У???CPU????У?large run queue with idle CPU??
4.????????????
SQL Server?????
1??SQLServer??????????????????Cache Hit Ratio????????????á????????????80%?????????????檔
2?????Full Scans/sec????????/????????????????1??2?????????????????????????????????裬???SQL???????????????
3??Number of Deadlocks/sec????????????/????????????ó??????????????к????????????????????顣?ü?????????????0??
4??Lock Requests/sec????????/??????????????????????????????????ü??????????
Oracle?????
1????????????????0????????????????????????С??0.90????????????SHARED_POOL_SIZE???С??
2???????????????????С??0.90???????????DB_BLOCK_BUFFERS???????????λ???飩??
3?????????????????????????????LOG_BUFFER?????????
4??????????????????С??0.95????????SORT_AREA_SIZE???????????? ??
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
?????????????????????д?ò??????????????????????????????Щ??????????????????????????????????????????????????????????????APP????????????????????????????????????????5??????????????????????SQL?????в??????????Щ???????裿??γ???????????????????????????????Щ???????????????????д?淶???????????????????????????????????????裿
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????