请教数据库宕掉的问题

sfw

00:00000:00014:2005/07/30 10:17:55.53 server  The 16K memory pool of named cache
default data cache (cache id 0, cachelet id 2) is configured too small for current demands (state 1). Transaction progress may cease or response time may incre
ase.

数据去进不去了,查看log,sybase报这样的错误信息,不知道为什么,是因为page size太大,导致操作速度太慢,数据库宕掉嘛?
kill sybase进程,重启服务就恢复正常了
不知道什么原因,请高手指教

1017of

sp_configure 'mem'
go
sp_cacheconfig
go
贴出结果

sfw

sp_configure 'mem'
Msg 17411, Level 16, State 1:
Server 'TOPIBS', Procedure 'sp_configure', Line 195:
Configuration option is not unique.

Parameter Name                 Default     Memory Used Config Value
         Run Value   Unit                 Type
------------------------------ ----------- ----------- ------------
         ----------- -------------------- ----------
additional network memory                0          20       20480
               20480 bytes                dynamic
allocate max shared memory               0           0           0
                   0 switch               dynamic
heap memory per user                  4096           0        4096
                4096 bytes                dynamic
lock shared memory                       0           0           0
                   0 switch               static
max memory                           49152     1310720      655360
              655360 memory pages(2k)     dynamic
memory alignment boundary            16384           0       16384
               16384 bytes                static
memory per worker process             1024         132       32768
               32768 bytes                dynamic
shared memory starting address           0           0           0
                   0 not applicable       static
total logical memory                 49152      131682       65841
               65841 memory pages(2k)     read-only
total physical memory                    0      131684           0
               65842 memory pages(2k)     read-only

(1 row affected)
(return status = 1)


sp_cacheconfig
Cache Name                     Status    Type     Config Value Run Value
------------------------------ --------- -------- ------------ ------------
default data cache             Active    Default       0.00 Mb      8.00 Mb
                                                   ------------ ------------
                                            Total       0.00 Mb      8.00 Mb
==========================================================================
Cache: default data cache,   Status: Active,   Type: Default
      Config Size: 0.00 Mb,   Run Size: 8.00 Mb
      Config Replacement: strict LRU,   Run Replacement: strict LRU
      Config Partition:            2,   Run Partition:            2
IO Size  Wash Size Config Size  Run Size     APF Percent
-------- --------- ------------ ------------ -----------
    16 Kb   1632 Kb      0.00 Mb      8.00 Mb     10
(return status = 0)

1017of

select @@pagesize
go
另请贴出server down的那一部分errorlog

sfw

log日志

00:00000:00032:2005/07/29 17:50:50.64 kernel  Cannot read, host process disconne
cted:  0000016a spid: 32
00:00000:00017:2005/07/29 17:50:50.64 kernel  Cannot read, host process disconne
cted:  0000016a spid: 17
00:00000:00026:2005/07/29 17:50:50.64 kernel  Cannot read, host process disconne
cted:  0000016a spid: 26
00:00000:00017:2005/07/30 09:39:28.53 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00017:2005/07/30 10:05:38.25 server  The 16K memory pool of named cache
default data cache (cache id 0, cachelet id 2) is configured too small for curr
ent demands (state 1). Transaction progress may cease or response time may incre
ase.

@@pagesize
2048

多谢高手指导

1017of

尽管cache配置极其不合理，但我从errorlog中看不出是因为cache不够，导致server down的，最好你能将errorlog中server down到server restarted的日志全部贴出

1017of

另请贴出sp_configure 'object'的结果

sfw

不好意思
我的server是7月30号宕掉的
好像是7月23号就开始报错了
高手帮忙看看
00:00000:00013:2005/07/23 10:38:08.67 kernel  Cannot read, host process disconne
cted:   spid: 13
00:00000:00012:2005/07/23 10:38:08.67 kernel  Cannot read, host process disconne
cted:   spid: 12
00:00000:00033:2005/07/23 10:38:12.66 kernel  Cannot read, host process disconne
cted:  0000016a spid: 33
00:00000:00033:2005/07/25 11:02:58.90 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00011:2005/07/25 11:21:11.76 kernel  Cannot read, host process disconne
cted:  0000016a spid: 11
00:00000:00001:2005/07/25 11:21:11.76 kernel  Cannot read, host process disconne
cted:  0000016a spid: 1
00:00000:00032:2005/07/26 09:49:09.70 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00027:2005/07/27 09:55:41.73 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00018:2005/07/28 09:24:47.24 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00032:2005/07/28 10:23:15.70 server  Error: 614, Severity: 21, State: 1
2
00:00000:00032:2005/07/28 10:23:15.70 server  Adaptive Server accessed a row tha
t has an illegal length of 0 while in data base 'JSSHDQ'. Page pointer = 0x35bcc
000, pageno = 11536, status = 0x1, objectid = -2097202, indexid = 0, level = 0.
The minimum row length is 6. The page size is 16384.
00:00000:00032:2005/07/28 10:23:15.73 server  Error: 804, Severity: 20, State: 1
00:00000:00032:2005/07/28 10:23:15.73 server  Unable to find buffer '0x358c7158'
from cache 'default data cache' holding logical page '11265' in sdes '0x31e90bc
c' kept buffer pool for object 'temp worktable'.
00:00000:00029:2005/07/29 10:10:40.67 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
@
00:00000:00016:2005/07/29 17:45:53.40 kernel  Cannot read, host process disconne
cted:   spid: 16
00:00000:00010:2005/07/29 17:45:53.41 kernel  Cannot read, host process disconne
cted:   spid: 10
00:00000:00031:2005/07/29 17:45:53.41 kernel  Cannot read, host process disconne
cted:   spid: 31
00:00000:00023:2005/07/29 17:45:53.41 kernel  Cannot read, host process disconne
cted:   spid: 23
00:00000:00014:2005/07/29 17:45:53.41 kernel  Cannot read, host process disconne
cted:   spid: 14
00:00000:00022:2005/07/29 17:45:53.41 kernel  Cannot read, host process disconne
cted:   spid: 22
00:00000:00018:2005/07/29 17:45:53.42 kernel  Cannot read, host process disconne
cted:   spid: 18
00:00000:00001:2005/07/29 17:45:53.42 kernel  Cannot read, host process disconne
cted:   spid: 1
00:00000:00012:2005/07/29 17:45:53.42 kernel  Cannot read, host process disconne
cted:   spid: 12
00:00000:00020:2005/07/29 17:45:53.42 kernel  Cannot read, host process disconne
cted:   spid: 20

cted:  0000016a spid: 26
00:00000:00017:2005/07/30 09:39:28.53 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00017:2005/07/30 10:05:38.25 server  The 16K memory pool of named cache
default data cache (cache id 0, cachelet id 2) is configured too small for curr
ent demands (state 1). Transaction progress may cease or response time may incre
ase.
00:00000:00017:2005/07/30 10:05:38.29 server  The 16K memory pool of named cache
default data cache (cache id 0, cachelet id 2) is configured too small for curr
ent demands (state 1). Transaction progress may cease or response time may incre
ase.
00:00000:00012:2005/07/30 10:08:04.35 kernel  Cannot read, host process disconne
cted:   spid: 12
00:00000:00014:2005/07/30 10:17:55.53 server  The 16K memory pool of named cache
default data cache (cache id 0, cachelet id 2) is configured too small for curr
ent demands (state 1). Transaction progress may cease or response time may incre
ase.
00:00000:00000:2005/07/30 10:23:15.59 kernel  Use license file /sybase/SYSAM-1_0
/licenses/license.dat.
00:00000:00000:2005/07/30 10:23:15.59 kernel  Checked out license ASE_SERVER
00:00000:00000:2005/07/30 10:23:15.59 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2005/07/30 10:23:15.65 kernel  Using config area from primary mas
ter device.
00:00000:00000:2005/07/30 10:23:15.77 kernel  os_create_keyfile: Removed old seg
ment /sybase/ASE-12_5/TOPIBS.krg
00:00000:00000:2005/07/30 10:23:15.82 kernel  Using 2000 file descriptors.
00:00000:00000:2005/07/30 10:23:15.83 kernel  Adaptive Server Enterprise/12.5.0.
3/EBF 11443 ESD#4/P/RS6000/AIX 4.3.3/rel12503/1939/32-bit/FBO/Sun Sep 21 00:54:5
0 2003
00:00000:00000:2005/07/30 10:23:15.83 kernel  Confidential property of Sybase, I
nc.
00:00000:00000:2005/07/30 10:23:15.83 kernel  Copyright 1987, 2003
00:00000:00000:2005/07/30 10:23:15.83 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/07/30 10:23:15.83 kernel  Unpublished rights reserved under
U.S. copyright laws.
00:00000:00000:2005/07/30 10:23:15.83 kernel
00:00000:00000:2005/07/30 10:23:15.83 kernel  This software contains confidentia
l and trade secret information of Sybase,
00:00000:00000:2005/07/30 10:23:15.83 kernel  Inc.   Use,  duplication or disclo
sure of the software and documentation by
00:00000:00000:2005/07/30 10:23:15.83 kernel  the  U.S.  Government  is  subject
  to  restrictions set forth in a license
00:00000:00000:2005/07/30 10:23:15.83 kernel  agreement  between  the  Governmen
t  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/07/30 10:23:15.83 kernel  agreement  specifying  the  Govern
ment's rights to use the software and any
00:00000:00000:2005/07/30 10:23:15.83 kernel  applicable FAR provisions, for exa
mple, FAR 52.227-19.
00:00000:00000:2005/07/30 10:23:15.83 kernel  Sybase, Inc. One Sybase Drive, Dub
lin, CA 94568, USA
00:00000:00000:2005/07/30 10:23:15.83 kernel  Using '/sybase/ASE-12_5/TOPIBS.cfg
' for configuration information.
00:00000:00000:2005/07/30 10:23:15.83 kernel  Logging ASE messages in file '/syb
ase/ASE-12_5/install/TOPIBS.log'.
00:00000:00000:2005/07/30 10:23:15.88 kernel  kdcl_sess_open: connectivity libra
ry supports master/query syntax.
00:00000:00000:2005/07/30 10:23:15.89 kernel  Directory Control Layer (DCL) usin
g directory driver: InterfacesDriver
00:00000:00000:2005/07/30 10:23:15.89 kernel  SQL Server booted with TCP_NODELAY
enabled.
00:00000:00000:2005/07/30 10:23:15.89 kernel  SSL Plus v3.0.9 security modules l
oaded successfully.
00:00000:00000:2005/07/30 10:23:15.89 kernel  Network and device connection limi
t is 1990.
00:00000:00000:2005/07/30 10:23:16.20 server  Number of blocks left for proc hea
ders: 23952.
00:00000:00000:2005/07/30 10:23:16.32 server  Proc header memory allocated 11976
pages for each per engine cache
00:00000:00000:2005/07/30 10:23:16.32 server  Memory allocated for the default d
ata cache cachelet 1: 4096 Kb
00:00000:00000:2005/07/30 10:23:16.32 server  Size of the 16K memory pool: 4096
Kb
00:00000:00000:2005/07/30 10:23:16.32 server  Memory allocated for the default d
ata cache cachelet 2: 4096 Kb
00:00000:00000:2005/07/30 10:23:16.32 server  Size of the 16K memory pool: 4096
Kb
00:00000:00000:2005/07/30 10:23:16.32 kernel  Initializing virtual device 0, '/d
ev/rlv_jss_master' with dsync 'on'.
00:00000:00000:2005/07/30 10:23:16.32 kernel  Virtual device 0 started using asy
nchronous i/o.
00:00000:00000:2005/07/30 10:23:16.32 kernel  Either the config parameter 'use s
ecurity services' is set to 0, or ASE does not support use of external security
mechanisms on this platform. The Security Control Layer will not be initialized.
No external security mechanisms will be supported.
00:00000:00000:2005/07/30 10:23:16.32 kernel  Unix interval timer enabled for sy
sclk interrupts.
00:00000:00000:2005/07/30 10:23:16.32 kernel  engine 0, os pid 8004  online
00:00000:00000:2005/07/30 10:23:16.33 server  No active traceflags
00:00000:00001:2005/07/30 10:23:16.33 kernel  libomni1 - Component Integration S
ervices loaded; version 'libomni1 - Component Integration Services/12.5.0.3/EBF
11443 ESD#4/P/RS6000/AIX 4.3.3/rel12503/1939/32-bit/INST/Sat Sep 20 22:21:40 200
3'.
00:00000:00001:2005/07/30 10:23:16.33 kernel  libomni1 - Component Integration S
ervices: using 'Sybase Client-Library/12.5/P-EBF10811 ESD#8-1/DRV.12.5.0.4/RS600
0/AIX 4.3.3/BUILD125-016-1/OPT/Wed Dec  4 15:20:39 2002'
00:00000:00001:2005/07/30 10:23:16.33 server  Opening Master Database ...
00:00000:00001:2005/07/30 10:23:16.43 server  Loading SQL Server's default sort
order and character set
00:00000:00001:2005/07/30 10:23:16.44 server  Loaded default Unilib conversion h
andle.
00:00000:00001:2005/07/30 10:23:16.46 server  Recovering database 'master'.
00:00000:00001:2005/07/30 10:23:16.51 server  Redo pass of recovery has processe
d 4 committed and 0 aborted transactions.
00:00000:00001:2005/07/30 10:23:16.69 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:16.71 server  Database 'master' is now online.
00:00000:00001:2005/07/30 10:23:16.71 server  The transaction log in the databas
e 'master' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:16.72 server  Warning: ASE_HA has no valid licen
se and therefore is not initialized.
00:00000:00001:2005/07/30 10:23:16.73 server  server name is 'TOPIBS'
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'jss_data_dev' of
size 524200 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 4, '/d
ev/rlv_jss_data' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 4 started using asy
nchronous i/o.
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'jss_log_dev' of s
ize 262144 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 5, '/d
ev/rlv_jss_log' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 5 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'jsshdq_data_dev'
of size 2097000 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 2, '/d
ev/rlv_jsshdq_data' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 2 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'jsshdq_log_dev' o
f size 1048400 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 3, '/d
ev/rlv_jsshdq_log' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 3 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'sysprocsdev' of s
ize 261120 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 1, '/d
ev/rlv_jss_proces' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 1 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'temp_dev' of size
196000 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 7, '/d
ev/rlvsybtemptopibs' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 7 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.74 server  Activating disk 'tempdb_dev' of si
ze 131000 KB.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Initializing virtual device 6, '/d
ev/rlv_tempdb' with dsync 'on'.
00:00000:00001:2005/07/30 10:23:16.74 kernel  Virtual device 6 started using asy
nchronous i/o.
00:00000:00001:2005/07/30 10:23:16.87 server  Recovering database 'sybsystemdb'.
00:00000:00001:2005/07/30 10:23:16.88 server  Redo pass of recovery has processe
d 0 committed and 1 aborted transactions.
00:00000:00001:2005/07/30 10:23:16.93 server  Boot Count: 16
00:00000:00001:2005/07/30 10:23:16.98 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:16.99 server  The transaction log in the databas
e 'sybsystemdb' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:17.01 server  Database 'sybsystemdb' is now onli
ne.

sfw

1>; sp_configure 'object'
2>; go
Msg 17411, Level 16, State 1:
Server 'TOPIBS', Procedure 'sp_configure', Line 195:
Configuration option is not unique.

Parameter Name                 Default     Memory Used Config Value
         Run Value   Unit                 Type
------------------------------ ----------- ----------- ------------
         ----------- -------------------- ----------
number of open objects                 500         681         500
                 500 number               dynamic
object lockwait timing                   0           0           0
                   0 switch               dynamic
open object spinlock ratio             100           0         100
                 100 ratio                dynamic
per object statistics active             0           0           0
                   0 switch               dynamic
size of process object heap           1500           0        1500
                1500 memory pages(2k)     dynamic

(1 row affected)
(return status = 1)

1017of

你的errorlog没有贴完，至少需要一次完整启动的errorlog。
从你所贴的errorlog看，有对象可能有问题，检查一下JSSHDQ库，以确定问题。如库比较大，谨慎行事；最好能从OS级别检查是否有系统问题。
另，你的open objects资源有重用现象，如资源情况允许，可以调大一点；