Sybase数据库系统巡检报告

SybaseHealth-CheckReport移动集团Sybase数据库系统巡检报告工程师：_李雷章____________联系电话：_13310894803______巡检日期：_2014/1/23_____SybaseHealth-CheckReport目录一、移动集团SYBASE数据库综合报告.................................................................................3二、SYBASE数据库系统软件环境..........................................................................................4三、SYBASE数据库配置..........................................................................................................51.主要配置参数（IPXXXXXXXX）................................................................................................52.主要配置参数（IPXXXXXXXX）.................................................................................................6四、SYBASE数据库性能报告..................................................................................................71.性能报告（IPXXXXXXXX）..........................................................................................................72.性能报告（IPXXXXXXXX）...........................................................................................................8五、SYBASE数据库使用报告..................................................................................................91.数据设备使用情况（IPXXXXXXXX）.......................................................................................92.数据设备使用情况（IPXXXXXXXX）.......................................................................................94.日志设备使用情况（IPXXXXXXXX）..................................................错误!未定义书签。5.日志设备使用情况（IPXXXXXXXX）.....................................................................................10六、SYBASE数据库ERROR报告...........................................................................................12SybaseHealth-CheckReport一、移动集团SYBASE数据库综合报告IP地址数据库名称日志性能建议172.16.59.3upay正常正常无172.16.59.19Upay_bak正常正常无巡检综述：1、SYBASE数据库系统运行基本正常；无性能方面的问题。建议：无巡检工程师：_李雷章__巡检日期：___2014/1/23_SybaseHealth-CheckReport二、SYBASE数据库系统软件环境IP地址操作系统版本数据库版本数据库补丁版本172.16.59.3AIX6.1AdaptiveServerEnterprise/15.7EBF21984172.16.59.19AIX6.1AdaptiveServerEnterprise/15.7EBF21984SybaseHealth-CheckReport三、SYBASE数据库配置1.主要配置参数（IP172.16.59.3）序号参数名称配置值建议1数据库字符集Utf8无2数据库页大小4K无3可使用的最大内存maxmemory=95G无4CPU相关参数maxonlineengines=20numberofenginesatstartup=16无5可连接的用户数numberofuserconnections=20000无6锁相关参数numberoflocks=1000000无7高速缓存参数defaultdatacachesize=51200.00Mbupay=20480.00Mb无8可以同时打开的最大索引数numberofopenindexes=5000无9可以同时打开的最大对象数numberofopenobjects=5000无10网络包尺寸maxnetworkpacketsize=2K无11可以使用的最大设备数numberofdevices=50无12DiskI/Odiski/ostructures=256numberoflargei/obuffers=6无SybaseHealth-CheckReport2.主要配置参数（IP172.16.59.19）序号参数名称配置值建议1数据库字符集Utf8无2数据库页大小4K无3可使用的最大内存maxmemory=28G无4CPU相关参数maxonlineengines=20numberofenginesatstartup=5无5可连接的用户数numberofuserconnections=20000无6锁相关参数numberoflocks=1000000无7高速缓存参数defaultdatacachesize=1500M无8可以同时打开的最大索引数numberofopenindexes=5000无9可以同时打开的最大对象数numberofopenobjects=50000无10网络包尺寸maxnetworkpacketsize=2K无11可以使用的最大设备数numberofdevices=100无12DiskI/Odiski/ostructures=256numberoflargei/obuffers=6无SybaseHealth-CheckReport四、SYBASE数据库性能报告1.性能报告（IP172.16.59.3）性能分析：该SYBASE数据库无性能问题。序号参数类型统计值FREE值建议1CPUCPUBusy%1---2%Idle98%----99%无2OpenObjectUsageMax_Used789Free4211无3OpenIndexUsageMax_Used249Free4751无4OpenDatabaseUsageMax_Used7Free5无5OpenPartitionUsageMax_Used1248Free3752无6LargeI/OUsage0无7Deadlocks0无8高速缓存TotalCacheHits100%TotalCacheMisses0%无9LocksMax_Used67215Free973251无SybaseHealth-CheckReport2.性能报告（IP172.16.59.19）性能分析：该SYBASE数据库无性能问题。序号参数类型统计值FREE值建议1CPUCPUBusy1%---2%Idle98%----99%无2OpenObjectUsage1324Free3676无3OpenIndexUsageMax_Used264Free4732无4OpenDatabaseUsageMax_Used7Free5无5NetworkChecksNon-Blocking无6LargeI/OUsage99无7Deadlocks0无8高速缓存TotalCacheHits100%TotalCacheMisses0%无9LocksMax_Used98571Free973251无SybaseHealth-CheckReport五、SYBASE数据库使用报告1.数据设备使用情况（IP172.16.59.3）说明：2.数据设备使用情况（IP172.16.59.19）说明：3.日志设备使用情况（IP172.16.59.3）序号db_nameTotalSize(MB)UsedSize(MB)FreeSize(MB)UsedPct%1Master500.0MB18.2M481.2M3.64%2Temdb512.0M6.73M505.27M1.31%3upay25600000MB11656M255883440.05%序号db_nameTotalSize(MB)UsedSize(MB)FreeSize(MB)UsedPct%1Master500.0MB19M4813.8%2Temdb512.0MB6.73M505.27M1.31%3upayhis9728000.0MB16064.73M9711935.270.17%序号db_nameTotalSize(MB)UsedSize(MB)FreeSize(MB)UsedPct%1upay25600001165625483440.4%SybaseHealth-CheckReport4.日志设备使用情况（IP172.16.59.19）序号db_nameTotalSize(MB)UsedSize(MB)FreeSize(MB)UsedPct%1upayhis1528791702815217630.4%SybaseHealth-CheckReportSybaseHealth-CheckReport六、SYBASE数据库ERROR报告序号IP地址ERROR建议1172.16.59.30021:00000:00014:2014/01/1600:42:29.12kernelInitializingJobSchedulerTask00:0021:00000:00014:2014/01/1600:42:29.16kernelInstalledJobSchedulersequencercodeversion0.29备注：升级当日错误2172.16.59.19无ERROR