请教数据库宕掉的问题

sfw

00:00000:00001:2005/07/30 10:23:17.05 server  Recovering database 'model'.
00:00000:00001:2005/07/30 10:23:17.11 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:17.13 server  The transaction log in the databas
e 'model' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:17.16 server  Database 'model' is now online.
00:00000:00001:2005/07/30 10:23:17.16 server  The logical pagesize of the server
is 16 Kb.
00:00000:00001:2005/07/30 10:23:17.16 server  0 dump conditions detected at boot
time
00:00000:00001:2005/07/30 10:23:17.16 server  Resident Node id: d06ea7e1b636
00:00000:00001:2005/07/30 10:23:17.16 server  Transaction coordinator initialize
d.
00:00000:00001:2005/07/30 10:23:17.16 server  Clearing temp db
00:00000:00001:2005/07/30 10:23:19.15 server  The transaction log in the databas
e 'tempdb' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:19.19 server  Database 'tempdb' is now online.
00:00000:00001:2005/07/30 10:23:19.23 server  Recovering database 'sybsystemproc
s'.
00:00000:00001:2005/07/30 10:23:19.38 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:19.39 server  The transaction log in the databas
e 'sybsystemprocs' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:19.43 server  Database 'sybsystemprocs' is now o
nline.
00:00000:00002:2005/07/30 10:23:19.43 kernel  network name 172.16.24.50, type et
her, port 4003, filter NONE
00:00000:00001:2005/07/30 10:23:19.50 server  Recovering database 'JSSHDQ'.
00:00000:00001:2005/07/30 10:23:19.62 server  Redo pass of recovery has processe
d 11 committed and 0 aborted transactions.
00:00000:00001:2005/07/30 10:23:20.93 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:20.96 server  The transaction log in the databas
e 'JSSHDQ' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:21.00 server  Database 'JSSHDQ' is now online.
00:00000:00001:2005/07/30 10:23:21.05 server  Recovering database 'JSS'.
00:00000:00001:2005/07/30 10:23:21.07 server  Redo pass of recovery has processe
d 1 committed and 0 aborted transactions.
00:00000:00001:2005/07/30 10:23:21.44 server  Checking external objects.
00:00000:00001:2005/07/30 10:23:21.46 server  The transaction log in the databas
e 'JSS' will use I/O size of 16 Kb.
00:00000:00001:2005/07/30 10:23:21.50 server  Database 'JSS' is now online.
00:00000:00001:2005/07/30 10:23:21.53 server  Recovery complete.
00:00000:00001:2005/07/30 10:23:21.53 server  SQL Server's default unicode sort
order is 'binary'.
00:00000:00001:2005/07/30 10:23:21.54 server  SQL Server's default sort order is
:
00:00000:00001:2005/07/30 10:23:21.54 server    'bin_iso_1' (ID = 50)
00:00000:00001:2005/07/30 10:23:21.54 server  Master device size: 255 megabytes,
or 130560 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00022:2005/07/30 10:41:46.98 server  Increase the config parameter 'num
ber of open objects' to avoid descriptor reuse. Reuse may result in performance
degradation.
00:00000:00031:2005/07/30 16:54:24.22 kernel  Cannot read, host process disconne
cted:   spid: 31
00:00000:00010:2005/07/30 16:57:24.63 kernel  Cannot read, host process disconne
cted:   spid: 10
00:00000:00013:2005/07/30 17:02:25.32 kernel  Cannot read, host process disconne
cted:   spid: 13
00:00000:00016:2005/07/30 17:05:03.99 kernel  Cannot read, host process disconne
cted:   spid: 16
00:00000:00023:2005/07/30 17:13:44.94 kernel  Cannot read, host process disconne
cted:   spid: 23
00:00000:00032:2005/07/30 17:13:44.94 kernel  Cannot read, host process disconne
cted:   spid: 32
00:00000:00028:2005/07/30 17:13:45.15 kernel  Cannot read, host process disconne
cted:   spid: 28
00:00000:00012:2005/07/30 17:13:45.15 kernel  Cannot read, host process disconne
cted:   spid: 12
cted:  0000016a spid: 29
00:00000:00032:2005/07/30 17:28:43.87 server  SQL Server shutdown by request.
00:00000:00032:2005/07/30 17:28:43.87 kernel  ueshutdown: exiting
00:00000:00000:2005/07/30 17:29:02.24 kernel  Use license file /sybase/SYSAM-1_0
/licenses/license.dat.
00:00000:00000:2005/07/30 17:29:02.24 kernel  Checked out license ASE_SERVER
00:00000:00000:2005/07/30 17:29:02.24 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2005/07/30 17:29:02.29 kernel  Using config area from primary mas
ter device.
00:00000:00000:2005/07/30 17:29:02.39 kernel  Using 2000 file descriptors.
00:00000:00000:2005/07/30 17:29:02.41 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 17:29:02.41 kernel  Confidential property of Sybase, I
nc.
00:00000:00000:2005/07/30 17:29:02.41 kernel  Copyright 1987, 2003
00:00000:00000:2005/07/30 17:29:02.41 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2005/07/30 17:29:02.41 kernel  Unpublished rights reserved under
U.S. copyright laws.
00:00000:00000:2005/07/30 17:29:02.41 kernel
00:00000:00000:2005/07/30 17:29:02.41 kernel  This software contains confidentia
l and trade secret information of Sybase,
00:00000:00000:2005/07/30 17:29:02.41 kernel  Inc.   Use,  duplication or disclo
sure of the software and documentation by
00:00000:00000:2005/07/30 17:29:02.41 kernel  the  U.S.  Government  is  subject
  to  restrictions set forth in a license
00:00000:00000:2005/07/30 17:29:02.41 kernel  agreement  between  the  Governmen
t  and  Sybase,  Inc.  or  other  written
00:00000:00000:2005/07/30 17:29:02.41 kernel  agreement  specifying  the  Govern
ment's rights to use the software and any
00:00000:00000:2005/07/30 17:29:02.41 kernel  applicable FAR provisions, for exa
mple, FAR 52.227-19.
00:00000:00000:2005/07/30 17:29:02.41 kernel  Sybase, Inc. One Sybase Drive, Dub
lin, CA 94568, USA
00:00000:00000:2005/07/30 17:29:02.41 kernel  Using '/sybase/ASE-12_5/TOPIBS.cfg
' for configuration information.
00:00000:00000:2005/07/30 17:29:02.41 kernel  Logging ASE messages in file '/syb
ase/ASE-12_5/install/TOPIBS.log'.
00:00000:00000:2005/07/30 17:29:02.44 kernel  kdcl_sess_open: connectivity libra
ry supports master/query syntax.
00:00000:00000:2005/07/30 17:29:02.45 kernel  Directory Control Layer (DCL) usin
g directory driver: InterfacesDriver
00:00000:00000:2005/07/30 17:29:02.45 kernel  SQL Server booted with TCP_NODELAY
enabled.
00:00000:00000:2005/07/30 17:29:02.46 kernel  Network and device connection limi
t is 1990.
00:00000:00000:2005/07/30 17:29:02.78 server  Number of blocks left for proc hea
ders: 23952.
00:00000:00000:2005/07/30 17:29:02.91 server  Proc header memory allocated 11976
pages for each per engine cache
00:00000:00000:2005/07/30 17:29:02.91 server  Memory allocated for the default d
ata cache cachelet 1: 4096 Kb
00:00000:00000:2005/07/30 17:29:02.91 server  Size of the 16K memory pool: 4096
Kb
00:00000:00000:2005/07/30 17:29:02.91 server  Memory allocated for the default d
ata cache cachelet 2: 4096 Kb
00:00000:00000:2005/07/30 17:29:02.91 server  Size of the 16K memory pool: 4096
Kb
00:00000:00000:2005/07/30 17:29:02.91 kernel  Initializing virtual device 0, '/d
ev/rlv_jss_master' with dsync 'on'.
00:00000:00000:2005/07/30 17:29:02.91 kernel  Virtual device 0 started using asy
nchronous i/o.
00:00000:00000:2005/07/30 17:29:02.92 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.

sfw

太长了,不好意思一直麻烦您了
我也自己多看看
谢谢拉

chuxu

好像听说2K的pool是必须要有的，而且你的default databcache还可以增大很多呀

sfw

我把number of open objects 从500一直增大到2000
可是sp_configure 'objects'的memory used还是大于config value
变成2727了
是不是那里有需要一起修改的地方啊

sfw

不好意思
搞错了
请问我把number of objects调了以后
怎么样才能看到用了多少啊
是不是log不报错表示就够用啊
怎么样才能找到一个合适的值啊

Eisen

恩。一般说来，extra pool是在持续大IO的情况下才去配置的以增加每次wash的size，一般也就配一个4k和8K的也就够了。但是如果是大IO的话，8M的data cache确实是非常小再要开16K的pool，确实pool就把data cache全占光了。自然会错。
你先把那个16k的pool去掉，就留下缺省的2k pool，然后根据你的max memory大小的40%来配data cache。然后再应用那个程序试试。