Dump database突然变慢

sunset 发表于 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数据速度的因素都有哪些啊？麻烦大家了！

hobbylu 发表于 2006-9-22 16:10:34

你的内存如何分配的，需要把XXX.cfg文件内容贴出来看看

sunset 发表于 2006-9-22 17:00:43

1G内存，第一次装系统给Sybase分了800M,后来因为怀疑是Windows内存不够，给Sybase分了750M,请问一下***.cfg的具体路径在哪儿里？在找儿找啊？

sunset 发表于 2006-9-22 17:25:26

############################################################################## # #  Configuration File for the Sybase SQL Server # #  Please read the System Administration Guide (SAG) #  before changing any of the values in this file. # ##############################################################################  recovery interval in minutes = DEFAULT  print recovery information = DEFAULT  tape retention in days = DEFAULT  number of oam trips = DEFAULT  number of index trips = DEFAULT  procedure cache percent = DEFAULT  memory alignment boundary = DEFAULT  global async prefetch limit = DEFAULT  cache size = DEFAULT  cache status = default data cache  cache replacement policy = DEFAULT  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  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  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  max async i/os per engine = DEFAULT  max async i/os per server = DEFAULT  number of worker processes = DEFAULT  memory per worker process = DEFAULT  max parallel degree = DEFAULT  max scan parallel degree = DEFAULT  total memory = 384000  additional network memory = DEFAULT  lock shared memory = DEFAULT  shared memory starting address = DEFAULT  max SQL text monitored = DEFAULT  max online engines = DEFAULT  min online engines = DEFAULT  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  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  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  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  esp unload dll = DEFAULT  esp execution priority = DEFAULT  esp execution stacksize = DEFAULT  xp_cmdshell context = DEFAULT  start mail session = DEFAULT  event logging = DEFAULT  log audit logon success = DEFAULT  log audit logon failure = DEFAULT  event log computer name = DEFAULT  enable rep agent threads = DEFAULT  maximum dump conditions = DEFAULT  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

页: [1]

PowerBuilder(PB)BBS社区's Archiver

Dump database突然变慢