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

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

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

????????????-??????????????????????????????-????????????????????????????-???м?????????????????????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???????????? ??