Sybase數(shù)據(jù)庫系統(tǒng)巡檢報(bào)告

1、Sybase Health-Check Report移動集團(tuán)Sybase數(shù)據(jù)庫系統(tǒng)巡檢報(bào)告工程師：李雷章聯(lián)系電話巡檢日期： 2014/1/23、移動集團(tuán)SY BAS或據(jù)庫綜合報(bào)告二、SY BAS或據(jù)庫系統(tǒng)軟件環(huán)境三、SY BAS或據(jù)庫配置1. 主要配置參數(shù)（IPXXXXXXXX2. 主要配置參數(shù)（IPXXXXXXXX四、SY BAS或據(jù)庫性能報(bào)告1.性能報(bào)告（IPXXXXXXXX2. 性能報(bào)告（IPXXXXXXXX五、SY BAS或據(jù)庫使用報(bào)告1.數(shù)據(jù)設(shè)備使用情況（IPXXXXXXXX2.數(shù)據(jù)設(shè)備使用情況（IPXXXXXXXX4.日志設(shè)備使用情況（IPXXXXXXXX

2、錯(cuò)誤！未定義書簽。5.日志設(shè)備使用情況（IPXXXXXXXX.10.六、SY BAS或據(jù)庫ERROF報(bào)告12移動集團(tuán)SY BASE數(shù)據(jù)庫綜合報(bào)告IP地址數(shù)據(jù)庫名稱日志性能建議172.16.59.3upay正常正常無172.16.59.19Upay_bak正常正常無巡檢綜述：1、SYBASE數(shù)據(jù)庫系統(tǒng)運(yùn)行基本正常；無性能方面的問題。建議：無巡檢工程師：李雷章巡檢日期:2014/1/23SY BASE數(shù)據(jù)庫系統(tǒng)軟件環(huán)境IP地址操作系統(tǒng)版本數(shù)據(jù)庫版本數(shù)據(jù)庫補(bǔ)丁版本172.16.59.3AIX 6.1Ada ptive ServerEnterp rise/15.7EBF 21984172.16.59.

3、19AIX 6.1Ada ptive ServerEnterp rise/15.7EBF 21984SYBASE據(jù)庫配置1.主要配置參數(shù)(IP 172.16.59.3 )序號參數(shù)名稱配置值建議1數(shù)據(jù)庫字符集Utf8無2數(shù)據(jù)庫頁大小4K無3可使用的最大內(nèi)存max memory = 95G無4CPU相關(guān)參數(shù)max on li ne engines = 20nu mber of engines at start up = 16無5可連接的用戶數(shù)nu mber of user connections = 20000無6鎖相關(guān)參數(shù)number of locks =1000000無7高速緩存參數(shù)defau

4、lt data cache size = 51200.00 Mb up ay = 20480.00 Mb無8可以同時(shí)打開的最大索引數(shù)nu mber of open in dexes = 5000無9可以同時(shí)打開的最大對象數(shù)nu mber of open objects = 5000無10網(wǎng)絡(luò)包尺寸max n etwork p acket size = 2K無11可以使用的最大設(shè)備數(shù)nu mber of devices = 50無12Disk I/Odisk i/o structures = 256 nu mber of large i/o buffers =6無2.主要配置參數(shù)(IP 172.

5、16.59.19 )序號參數(shù)名稱配置值建議1數(shù)據(jù)庫字符集Utf8無2數(shù)據(jù)庫頁大小4K無3可使用的最大內(nèi)存max memory = 28G無4CPU相關(guān)參數(shù)max on li ne engines = 20nu mber of engines at start up = 5無5可連接的用戶數(shù)nu mber of user connections = 20000無6鎖相關(guān)參數(shù)number of locks = 1000000無7高速緩存參數(shù)default data cache size = 1500M無8可以同時(shí)打開的最大索引數(shù)nu mber of open in dexes = 5000無9可以

6、同時(shí)打開的最大對象數(shù)nu mber of open objects = 50000無10網(wǎng)絡(luò)包尺寸max n etwork p acket size = 2K無11可以使用的最大設(shè)備數(shù)nu mber of devices = 100無12Disk I/Odisk i/o structures = 256nu mber of large i/o buffers = 6無四、SYBASE據(jù)庫性能報(bào)告1.性能報(bào)告(IP 172.16.59.3 )序號參數(shù)類型統(tǒng)計(jì)值FREE值建議1CPUCPU Busy %1 -2%Idle 98 %-99%無2Open Object UsageMax_Used 78

7、9Free 4211無3Open In dex UsageMax_Used 249Free 4751無4Open Database UsageMax_Used 7Free 5無5Open P artiti on UsageMax_Used 1248Free 3752無6Large I/O Usage0無7Deadlocks0無8高速緩存Total Cache Hits 100%Total Cache Misses 0%無9LocksMax_Used 67215Free973251無性能分析：該SYBASE據(jù)庫無性能問題。2.性能報(bào)告(IP 172.16.59.19 )序號參數(shù)類型統(tǒng)計(jì)值FREE

8、值建議1CPUCPU Busy 1% - 2 %Idle 98%-99%無2Open Object Usage1324Free 3676無3Open In dex UsageMax_Used 264Free 4732無4Open Database UsageMax_Used 7Free 5無5Network ChecksNon-Blocki ng無6Large I/O Usage99無7Deadlocks0無8高速緩存Total Cache Hits 100%Total Cache Misses 0%無9LocksMax_Used 98571Free 973251無性能分析：該SYBASE據(jù)庫

9、無性能問題。五、SYBASE據(jù)庫使用報(bào)告1.數(shù)據(jù)設(shè)備使用情況(IP 172.16.59.3 )序號db_n ameTotalSize(MB)UsedSize(MB)FreeSize(MB)Used Pct%1Master500.0 MB18.2 M481.2 M3.64%2Temdb512.0M6.73M505.27M1.31%3upay25600000 MB11656M255883440.05%說明:2.數(shù)據(jù)設(shè)備使用情況(IP 172.16.59.19 )序號db_n ameTotalSize(MB)UsedSize(MB)FreeSize(MB)Used Pct%1Master500.0

10、MB19 M4813.8%2Temdb512.0 MB6.73M505.27 M1.31%3up ayhis9728000.0 MB16064.73 M9711935.270.17%說明:3.日志設(shè)備使用情況(IP 172.16.59.3 )序號db_n ameTotalSize(MB)UsedSize(MB)FreeSize(MB)Used Pct%1upay25600001165625483440.4%4.日志設(shè)備使用情況(IP 172.16.59.19 )序號db_n ameTotalSize(MB)UsedSize(MB)FreeSize(MB)Used Pct%1up ayhis1528791702815217630.4%Sybase Health-Check Report六、SYBASE據(jù)庫ERROR報(bào)告序號IP地址ERROR建議1172.16.59.30021:00000:00014:2014/01/1600:42:29.12 kernel