2022年服务器压力测试报告 .pdf

1 压力测试报告Document IDRevision Confidential 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页，共 29 页 - - - - - - - - - 2 目录目录 .21.引言 .41.1编写目的 .41.2术语缩写词 .42.系统介绍 .43.测试目的 .44.测试环境 .44.1网络拓扑图 .54.2硬件环境 .64.3软件环境 .64.4数据环境 .65.测试工具和测试方法.75.1测试工具 .75.2测试策略 .76.测试结果 .86.1场景一 .86.1.1场景描述 .86.1.2执行时间 .86.1.3执行结果 .86.1.4客户端响应情况.116.1.5应用服务器资源使用情况.136.1.6数据库服务器资源使用情况.136.2场景二 .146.2.1场景描述 .146.2.2执行时间 .146.2.3执行结果 .146.2.4客户端响应情况.196.2.5应用服务器资源使用情况.19名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页，共 29 页 - - - - - - - - - 3 6.2.6数据库服务器资源使用情况.206.3场景三 .206.3.1场景描述 .206.3.2执行时间 .206.3.3执行结果 .216.3.4应用服务器资源使用情况.236.3.5数据库服务器资源使用情况.236.4场景四 .246.4.1场景描述 .246.4.2执行时间 .246.4.3执行结果 .246.4.4应用服务器资源使用情况.256.4.5数据库服务器资源使用情况.267.测试结果分析.268.测试过程遇到的问题和解决方法.289.总结 .29名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页，共 29 页 - - - - - - - - - 4 1. 引言1.1编写目的编写本方案的目的是统计和分析压力测试数据，并从中挖掘分析应用程序的潜力和瓶颈。1.2 术语缩写词缩写、术语解 释Application Server 应用服务器，把分派服务器和功能服务器集成在一台服务器上。 虚拟用户 LoadRunner模拟客户端的模拟的用户。 基准值以一个数值为起始标准，其他相对与标准的数值；（假设，一个月修改一次汇率，查询报表30 次，新增委托单 300次，那么可以以修改汇率为起始标准 1，那么报告对应的就是 30 ，新增委托单为300）。比例 这是以基准值为计算数值，当前基准值除于所有基准值总和就得到了当前操作的比例，即当前操作被执行的概率。 3G开关 这是 win32 操作系统提供的一个控制单个进程使用最大内存是否可以达到3GB的启动项（默认不启动的情况下，单个进程最大可使用2GB的内存），Client 测试客户端，用于模拟虚拟用户进行测试的PC机。 2. 系统介绍被测系统使用XXX ERP 系统 XXX 。3. 测试目的本测试是为了了解XXX 系统在不同的工作模式下，应用服务器和数据库服务器的负载能力、稳定性以及整体性能。4. 测试环境名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 4 页，共 29 页 - - - - - - - - - 5 4.1网络拓扑图XXX 测试系统拓扑图（场景一、二使用的环境）XXX 测试系统拓扑图（场景三、四使用的环境）说明：场景一、二是在上海公司的局域网中测试的，场景三、四的测试是外网和内网一起使用的情况，外网通过VPN 连接到公司名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 5 页，共 29 页 - - - - - - - - - 6 4.2硬件环境机器类型CPU 内存硬盘备注测试客户端 2.66G P4D1G 80 SATA应用服务器4*3166 Mhz Xeon4G 36.4G SCSI 15K4*3166 Mhz4G 36.4G SCSI 15K数据库服务器 （集群）4*2195 Mhz 2G 36.4G SCSI 15K 磁盘柜10*72.GB 15K （转速）型 号 : HP StorageWorks Modular Smart Array 100 网络交换机CISCO WS-C3560G-24TS4.3软件环境机器类型操作系统软件要求备注数据库服务器 Windows 2000 Server SQL SERVER 2000 功能服务器 Windows 2000 Server Microsoft.Net Framework 1.1 IIS5.0 客户端 Windows XP/Windows 2003 ServerMicrosoft.Net Framework 1.1 4.4数据环境主要表的数据量描述主表名数据量(万条) OZ_BK_HEADER 203 OZ_BK_CONTAINER 300 OZ_BK_CARGO 200 SZ_FREIGHT 1800 SZ_LEDGER_COMP 500 RP_INVOICE_DOC 500 AIR_BK_HEADER 340 QZ_OF_COST_PRICE 200 QZ_QUOTATION_BUSINESS_INFO 200 RP_CASH_MOVEMENT 500 SO_HEADER 200 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 6 页，共 29 页 - - - - - - - - - 7 5. 测试工具和测试方法5.1测试工具使用 XXX 自主开发的 ERP系统模拟客户端（设计原理请参见ERP系统 CHN.doc ）和 Mercury LoadRunner8.0 进行测试。5.2测试策略利用自动化负载压力测试工具LoadRunner 进行测试，在若干台PC 机上分别模拟300 个和 100 个虚拟用户同时执行业务的情景，通过可重复的、真实的测试来度量应用程序的性能。业务场景如下表，为了更好地模拟真实的情况，我们根据各种操作的频率进行划分，按照一定的比例随机执行综合操作操作基准值比例查询客户 (SearchCust) 1000 9.01% 新增接单 (NewSalesOrder) 50 0.45% 修改接单 (UpdateSalesOrder) 100 0.90% 查询接单 (SearchSalesOrder) 1000 9.01% 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 7 页，共 29 页 - - - - - - - - - 8 6. 测试结果6.1场景一6.1.1场景描述场景描述虚拟用户数 (个 ) 网络情况备注综合场景使 用 上 述测试 模型 模 拟 生产环 境下的操作client1(IP:192.168.11.188) ：100 client2(IP:192.168.11.114) ：100 client3(IP:192.168.11.12) ：100 共计： 300 局域网使用 ERP 系统；相当于 9001200 个真实用户。（说明：每个操作间隔为015 秒的随机数）6.1.2执行时间连续执行8 小时6.1.3执行结果各种操作时间按照从大到小顺序排序的前三位用特殊颜色标注，下面的数据都按照此规则标注。类型颜色备注平均操作时间最大操作时间最小操作时间zClient1 的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch3639830.28130.0312535.843750.2281620basedata362177384.3130.01562536.093750.2038910getmessage72365215410.01562539.046880.2976720newairorder75610269.915.7545.3437513.584530newbrokern734268.31250.1406259.8281250.3655480newcashmovent721218.78130.093759.5468750.3034410newcomparison748576.21880.35937515.718750.7703460newexchangerate578.7343750.031252.2031250.1532350newfreight693294.39060.078125121.95310.4248060newinvoice7201132.4220.82812511.8751.5728080newoceanorder7102757.0161.5937516.843753.8831210newsalesorder738190.96880.06258.7031250.2587650名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 8 页，共 29 页 - - - - - - - - - 9 quicksearch3728829.04690.04687512.703130.2223840searchbroker7222900.4692.67187513.296884.017270searchcashmovent36062548.7190.312519.968750.7067990searchcomparison3558911.93750.07812513.046880.2563060searchcust3536945.03130.04687512.203130.267260searchexchangerate3683621.750.0156259.9843750.1688160searchinvoice3607752.39060.015625121.70310.2085920searchmbllcl3637824.51560.0312518.921880.2267020searchsalesorder3699944.43750.062528.546880.2553220sendmessage7441573.5631.687511.546882.1150030updateairorder14208285.7812.078125123.70315.8350570updatebroker1439874.70310.187519.06250.6078550updatecashmovent1405448.78130.10937510.859380.3194170updatecomparison1347904.09380.07812510.515630.6711910updatecust1436259.71880.04687511.156250.1808630updateexchangerate1395374.98440.04687513.171880.2688060updateinvoice5932.250.259.7968750.546610updatembllcl699271.750.12536.8750.388770updateoceanorder14775761.751.359375134.68753.9009820updatesalesorder1318437.84380.0937538.828130.3322030Total 160613 75975.8593750.47303 zClient2 的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch3905595.53840.0312499.3435710.1525070basedata391786298.9240.01562541.68670.1607770getmessage7746020844.440.01562539.546120.2690990newairorder79610816.125.32802338.4055113.588090newbrokern807305.24750.12499820.296490.378250newcashmovent836210.12890.0937489.9841830.251350newcomparison733426.09160.31249414.046610.5812980newexchangerate814.8905860.0312490.6874870.0603780newfreight774143.01570.0624997.2498610.1847750newinvoice7731166.2660.81335825.327641.5087530newoceanorder7632660.7211.39059815.26613.4871830newsalesorder742138.78030.0468749.9373090.1870350quicksearch3770733.8250.04687411.234730.1946490searchbroker8023189.5912.65619918.374653.9770470searchcashmovent37962293.160.2968699.7341880.6040990searchcomparison3826796.10480.07812410.062310.2080780searchcust3919788.80790.04687410.452920.2012780searchexchangerate3831591.30860.01562510.015430.1543480searchinvoice3894460.22990.0156259.9685590.1181890名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 9 页，共 29 页 - - - - - - - - - 10 searchmbllcl3851749.34940.01562512.859130.1945860searchsalesorder4018884.02680.0624999.6873140.2200170sendmessage7491617.821.68746813.327872.1599730updateairorder15768661.6731.93746326.140125.4959850updatebroker1563559.00070.15624711.312280.3576460updatecashmovent1559432.26320.10937317.202790.277270updatecomparison1610946.61260.06249917.546540.5879580updatecust1570281.32520.03124939.233620.1791880updateexchangerate1609387.08270.03124917.187170.2405730updateinvoice4916.905930.2343711.062480.3450190updatembllcl827208.49870.10937310.109180.2521150updateoceanorder15205446.4541.31247519.327753.5831930updatesalesorder1486498.82770.07812438.530510.3356850Total 172673 73153.03039 0.42365 zClient3 的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch3292712.82810.0312539.578130.2165330basedata325735682.6720.01562542.281250.174460getmessage6546518542.060.01562543.515630.2832360newairorder6458703.5315.04687549.8281313.493850newbrokern673255.31250.1259.1406250.3793650newcashmovent605160.35940.0937510.015630.2650570newcomparison599410.98440.312511.531250.6861170newexchangerate5313.515630.031259.56250.2550120newfreight668187.76560.06259.718750.2810860newinvoice6441038.0630.82812541.921881.6118980newoceanorder6262158.3131.39062514.343753.4477840newsalesorder642124.70310.062510.156250.1942420quicksearch3276633.750.04687537.421880.1934520searchbroker6422613.3912.64062540.68754.0707020searchcashmovent31802088.0940.2968759.93750.6566330searchcomparison3259761.85940.0781259.9531250.2337710searchcust3167633.18750.04687510.1250.1999330searchexchangerate3327536.20310.01562519.984380.1611670searchinvoice3207437.34380.01562518.546880.1363720searchmbllcl3396739.56250.01562513.68750.2177750searchsalesorder3355825.1250.062510.046880.2459390sendmessage6271374.8591.6562540.218752.1927580updateairorder13297419.9381.98437526.453135.5830980updatebroker1285504.18750.1562516.921880.3923640updatecashmovent1300465.6250.10937519.109380.3581730updatecomparison1381877.92190.062515.656250.6357150名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 10 页，共 29 页 - - - - - - - - - 11 updatecust1260214.73440.031259.9843750.1704240updateexchangerate1315417.6250.04687539.203130.3175860updateinvoice4822.828130.2343756.406250.4755860updatembllcl699228.09380.10937519.796880.3263140updateoceanorder13044711.9531.2812518.81253.6134610updatesalesorder1230363.28130.07812513.68750.2953510Total 145072 63859.6718 0.44019 6.1.4客户端响应情况zClient1 平均响应图：zClient2 平均响应图：名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 11 页，共 29 页 - - - - - - - - - 12 zClient3 平均响应图：名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 12 页，共 29 页 - - - - - - - - - 13 6.1.5应用服务器资源使用情况6.1.6数据库服务器资源使用情况名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 13 页，共 29 页 - - - - - - - - - 14 6.2场景二6.2.1场景描述场景描述并发用户数网络情况备注综合场景使用上述测试模型模拟生产环境下的操作北京： 50 苏州： 50 武汉： 50 青岛： 50 上海： 100 共计： 300 上海使用局域网，其他分公司都使用VPN连接到上海的应用服务器。使用 ERP 系统 s；相当于 9001200 个真实用户。（说明：每个操作间隔为015 秒的随机数）6.2.2执行时间连续执行8 小时6.2.3执行结果zClient （上海）的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch1957487.8750.04687510.31250.2492970basedata198535099.3280.01562510.406250.2568540getmessage3974212584.420.01562512.328130.3166530newairorder4003710.8595.140625110.46889.2771480newbrokern397195.96880.12519.8750.4936240newcashmovent416157.78130.07812513.3750.3792820newcomparison392330.92190.32812519.06250.8441880newexchangerate354.8281250.031252.843750.1379460newfreight392140.06250.062510.093750.3573020newinvoice401805.5129.968752.0087280newoceanorder402969.53131.39062548.234382.4117690newsalesorder406142.40630.062510.109380.3507540quicksearch2076967.34380.04687510.593750.4659650searchbroker3841447.9222.937514.484383.770630searchcashmovent19811292.6880.312510.718750.6525430searchcomparison1901612.1250.0937510.203130.3220020searchcust1991550.51560.04687510.281250.2765020searchexchangerate1971447.51560.0156259.9843750.227050searchinvoice1936402.67190.01562510.046880.2079920名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 14 页，共 29 页 - - - - - - - - - 15 searchmbllcl2020532.39060.0312510.06250.263560searchsalesorder2020581.31250.07812510.06250.2877780sendmessage390857.3751.765625122.1983970updateairorder8493402.172260.8754.007270updatebroker785424.93750.1562520.156250.5413220updatecashmovent786411.09380.10937520.343750.523020updatecomparison741600.42190.2812520.18750.8102860updatecust784163.43750.03125100.2084660updateexchangerate792340.14060.04687519.968750.429470updateinvoice195.656250.2343750.5468750.2976970updatembllcl438163.750.10937510.109380.3738580updateoceanorder7632061.8131.29687557.52.7022440updatesalesorder786295.48440.0937519.984380.3759340Total 88206 40190.25 0.4556 zclient（北京）的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch971422.750.14062510.18750.4353760basedata98703671.2030.12525.68750.3719560getmessage198527935.1090.10937520.109380.3997130newairorder1881623.6725.45312525.734388.6365530newbrokern215132.92190.29687510.359380.6182410newcashmovent21075.093750.218758.43750.3575890newcomparison227232.79690.01562517.8751.0255370newexchangerate1914.93750.1406254.8906250.7861840newfreight201105.76560.2187510.328130.5261970newinvoice199455.28131.437526.218752.2878450newoceanorder177542.67191.67187535.43753.0659430newsalesorder19381.234380.187510.06250.4209030quicksearch969449.04690.14062510.3750.4634130searchbroker207819.65633.0625143.9596920searchcashmovent1012803.15630.45312511.421880.7936330searchcomparison948392.73440.20312510.18750.4142770searchcust1006415.53130.1562512.031250.4130530searchexchangerate929313.35940.12510.218750.3373080searchinvoice956346.14060.10937510.156250.3620720searchmbllcl948346.42190.12510.140630.3654240searchsalesorder971391.250.17187510.296880.4029350sendmessage196463.01561.87511.890632.3623250updateairorder3971662.2812.37531.328134.1871060updatebroker400405.46880.437519.3751.0136720updatecashmovent403303.93750.3437520.156250.7541870updatecomparison380416.98440.64062516.421881.0973270名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 15 页，共 29 页 - - - - - - - - - 16 updatecust399158.56250.14062510.015630.39740updateexchangerate407397.98440.26562521.328130.9778490updatembllcl217130.34380.312510.265630.6006620updateoceanorder4191212.5161.5937557.1252.8938320updatesalesorder348203.84380.312520.093750.5857580Total 43834 24925.6718750.568637 zClient （青岛）的测试结果：操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch1001629.92190.0625217.95310.6292930basedata98075831.9530.046875229.01560.5946720getmessage1932713069.660.03125226.57810.6762386newairorder1901682.755.390625100.70318.8565790newbrokern182277.31250.140625195.95311.5236950newcashmovent15747.468750.1093759.81250.3023490newcomparison196155.51560.35937518.609380.7934470newexchangerate181.4218750.0468750.3750.0789930newfreight208303.43750.09375216.06251.4588340newinvoice206600.81251.0625156.98442.9165660newoceanorder211725.84381.484375220.89063.4400180newsalesorder21448.81250.0781259.343750.2280960quicksearch1004978.48440.0625233.03130.9745860searchbroker194964.687532284.9726161searchcashmovent9971066.2810.34375206.03131.069490searchcomparison9731180.5630.125207.34381.2133220searchcust947936.98440.0625224.82810.9894240searchexchangerate994447.71880.046875222.40630.4504211searchinvoice946527.250.03125177.67190.5573470searchmbllcl978938.3750.046875211.53130.9594840searchsalesorder10431193.0780.09375219.751.1438910sendmessage218696.04691.796875220.53133.1928760updateairorder3871521.8282.062553.531253.9323720updatebroker425304.59380.20312521.890630.7166910updatecashmovent404664.23440.15625225.32811.6441440updatecomparison4231047.5940.28125213.45312.4765810updatecust382301.93750.0625196.43750.7904120updateexchangerate374362.46880.09375140.93750.9691680updatembllcl20876.328130.1718758.7031250.3669620updateoceanorder3871140.251.328125177.14062.9463820updatesalesorder359723.54690.140625201.51562.0154510Total 43360 38447.15625 0.88669 zClient( 苏州 ) 的测试结果名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 16 页，共 29 页 - - - - - - - - - 17 操作执 行 次 数（次）总耗时（秒）最小操作时间（秒）最大操作时间（秒）平均操作时间（秒）异常次数（次）备注airquicksearch972638.29390.06248117.123580.6566810basedata97397058.2870.03124795.655030.7247450getmessage1937214741.190.01562478.530240.7609530newairorder1841630.8545.31205818.751088.863340newbrokern204181.26190.20311110.750620.8885390newcashmovent185123.34390.10937710.624120.6667240newcomparison211291.19930.01562612.577961.3800910newexchangerate1328.841690.04687124.310482.2185920newfreight167111.4370.17186110.264770.6672870newinvoice180630.69311.89080781.186463.503850newoceanorder199636.47761.84318427.577773.198380newsale