祝愿大家身体健康!

 站点注册  找回密码
 站点注册

QQ登录

只需一步,快速开始

查看: 6033|回复: 3

Dump database突然变慢

[复制链接]

Dump database突然变慢

[复制链接]
sunset

主题

0

回帖

2

积分

新手上路

积分
2
贡献
在线时间
小时
2006-9-22 12:06:40 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?站点注册

×

大家好,我有一台IBM xSeries 235的服务器,4块36.4GSCSI硬盘做的RAID 1+0镜像,安装Windows 2000 Advanced Server操作系统,Sybase数据库,原备份文件6G多,备份时间20分钟左右,前两天重做的系统,做完以后发现备份时间突然由原来的20分钟变成了60分钟,是原来的三倍,打电话给IBM咨询他们说没有什么问题,我怀疑是系统安装的问题,又把硬盘全部重新分区重新安装的,还是慢,同样大小的数据库在一台普通电脑上dump的就很快,到底是服务器的问题还是数据库的问题啊?影响Sybase数据库Dump数据速度的因素都有哪些啊?麻烦大家了!

共享共进共赢Sharing And Win-win Results
SYBASEBBS - 免责申明1、欢迎访问“SYBASEBBS.COM”,本文内容及相关资源来源于网络,版权归版权方所有!本站原创内容版权归本站所有,请勿转载!
2、本文内容仅代表作者观点,不代表本站立场,作者自负,本站资源仅供学习研究,请勿非法使用,否则后果自负!请下载后24小时内删除!
3、本文内容,包括但不限于源码、文字、图片等,仅供参考。本站不对其安全性,正确性等作出保证。但本站会尽量审核会员发表的内容。
4、如本帖侵犯到任何版权问题,请立即告知本站 ,本站将及时删除并致以最深的歉意!客服邮箱:admin@sybasebbs.com
hobbylu

主题

0

回帖

5

积分

新手上路

积分
5
贡献
在线时间
小时
2006-9-22 16:10:34 | 显示全部楼层
你的内存如何分配的,需要把XXX.cfg文件内容贴出来看看
共享共进共赢Sharing And Win-win Results
sunset 楼主

主题

0

回帖

2

积分

新手上路

积分
2
贡献
在线时间
小时
2006-9-22 17:00:43 | 显示全部楼层
1G内存,第一次装系统给Sybase分了800M,后来因为怀疑是Windows内存不够,给Sybase分了750M,请问一下***.cfg的具体路径在哪儿里?在找儿找啊?
共享共进共赢Sharing And Win-win Results
sunset 楼主

主题

0

回帖

2

积分

新手上路

积分
2
贡献
在线时间
小时
2006-9-22 17:25:26 | 显示全部楼层

##############################################################################
#
#  Configuration File for the Sybase SQL Server
#
#  lease read the System Administration Guide (SAG)
#  before changing any of the values in this file.
#
##############################################################################

[Configuration Options]

[General Information]

[Installation is 64-bit]

[Backup/Recovery]
 recovery interval in minutes = DEFAULT
 print recovery information = DEFAULT
 tape retention in days = DEFAULT

[Cache Manager]
 number of oam trips = DEFAULT
 number of index trips = DEFAULT
 procedure cache percent = DEFAULT
 memory alignment boundary = DEFAULT
 global async prefetch limit = DEFAULT

[Named Cache:default data cache]
 cache size = DEFAULT
 cache status = default data cache
 cache replacement policy = DEFAULT

[Meta-Data Caches]
 number of open databases = DEFAULT
 number of open objects = DEFAULT
 open object spinlock ratio = DEFAULT
 number of open indexes = DEFAULT
 open index hash spinlock ratio = DEFAULT
 open index spinlock ratio = DEFAULT

[Disk I/O]
 allow sql server async i/o = DEFAULT
 disk i/o structures = DEFAULT
 page utilization percent = DEFAULT
 number of devices = DEFAULT
 disable character set conversions = DEFAULT
 enable unicode conversions = 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
 allow remote access = DEFAULT
 number of remote logins = DEFAULT
 number of remote sites = DEFAULT
 max number network listeners = DEFAULT
 tcp no delay = DEFAULT
 allow sendmsg = DEFAULT
 syb_sendmsg port number = 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 = DEFAULT
 max parallel degree = DEFAULT
 max scan parallel degree = DEFAULT

[Physical Resources]

[Physical Memory]
 total memory = 384000
 additional network memory = DEFAULT
 lock shared memory = DEFAULT
 shared memory starting address = DEFAULT
 max SQL text monitored = DEFAULT

[Processors]
 max online engines = DEFAULT
 min online engines = DEFAULT

[SQL Server Administration]
 default database size = DEFAULT
 identity burning set factor = DEFAULT
 allow nested triggers = DEFAULT
 allow updates to system tables = DEFAULT
 print deadlock information = DEFAULT
 default fill factor percent = DEFAULT
 default exp_row_size percent = DEFAULT
 number of mailboxes = DEFAULT
 number of messages = DEFAULT
 number of alarms = 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 = DEFAULT
 deadlock retries = DEFAULT
 cpu grace time = DEFAULT
 number of sort buffers = DEFAULT
 number of large i/o buffers = DEFAULT
 size of auto identity column = DEFAULT
 identity grab size = DEFAULT
 page lock promotion HWM = DEFAULT
 page lock promotion LWM = DEFAULT
 page lock promotion PCT = DEFAULT
 housekeeper free write percent = DEFAULT
 enable housekeeper GC = DEFAULT
 partition groups = DEFAULT
 partition spinlock ratio = DEFAULT
 allow resource limits = DEFAULT
 number of aux scan descriptors = DEFAULT
 SQL Perfmon Integration = DEFAULT
 allow backward scans = DEFAULT
 row lock promotion HWM = DEFAULT
 row lock promotion LWM = DEFAULT
 row lock promotion PCT = DEFAULT
 license information = DEFAULT

[User Environment]
 number of user connections = 50
 stack size = DEFAULT
 stack guard size = DEFAULT
 permission cache entries = DEFAULT
 user log cache size = DEFAULT
 user log cache spinlock ratio = DEFAULT

[Lock Manager]
 number of locks = 45000
 deadlock checking period = DEFAULT
 freelock transfer block size = DEFAULT
 max engine freelocks = DEFAULT
 lock spinlock ratio = DEFAULT
 lock hashtable size = DEFAULT
 lock scheme = DEFAULT
 lock wait period = DEFAULT
 read committed with lock = 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 when device full = DEFAULT
 max roles enabled per user = DEFAULT
 unified login required = DEFAULT
 use security services = DEFAULT
 msg confidentiality reqd = DEFAULT
 msg integrity reqd = DEFAULT
 msg replay detection reqd = DEFAULT
 msg origin checks reqd = DEFAULT
 msg out-of-seq checks reqd = DEFAULT
 secure default login = DEFAULT
 dump on conditions = DEFAULT

[Extended Stored Procedure]
 esp unload dll = DEFAULT
 esp execution priority = DEFAULT
 esp execution stacksize = DEFAULT
 xp_cmdshell context = DEFAULT
 start mail session = DEFAULT

[Error Log]
 event logging = DEFAULT
 log audit logon success = DEFAULT
 log audit logon failure = DEFAULT
 event log computer name = DEFAULT

[Rep Agent Thread Administration]
 enable rep agent threads = DEFAULT
 maximum dump conditions = DEFAULT

[Component Integration Services]
 enable cis = DEFAULT
 cis connect timeout = DEFAULT
 cis bulk insert batch size = DEFAULT
 max cis remote connections = DEFAULT
 max cis remote servers = DEFAULT
 cis packet size = DEFAULT
 cis cursor rows = DEFAULT
 cis rpc handling = DEFAULT

共享共进共赢Sharing And Win-win Results
您需要登录后才可以回帖 登录 | 站点注册

本版积分规则

免责声明:
本站所发布的一切破解补丁、注册机和注册信息及软件的解密分析文章仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。本站信息来自网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,购买注册,得到更好的正版服务。如有侵权请邮件与我们联系处理。

Mail To:Admin@SybaseBbs.com

QQ|Archiver|PowerBuilder(PB)BBS社区 ( 鲁ICP备2021027222号-1 )

GMT+8, 2024-12-23 18:09 , Processed in 0.033357 second(s), 9 queries , MemCached On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表