xx销售公司财务管理信息系统sybase性能测试方案

四川XX销售公司财务管理信息系统数据库性能优化测试方案四川省XX科技有限公司目录1、方案制订目的22、方案参与人员33、平台构成331硬件平台构成332操作系统平台433数据库平台434群集软件54、当前配置参数55、测试方案1751优化SYBASE的内存使用参数1752增加SYBASE的内存使用296、系统升级建议301、方案制订目的四川XX销售公司财务管理信息系统是海量数据库系统，目前库表容量达100GB。用户使用过程中反映很慢，月底综合查询响应时长达半小时，平常录入一条财务凭证的保存需要几分钟才能完成。SYBASE性能分析I/O忙，为定性分析原因，查找系统瓶颈，达到用户要求并为用户下一步升级更新系统提供详实参考，故制定本测试方案。2、方案参与人员为充分证实主机、存储、数据库等企业级产品的卓越性能。特邀主机、存储、数据库厂商的资深专家参与修订并指导、实施本方案。并用海量数据库系统的成功经验（如电信、移动的记费系统）来指导本方案。本方案应有以下人员参与ASUN的资深主机与存储系统工程师BSYBASE的资深数据库工程师C系统集成商四川中陆科贸有限公司DSYBASE数据库维护商3、平台构成31硬件平台构成客户端E6900A分区E6800A分区E6900B分区S6900NODE1S6800NODE217FESW117GESW216FSANFCSW17EB200E光纤交换机17B16ASUN6140磁盘阵列16300GBFC磁盘（16B）SYBASE数据库存储SUN6130磁盘阵列2873GBFC图图一四川石油销售公司财务信息系统架构图系统相关设备如下数据库服务器SUNE6900服务器一台，划分为2个独立的硬件分区，分别运行SYBASE数据库和中间件，分区一和SUNE6800A分区之间通过SUNCLUSTER软件组成高可用工作方式；应用服务器SUNE6900服务器的B硬件分区，运行平台服务器；光纤交换机采用一台BROCADE3250和一台BROCADE200E组成双冗余的光纤存储区域网络（SAN），其中BROCADE3250配置8个光纤接口，目前已全部使用完，BROCADE200E配置为16口，当前激活12口，已使用10口；光纤磁盘阵列采用一台SUNST6140和一台SUNST6130。ST6140配置16块15KRPM300GB硬盘，作为SYBASE数据库的存储空间。图例SUNCLUSTER以太网络FCAL数据通道系统硬件配置详情表物理设备E6900E6900E69800分区名（DOMAIN）A分区B分区A分区SOLARISNODENAMES6900NODE1S6900NODE2LINSHOU1HOSTNAMES6900NODE1S6900NODE2LINSHOU1布置应用财务SYBASE主数据库服务器应用服务器配置清单系统板SB1SB3SB4IB8CPUCORE24X18GHZ内存48GB系统板SB5I/O板IB9CPUCORE8X18GHZ内存16GB）系统板SB0I/O板IB6CPUCORE12X12GHZ内存48GB32操作系统平台系统均运行SUNSOLARIS10GENERIC_11883336操作系统,OPENWIN38,CDE14。33数据库平台运行SYBASE125企业版数据库。34群集软件SUNCLUSTER31。4、当前配置参数A、存储阵列参数WRITEBACK已使能BLOCKSIZE512K，未针对数据库优化B、SYBASE参数1、存储使用的文件系统2、内存使用参数情况如下CONFIGURATIONFILEFORTHESYBASESQLSERVERPLEASEREADTHESYSTEMADMINISTRATIONGUIDESAGBEFORECHANGINGANYOFTHEVALUESINTHISFILECONFIGURATIONOPTIONSGENERALINFORMATIONBACKUP/RECOVERYRECOVERYINTERVALINMINUTES1PRINTRECOVERYINFORMATIONDEFAULTTAPERETENTIONINDAYSDEFAULTCACHEMANAGERNUMBEROFOAMTRIPSDEFAULTNUMBEROFINDEXTRIPSDEFAULTMEMORYALIGNMENTBOUNDARYDEFAULTGLOBALASYNCPREFETCHLIMITDEFAULTGLOBALCACHEPARTITIONNUMBER8NAMEDCACHEC_ACFZJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACFZSLCACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSJECACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSJE_UINCACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSSLCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSSL_UINCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACKMJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACKMSLCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACWLJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACXJJECACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACZRZXCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDWGSCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDWSJCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDYZDCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZHZDCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZLZDCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSACDWCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSBMJECACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSDWKMCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHSPZCACHESIZE1024MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHSPZ_UINCACHESIZE300MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHXSJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSKMXXCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSKMZXCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZBHCACHESIZE50MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZK1CACHESIZE1024MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZK1_UINCACHESIZE300MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_BMCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_CPCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_DWCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_GRCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_HSCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_KMCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_PZCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_XJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_ZXCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSWLJECACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSWLYSCACHESIZE800MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSWLYS_UINCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEDEFAULTDATACACHECACHESIZE8GCACHESTATUSDEFAULTDATACACHECACHEREPLACEMENTPOLICYDEFAULTLOCALCACHEPARTITIONNUMBER3216KI/OBUFFERPOOLPOOLSIZE20480000MWASHSIZEDEFAULTLOCALASYNCPREFETCHLIMITDEFAULTNAMEDCACHESYSLOG_CACHECACHESIZE2048MCACHESTATUSLOGONLYCACHEREPLACEMENTPOLICYDEFAULTLOCALCACHEPARTITIONNUMBER16NAMEDCACHETEMPDB_CACHECACHESIZE8192MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYDEFAULTLOCALCACHEPARTITIONNUMBER3216KI/OBUFFERPOOLPOOLSIZE40960000MWASHSIZEDEFAULTLOCALASYNCPREFETCHLIMITDEFAULTMETADATACACHESNUMBEROFOPENDATABASES20NUMBEROFOPENOBJECTS50000OPENOBJECTSPINLOCKRATIODEFAULTNUMBEROFOPENINDEXES50000OPENINDEXHASHSPINLOCKRATIODEFAULTOPENINDEXSPINLOCKRATIODEFAULTPARTITIONGROUPSDEFAULTPARTITIONSPINLOCKRATIODEFAULTDISKI/ODISKI/OSTRUCTURESDEFAULTNUMBEROFLARGEI/OBUFFERSDEFAULTPAGEUTILIZATIONPERCENTDEFAULTNUMBEROFDEVICES50DISABLEDISKMIRRORINGDEFAULTALLOWSQLSERVERASYNCI/ODEFAULTLANGUAGESDISABLECHARACTERSETCONVERSIONSDEFAULTUNICODEENABLEUNICODENORMALIZATIONDEFAULTENABLESURROGATEPROCESSINGDEFAULTENABLEUNICODECONVERSIONSDEFAULTSIZEOFUNILIBCACHEDEFAULTNETWORKCOMMUNICATIONDEFAULTNETWORKPACKETSIZEDEFAULTMAXNETWORKPACKETSIZEDEFAULTREMOTESERVERPREREADPACKETSDEFAULTNUMBEROFREMOTECONNECTIONSDEFAULTNUMBEROFREMOTELOGINSDEFAULTNUMBEROFREMOTESITESDEFAULTMAXNUMBERNETWORKLISTENERSDEFAULTTCPNODELAYDEFAULTALLOWSENDMSGDEFAULTSYB_SENDMSGPORTNUMBERDEFAULTALLOWREMOTEACCESSDEFAULTO/SRESOURCESMAXASYNCI/OSPERENGINEDEFAULTMAXASYNCI/OSPERSERVERDEFAULTPARALLELQUERYNUMBEROFWORKERPROCESSESDEFAULTMEMORYPERWORKERPROCESSDEFAULTMAXPARALLELDEGREEDEFAULTMAXSCANPARALLELDEGREEDEFAULTPHYSICALRESOURCESPHYSICALMEMORYMAXMEMORY20971520ADDITIONALNETWORKMEMORYDEFAULTSHAREDMEMORYSTARTINGADDRESSDEFAULTALLOCATEMAXSHAREDMEMORYDEFAULTDYNAMICALLOCATIONONDEMANDDEFAULTLOCKSHAREDMEMORYDEFAULTHEAPMEMORYPERUSERDEFAULTPROCESSORSMAXONLINEENGINES11NUMBEROFENGINESATSTARTUP11SQLSERVERADMINISTRATIONPROCEDURECACHESIZE2560000DEFAULTDATABASESIZEDEFAULTIDENTITYBURNINGSETFACTORDEFAULTALLOWNESTEDTRIGGERSDEFAULTALLOWUPDATESTOSYSTEMTABLESDEFAULTDEFAULTFILLFACTORPERCENTDEFAULTDEFAULTEXP_ROW_SIZEPERCENTDEFAULTNUMBEROFMAILBOXESDEFAULTNUMBEROFMESSAGESDEFAULTNUMBEROFALARMSDEFAULTNUMBEROFPREALLOCATEDEXTENTSDEFAULTEVENTBUFFERSPERENGINEDEFAULTCPUACCOUNTINGFLUSHINTERVALDEFAULTI/OACCOUNTINGFLUSHINTERVALDEFAULTSQLSERVERCLOCKTICKLENGTHDEFAULTRUNNABLEPROCESSSEARCHCOUNTDEFAULTI/OPOLLINGPROCESSCOUNTDEFAULTTIMESLICEDEFAULTCPUGRACETIMEDEFAULTNUMBEROFSORTBUFFERSDEFAULTSIZEOFAUTOIDENTITYCOLUMNDEFAULTIDENTITYGRABSIZEDEFAULTHOUSEKEEPERFREEWRITEPERCENTDEFAULTENABLEHOUSEKEEPERGCDEFAULTALLOWRESOURCELIMITSDEFAULTNUMBEROFAUXSCANDESCRIPTORSDEFAULTSQLPERFMONINTEGRATIONDEFAULTALLOWBACKWARDSCANSDEFAULTLICENSEINFORMATIONDEFAULTENABLESORTMERGEJOINANDJTC1ABSTRACTPLANLOADDEFAULTABSTRACTPLANDUMPDEFAULTABSTRACTPLANREPLACEDEFAULTABSTRACTPLANCACHEDEFAULTTEXTPREFETCHSIZEDEFAULTENABLEHADEFAULTNUMBEROFHISTOGRAMSTEPSDEFAULTSAMPLINGPERCENTDEFAULTUSERENVIRONMENTNUMBEROFUSERCONNECTIONS1000STACKSIZEDEFAULTSTACKGUARDSIZEDEFAULTPERMISSIONCACHEENTRIESDEFAULTUSERLOGCACHESIZEDEFAULTUSERLOGCACHESPINLOCKRATIODEFAULTLOCKMANAGERNUMBEROFLOCKS500000DEADLOCKCHECKINGPERIODDEFAULTLOCKSPINLOCKRATIODEFAULTLOCKADDRESSSPINLOCKRATIODEFAULTLOCKTABLESPINLOCKRATIODEFAULTLOCKHASHTABLESIZEDEFAULTLOCKSCHEMEDEFAULTLOCKWAITPERIODDEFAULTREADCOMMITTEDWITHLOCKDEFAULTPRINTDEADLOCKINFORMATIONDEFAULTDEADLOCKRETRIESDEFAULTPAGELOCKPROMOTIONHWMDEFAULTPAGELOCKPROMOTIONLWMDEFAULTPAGELOCKPROMOTIONPCTDEFAULTROWLOCKPROMOTIONHWMDEFAULTROWLOCKPROMOTIONLWMDEFAULTROWLOCKPROMOTIONPCTDEFAULTSECURITYRELATEDSYSTEMWIDEPASSWORDEXPIRATIONDEFAULTAUDITQUEUESIZEDEFAULTCURREADCHANGEW/OPENCURSORSDEFAULTALLOWPROCEDUREGROUPINGDEFAULTSELECTONSYSCOMMENTSTEXTDEFAULTAUDITINGDEFAULTCURRENTAUDITTABLEDEFAULTSUSPENDAUDITWHENDEVICEFULLDEFAULTENABLEROWLEVELACCESSDEFAULTCHECKPASSWORDFORDIGITDEFAULTMINIMUMPASSWORDLENGTHDEFAULTMAXIMUMFAILEDLOGINSDEFAULTENABLESSLDEFAULTUNIFIEDLOGINREQUIREDDEFAULTUSESECURITYSERVICESDEFAULTMSGCONFIDENTIALITYREQDDEFAULTMSGINTEGRITYREQDDEFAULTSECUREDEFAULTLOGINDEFAULTEXTENDEDSTOREDPROCEDUREESPUNLOADDLLDEFAULTESPEXECUTIONPRIORITYDEFAULTESPEXECUTIONSTACKSIZEDEFAULTXP_CMDSHELLCONTEXTDEFAULTSTARTMAILSESSIONDEFAULTERRORLOGEVENTLOGGINGDEFAULTLOGAUDITLOGONSUCCESSDEFAULTLOGAUDITLOGONFAILUREDEFAULTEVENTLOGCOMPUTERNAMEDEFAULTREPAGENTTHREADADMINISTRATIONENABLEREPAGENTTHREADSDEFAULTCOMPONENTINTEGRATIONSERVICESENABLECISDEFAULTCISCONNECTTIMEOUTDEFAULTCISBULKINSERTBATCHSIZEDEFAULTMAXCISREMOTECONNECTIONSDEFAULTCISPACKETSIZEDEFAULTCISCURSORROWSDEFAULTENABLESNMPDEFAULTENABLEFILEACCESSDEFAULTCISBULKINSERTARRAYSIZEDEFAULTENABLEFULLTEXTSEARCHDEFAULTCISRPCHANDLINGDEFAULTJAVASERVICESENABLEJAVADEFAULTSIZEOFPROCESSOBJECTHEAPDEFAULTSIZEOFSHAREDCLASSHEAPDEFAULTSIZEOFGLOBALFIXEDHEAPDEFAULTNUMBEROFJAVASOCKETSDEFAULTENABLEENTERPRISEJAVABEANSDEFAULTDTMADMINISTRATIONENABLEDTMDEFAULTENABLEXACTCOORDINATIONDEFAULTXACTCOORDINATIONINTERVALDEFAULTNUMBEROFDTXPARTICIPANTSDEFAULTSTRICTDTMENFORCEMENTDEFAULTTXNTOPSSRATIODEFAULTDTMLOCKTIMEOUTPERIODDEFAULTDTMDETACHTIMEOUTPERIODDEFAULTDIAGNOSTICSDUMPONCONDITIONSDEFAULTMAXIMUMDUMPCONDITIONSDEFAULTNUMBEROFCCBSDEFAULTCAPSPERCCBDEFAULTAVERAGECAPSIZEDEFAULTMONITORINGENABLEMONITORINGDEFAULTSQLTEXTPIPEACTIVEDEFAULTSQLTEXTPIPEMAXMESSAGESDEFAULTPLANTEXTPIPEACTIVEDEFAULTPLANTEXTPIPEMAXMESSAGESDEFAULTSTATEMENTPIPEACTIVEDEFAULTSTATEMENTPIPEMAXMESSAGESDEFAULTERRORLOGPIPEACTIVEDEFAULTERRORLOGPIPEMAXMESSAGESDEFAULTDEADLOCKPIPEACTIVEDEFAULTDEADLOCKPIPEMAXMESSAGESDEFAULTWAITEVENTTIMINGDEFAULTPROCESSWAITEVENTSDEFAULTOBJECTLOCKWAITTIMINGDEFAULTSQLBATCHCAPTUREDEFAULTSTATEMENTSTATISTICSACTIVEDEFAULTPEROBJECTSTATISTICSACTIVEDEFAULTMAXSQLTEXTMONITOREDDEFAULTPERFORMANCEMONITORINGOPTIONDEFAULT5、测试方案测试方案围绕提高I/O性能进行。在系统平台一定的情况下，影响I/O性能的表现不外乎如下A存储阵列的I/O性能参数优选，包括其CACH的使用策略和I/OBLOCKSIZE选择B数据库的I/OBLOCKSIZE与应用、OS、阵列的I/OBLOCKSIZE的优化与匹配C数据库是否使用裸设备D数据库使用文件系统时，文件系统的I/O参数优化E数据库碎块对I/O性能的影响F数据库使用的内存大小及内存使用参数相对于100GB的数据库库表大小，该系统目前内存偏小。由于该应用系企业关键应用，目前可方便实施的测试也主要在内存上。所以本次测试主要从增加数据库使用内存及内存使用参数进行。51优化SYBASE的内存使用参数内存使用参数请SYBASE资深专家优化，用户与MIS软件开发维护商一道按SYBASE资深专家的要求，提供主要库表结构的参数，如主要表目前的记录数数量级、字段内容、各字段特点，字段间的相互关系，表、索引、报表间关联信息等。CONFIGURATIONFILEFORTHESYBASESQLSERVERPLEASEREADTHESYSTEMADMINISTRATIONGUIDESAGBEFORECHANGINGANYOFTHEVALUESINTHISFILECONFIGURATIONOPTIONSGENERALINFORMATIONBACKUP/RECOVERYRECOVERYINTERVALINMINUTESDEFAULTPRINTRECOVERYINFORMATIONDEFAULTTAPERETENTIONINDAYSDEFAULTCACHEMANAGERNUMBEROFOAMTRIPSDEFAULTNUMBEROFINDEXTRIPSDEFAULTMEMORYALIGNMENTBOUNDARYDEFAULTGLOBALASYNCPREFETCHLIMITDEFAULTGLOBALCACHEPARTITIONNUMBER8NAMEDCACHEC_ACFZJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACFZSLCACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSJECACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSJE_UINCACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSSLCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACHSSL_UINCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACKMJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACKMSLCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACWLJECACHESIZE500MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACXJJECACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_ACZRZXCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDWGSCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDWSJCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZDYZDCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZHZDCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_HZLZDCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSACDWCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSBMJECACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSDWKMCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHSPZCACHESIZE1024MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHSPZ_UINCACHESIZE300MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSHXSJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSKMXXCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSKMZXCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZBHCACHESIZE50MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZK1CACHESIZE1024MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSPZK1_UINCACHESIZE300MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_BMCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_CPCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_DWCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_GRCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_HSCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_KMCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_PZCACHESIZE200MCACHESTATUSMIXEDCACHECACHEREPLACEMENTPOLICYRELAXEDLRUREPLACEMENTLOCALCACHEPARTITIONNUMBERDEFAULTNAMEDCACHEC_LSUSSJ_XJCACHESIZE100MCACHESTATUSMIXEDCACHECACHEREPLACEMEN