2022年XX销售公司财务管理信息系统Sybase性能测试方案 .pdf

《2022年XX销售公司财务管理信息系统Sybase性能测试方案 .pdf》由会员分享，可在线阅读，更多相关《2022年XX销售公司财务管理信息系统Sybase性能测试方案 .pdf（31页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、版 本 号V 1.3 四川 XX 销售公司财务管理信息系统数据库性能优化测试方案四川省 XX 科技有限公司2009 年 11 月名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第2 页，共 30 页目录1、方案制订目的 . 32、方案参与人员 . 33、平台构成 . 33.1 硬件平台构成 . 33.2 操作系统平台 . 53.3 数据库平台 . 53.4 群集软件 . 54、当前配置参数 . 55、

2、测试方案 . 175.1 优化 Sybase的内存使用参数 . 185.2 增加 Sybase的内存使用 . 306、系统升级建议 . 30名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第3 页，共 30 页1、方案制订目的四川 XX销售公司财务管理信息系统是海量数据库系统，目前库表容量达100GB 。用户使用过程中反映很慢，月底综合查询响应时长达半小时，平常录入一条财务凭证的保存需要几分钟才能完成

3、。Sybase 性能分析I/O 忙，为定性分析原因，查找系统瓶颈，达到用户要求并为用户下一步升级更新系统提供详实参考，故制定本测试方案。2、方案参与人员为充分证实主机、存储、数据库等企业级产品的卓越性能。特邀主机、存储、数据库厂商的资深专家参与修订并指导、实施本方案。并用海量数据库系统的成功经验（如电信、移动的记费系统）来指导本方案。本方案应有以下人员参与：A：Sun的资深主机与存储系统工程师B：Sybase 的资深数据库工程师C：系统集成商四川中陆科贸有限公司D：Sybase数据库维护商3、平台构成3.1 硬件平台构成名师资料总结 - - -精品资料欢迎下载 - - - - - - - -

4、- - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第4 页，共 30 页客户端E6900A 分区E6800A 分区E6900B 分区S6900node1 S6800node2 (17F)E-SW1(17G)E-SW2 (16F)SAN-FC-SW (17E)B-200E 光纤交换机(17B) (16A) Sun6140 磁盘阵列16*300GB FC磁盘（16B）Sybase 数据库存储Sun 6130 磁盘阵列28*73GB FC 图图一四川石油销售公司财务信息系统架构图系

5、统相关设备如下：数据库服务器：SUN E6900服务器一台，划分为2 个独立的硬件分区，分别运行 Sybase 数据库和中间件，分区一和SUN E6800 A 分区之间通过SUN Cluster软件组成高可用工作方式；应用服务器： SUN E6900服务器的 B硬件分区，运行平台服务器；光纤交换机：采用一台Brocade 3250 和一台 Brocade 200E 组成双冗余的光纤存储区域网络（SAN ） ，其中 Brocade 3250 配置 8 个光纤接口，目前已全部使用完， Brocade 200E 配置为 16 口，当前激活12 口，已使用10 口；光纤磁盘阵列：采用一台SUN ST6

6、140和一台 SUN ST6130 。ST6140配置 16块 15KRPM 300GB 硬盘，作为Sybase 数据库的存储空间。图例：Sun cluster 以太网络FC-AL 数据通道名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 4 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第5 页，共 30 页系统硬件配置详情表物理设备E6900 E6900 E69800 分区名（ Domain） A分区B分区A分区Solaris Nodename S

7、6900node1 S6900node2 linshou1 hostname S6900node1 S6900node2 linshou1 布置应用财务Sybase 主数据库服务器应用服务器配置清单系统板： SB1 SB3 SB4 IB8 CPU Core：24X1.8Ghz( 内存： 48GB 系统板： SB5 I/O 板： IB9 CPU Core：8X1.8Ghz 内存： 16GB ）系统板： SB0 I/O 板：IB6 CPU Core：12X1.2Ghz 内存： 48GB 3.2 操作系统平台系统均运行Sun Solaris10 Generic_118833-36操作系统 , Ope

8、nWin3.8,CDE1. 4。3.3 数据库平台运行 Sybase12.5 企业版数据库。3.4 群集软件Sun cluster3.1。4、当前配置参数A、存储阵列参数Write back已使能block size：512K，未针对数据库优化B、Sybase 参数1、 存储使用的文件系统2、 内存使用参数情况如下# # # Configuration File for the Sybase SQL Server 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 5 页，共 31 页

9、- - - - - - - - - 四川省 XX 科技有限公司第6 页，共 30 页# # Please read the System Administration Guide (SAG) # before changing any of the values in this file. # # Configuration Options General Information Backup/Recovery recovery interval in minutes = 1 print recovery information = DEFAULT tape retention in days

10、 = DEFAULT Cache Manager number of oam trips = DEFAULT number of index trips = DEFAULT memory alignment boundary = DEFAULT global async prefetch limit = DEFAULT global cache partition number = 8 Named Cache:c_acfzje cache size = 500M cache status = mixed cache cache replacement policy = relaxed LRU

11、replacement local cache partition number = DEFAULT Named Cache:c_acfzsl cache size = 500M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_achsje cache size = 200M cache status = mixed cache cache replacement policy =

12、relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_achsje_uin cache size = 500M 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 6 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第7 页，共 30 页cache status = mixed cache cache replacement policy = relaxed

13、 LRU replacement local cache partition number = DEFAULT Named Cache:c_achssl cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_achssl_uin cache size = 200M cache status = mixed cache cache replacement

14、policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_ackmje cache size = 500M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_ackmsl cache size = 200M cache status = mixed cache cache

15、replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_acwlje cache size = 500M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_acxjje cache size = 100M cache status = mixed

16、cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_aczrzx cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 7 页，共 3

17、1 页 - - - - - - - - - 四川省 XX 科技有限公司第8 页，共 30 页local cache partition number = DEFAULT Named Cache:c_hzdwgs cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_hzdwsj cache size = 200M cache status = mixed

18、 cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_hzdyzd cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_hzhzd cache size = 100M cache sta

19、tus = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_hzlzd cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsacdw cache size = 100

20、M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsbmje cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT 名师资料总结 - - -精品资料欢迎下载 - -

21、- - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 8 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第9 页，共 30 页Named Cache:c_lsdwkm cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lshspz cache size = 10

22、24M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lshspz_uin cache size = 300M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lshxs

23、j cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lskmxx cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named C

24、ache:c_lskmzx cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lspzbh cache size = 50M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFA

25、ULT Named Cache:c_lspzk1 cache size = 1024M 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 9 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第10 页， 共 30 页cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Name

26、d Cache:c_lspzk1_uin cache size = 300M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition numbe

27、r = DEFAULT Named Cache:c_lsussj_bm cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj_cp cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cac

28、he partition number = DEFAULT Named Cache:c_lsussj_dw cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj_gr cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU rep

29、lacement local cache partition number = DEFAULT Named Cache:c_lsussj_hs cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 10 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第11 页，共 3

30、0 页local cache partition number = DEFAULT Named Cache:c_lsussj_km cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj_pz cache size = 200M cache status = mixed cache cache replacement policy = rel

31、axed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj_xj cache size = 100M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lsussj_zx cache size = 200M cache status = mixed cache cache replac

32、ement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lswlje cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lswlys cache size = 800M cache status = mixed cache

33、cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT Named Cache:c_lswlys_uin cache size = 200M cache status = mixed cache cache replacement policy = relaxed LRU replacement local cache partition number = DEFAULT 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - -

34、 - - - 名师精心整理 - - - - - - - 第 11 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第12 页， 共 30 页Named Cache:default data cache cache size = 8G cache status = default data cache cache replacement policy = DEFAULT local cache partition number = 32 16K I/O Buffer Pool pool size = 2048.0000M wash size = DEFAULT l

35、ocal async prefetch limit = DEFAULT Named Cache:syslog_cache cache size = 2048M cache status = log only cache replacement policy = DEFAULT local cache partition number = 16 Named Cache:tempdb_cache cache size = 8192M cache status = mixed cache cache replacement policy = DEFAULT local cache partition

36、 number = 32 16K I/O Buffer Pool pool size = 4096.0000M wash size = DEFAULT local async prefetch limit = DEFAULT Meta-Data Caches number of open databases = 20 number of open objects = 50000 open object spinlock ratio = DEFAULT number of open indexes = 50000 open index hash spinlock ratio = DEFAULT

37、open index spinlock ratio = DEFAULT partition groups = DEFAULT partition spinlock ratio = DEFAULT Disk I/O disk i/o structures = DEFAULT number of large i/o buffers = DEFAULT page utilization percent = DEFAULT number of devices = 50 disable disk mirroring = DEFAULT 名师资料总结 - - -精品资料欢迎下载 - - - - - - -

38、 - - - - - - - - - - - 名师精心整理 - - - - - - - 第 12 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第13 页， 共 30 页allow sql server async i/o = DEFAULT Languages disable character set conversions = DEFAULT Unicode enable unicode normalization = DEFAULT enable surrogate processing = DEFAULT enable unicode convers

39、ions = DEFAULT size of unilib cache = DEFAULT Network Communication default network packet size = DEFAULT max network packet size = DEFAULT remote server pre-read packets = DEFAULT number of remote connections = DEFAULT number of remote logins = DEFAULT number of remote sites = DEFAULT max number ne

40、twork listeners = DEFAULT tcp no delay = DEFAULT allow sendmsg = DEFAULT syb_sendmsg port number = DEFAULT allow remote access = DEFAULT O/S Resources max async i/os per engine = DEFAULT max async i/os per server = DEFAULT Parallel Query number of worker processes = DEFAULT memory per worker process

41、 = DEFAULT max parallel degree = DEFAULT max scan parallel degree = DEFAULT Physical Resources Physical Memory max memory = 20971520 additional network memory = DEFAULT shared memory starting address = DEFAULT allocate max shared memory = DEFAULT dynamic allocation on demand = DEFAULT lock shared me

42、mory = DEFAULT heap memory per user = DEFAULT 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 13 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第14 页， 共 30 页Processors max online engines = 11 number of engines at startup = 11 SQL Server Administration procedure cache size =

43、2560000 default database size = DEFAULT identity burning set factor = DEFAULT allow nested triggers = DEFAULT allow updates to system tables = DEFAULT default fill factor percent = DEFAULT default exp_row_size percent = DEFAULT number of mailboxes = DEFAULT number of messages = DEFAULT number of ala

44、rms = DEFAULT number of pre-allocated extents = DEFAULT event buffers per engine = DEFAULT cpu accounting flush interval = DEFAULT i/o accounting flush interval = DEFAULT sql server clock tick length = DEFAULT runnable process search count = DEFAULT i/o polling process count = DEFAULT time slice = D

45、EFAULT cpu grace time = DEFAULT number of sort buffers = DEFAULT size of auto identity column = DEFAULT identity grab size = DEFAULT housekeeper free write percent = DEFAULT enable housekeeper GC = DEFAULT allow resource limits = DEFAULT number of aux scan descriptors = DEFAULT SQL Perfmon Integrati

46、on = DEFAULT allow backward scans = DEFAULT license information = DEFAULT enable sort-merge join and JTC = 1 abstract plan load = DEFAULT abstract plan dump = DEFAULT abstract plan replace = DEFAULT abstract plan cache = DEFAULT text prefetch size = DEFAULT enable HA = DEFAULT number of histogram st

47、eps = DEFAULT sampling percent = DEFAULT 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 14 页，共 31 页 - - - - - - - - - 四川省 XX 科技有限公司第15 页， 共 30 页User Environment number of user connections = 1000 stack size = DEFAULT stack guard size = DEFAULT permission cache entries

48、 = DEFAULT user log cache size = DEFAULT user log cache spinlock ratio = DEFAULT Lock Manager number of locks = 500000 deadlock checking period = DEFAULT lock spinlock ratio = DEFAULT lock address spinlock ratio = DEFAULT lock table spinlock ratio = DEFAULT lock hashtable size = DEFAULT lock scheme

49、= DEFAULT lock wait period = DEFAULT read committed with lock = DEFAULT print deadlock information = DEFAULT deadlock retries = DEFAULT page lock promotion HWM = DEFAULT page lock promotion LWM = DEFAULT page lock promotion PCT = DEFAULT row lock promotion HWM = DEFAULT row lock promotion LWM = DEFA

50、ULT row lock promotion PCT = DEFAULT Security Related systemwide password expiration = DEFAULT audit queue size = DEFAULT curread change w/ open cursors = DEFAULT allow procedure grouping = DEFAULT select on syscomments.text = DEFAULT auditing = DEFAULT current audit table = DEFAULT suspend audit wh