sybase 11.9.2 现在出现性能问题，请教各位前辈

richardma_1204

谢谢，我现在就做
十分感谢了

再问一个问题，我的磁盘阵列是外加的，有没有什么别的方法查看呢？？
有的话，请教教我，谢谢！！！！

Ray_at_eds

每个盘阵都有一个控制终端，就像一台server一样，有IP,可以TELNET上去；也会有一个控制界面提供管理功能，有菜单式管理界面，有些是命令行的方式的。

各家的设备，各有不同，但是都会有LOG文件纪录一些盘阵的运行情况。

所以，你只能去问一下当初安装这个设备的人员，看看有没有留下安装文档。

richardma_1204

谢谢RAY，今天太晚了，明天去干
谢谢

aok

最初由 richardma_1204 发布
[B]各位，我检查了数据库的配置，数据库的索引等
没有发现问题
请教，这次数据库变的特别的慢如何处理？？？？
谢谢各位。
我又做了一次测试，从一个只有100条记录，10个列的表中取全部数据
select * FROM TEST ;
可是得到结果的时间大约为5分钟。
请教各位了。 [/B]

你这个速度就慢的有些吃惊了
可能你的硬件有问题，尤其是存储方面的。

建议你做个10分钟的sysmon报告上来看看
use master
go
sp_sysmon "00:10:00"

同时纪录sar 1 10  vmstat 1 10，看看有什么，还有，把top也列出来。

richardma_1204

谢谢 aok
我把这个结果发上来看看
明天做

richardma_1204

aok，不行，你说的方法没有任何的反映啊
我执行
use master
go
sp_sysmon "00:10:00"
可是，执行后，运行了大约1个小时，没有任何的反映，也不出现任何的信息。
并且一直处于运行状态。

tanjiawen

发你的数据库日志,我帮你看看

richardma_1204

日志是不是errorlog这个文件啊
这里的内容都没有了啊

richardma_1204

找到下面的这些文件：请查看，哪个是：
〔errorlogold〕
Wed Dec 25 09:42:54 2002
Workspace Manager: I/O error on display:: :0.0

〔startlog〕
--- Wed Dec 25 09:46:20 CST 2002
--- /usr/dt/bin/Xsession starting...
--- starting /usr/openwin/bin/speckeysd
--- Xsession started by dtlogin
--- starting /usr/dt/bin/dtsession_res -load -system
--- sourcing /export/home/ydsybase/.dtprofile...
--- sourcing /usr/dt/config/Xsession.d/0010.dtpaths...
--- sourcing /usr/dt/config/Xsession.d/0015.sun.env...
--- sourcing /usr/dt/config/Xsession.d/0020.dtims...
--- sourcing /usr/dt/config/Xsession.d/0030.dttmpdir...
--- sourcing /usr/dt/config/Xsession.d/0040.xmbind...
--- sourcing /usr/dt/config/Xsession.d/1000.solregis...
--- starting /usr/dt/bin/dthello &
--- starting /usr/dt/bin/dtsearchpath
--- starting /usr/dt/bin/dtappgather &
--- starting /usr/dt/bin/dsdm &
--- session log file is /dev/null
--- DTSOURCEPROFILE is 'true' (see /export/home/ydsybase/.dtprofile)
--- execing /usr/dt/bin/dtsession with a /bin/sh login shell ...
--- starting desktop on /dev/pts/2
Sun Microsystems Inc.        SunOS 5.7        Generic        October 1998
/usr/dt/bin/ttsession[9230]: starting
/usr/dt/bin/Xsession[739]: 9201 Hangup
X connection to :0.0 broken (explicit kill or server shutdown).
X connection to :0.0 broken (explicit kill or server shutdown).

richardma_1204

下面是从2006-11-20的sybase的日志文件内容，请查看
00:00000:00000:2006/11/20 09:43:15.53 kernel  ENGINE
00:00000:00000:2006/11/20 09:43:15.57 kernel  Using config area from primary master device.
00:00000:00000:2006/11/20 09:43:15.57 kernel  Warning: Using default file '/export/home/ydsybase/lkydsvr.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Using 1024 file descriptors.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Adaptive Server Enterprise/11.9.3/64bit/1337/P/SWR 9449 ESD 9/Sun_svr4/OS 5.7/FBO/Fri Apr 27 23:32:12 2001
00:00000:00000:2006/11/20 09:43:18.00 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Copyright 1987, 2001
00:00000:00000:2006/11/20 09:43:18.00 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/11/20 09:43:18.00 kernel  
00:00000:00000:2006/11/20 09:43:18.00 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/11/20 09:43:18.00 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/11/20 09:43:18.00 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/11/20 09:43:18.00 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/11/20 09:43:18.00 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/11/20 09:43:18.00 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/11/20 09:43:18.00 kernel  Using '/export/home/ydsybase/lkydsvr.cfg' for configuration information.
00:00000:00000:2006/11/20 09:43:18.00 kernel  Logging SQL Server messages in file '/export/home/ydsybase/install/lkydsvr.log'.
00:00000:00000:2006/11/20 09:43:18.04 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/11/20 09:43:18.04 kernel  Network and device connection limit is 1014.
00:00000:00000:2006/11/20 09:43:18.09 server  Number of proc buffers allocated: 47928.
00:00000:00000:2006/11/20 09:43:18.14 server  Proc header memory allocated 23964 pages for each per engine cache
00:00000:00000:2006/11/20 09:43:18.15 server  Number of blocks left for proc headers: 48025.
00:00000:00000:2006/11/20 09:43:18.29 server   Memory allocated for the default data cache cachelet 1: 348038 Kb
00:00000:00000:2006/11/20 09:43:18.47 server  Size of the 2K memory pool: 348038 Kb
00:00000:00000:2006/11/20 09:43:18.48 kernel  Initializing virtual device 0, '/ydmis/master.dat'
00:00000:00000:2006/11/20 09:43:18.48 kernel  Virtual device 0 started using standard unix i/o.
00:00000:00000:2006/11/20 09:43:18.48 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/11/20 09:43:18.48 kernel  Either the config parameter 'use security 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:2006/11/20 09:43:18.48 kernel  engine 0, os pid 29693  online
00:00000:00000:2006/11/20 09:43:18.48 server  No active traceflags
00:00000:00001:2006/11/20 09:43:18.48 server  Opening Master Database ...
00:00000:00001:2006/11/20 09:43:18.58 server  Loading SQL Server's default sort order and character set
tli_ninit: sninteraface: machname /dev/tcp, netname tcp
00:00000:00002:2006/11/20 09:43:18.59 kernel  ninit:0: listener type: master
00:00000:00002:2006/11/20 09:43:18.59 kernel  ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2006/11/20 09:43:18.59 kernel  ninit:0: listener raw address: \x000211940a8c89230000000000000000
00:00000:00002:2006/11/20 09:43:18.59 kernel  ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2006/11/20 09:43:18.59 server  Recovering database 'master'
00:00000:00001:2006/11/20 09:43:18.66 server  Redo pass of recovery has processed 2 committed and 0 aborted transactions.
00:00000:00001:2006/11/20 09:43:19.57 server  Database 'master' is now online.
00:00000:00001:2006/11/20 09:43:19.58 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:19.74 server  0 dump conditions detected at boot time
00:00000:00001:2006/11/20 09:43:19.76 server  server is unnamed
00:00000:00001:2006/11/20 09:43:19.76 server  Activating disk 'lkyd_data'.
00:00000:00001:2006/11/20 09:43:19.76 kernel  Initializing virtual device 2, '/ydmis/lkyd_data.dat'
00:00000:00001:2006/11/20 09:43:19.76 kernel  Virtual device 2 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.76 server  Activating disk 'lkyd_data2'.
00:00000:00001:2006/11/20 09:43:19.76 kernel  Initializing virtual device 9, '/ydmis/lkyd_data2.dat'
00:00000:00001:2006/11/20 09:43:19.76 kernel  Virtual device 9 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'lkyd_index'.
00:00000:00001:2006/11/20 09:43:19.77 kernel  Initializing virtual device 4, '/ydmis/lkyd_index.dat'
00:00000:00001:2006/11/20 09:43:19.77 kernel  Virtual device 4 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'lkyd_log'.
00:00000:00001:2006/11/20 09:43:19.77 kernel  Initializing virtual device 3, '/ydmis/lkyd_log.dat'
00:00000:00001:2006/11/20 09:43:19.77 kernel  Virtual device 3 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'lkyd_tempdb'.
00:00000:00001:2006/11/20 09:43:19.77 kernel  Initializing virtual device 7, '/ydmis/lkyd_tempdb.dat'
00:00000:00001:2006/11/20 09:43:19.77 kernel  Virtual device 7 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'lkyd_tempdb1'.
00:00000:00001:2006/11/20 09:43:19.77 kernel  Initializing virtual device 8, '/ydmis/lkyd_tempdb1.dat'
00:00000:00001:2006/11/20 09:43:19.77 kernel  Virtual device 8 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'lkyd_test'.
00:00000:00001:2006/11/20 09:43:19.77 kernel  Initializing virtual device 5, '/ydmis/lkyd_test.dat'
00:00000:00001:2006/11/20 09:43:19.77 kernel  Virtual device 5 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.77 server  Activating disk 'sysprocsdev'.
00:00000:00001:2006/11/20 09:43:19.78 kernel  Initializing virtual device 1, '/ydmis/Sybsystemprocs.dat'
00:00000:00001:2006/11/20 09:43:19.78 kernel  Virtual device 1 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.78 server  Activating disk 'test_log'.
00:00000:00001:2006/11/20 09:43:19.78 kernel  Initializing virtual device 6, '/ydmis/test_log.dat'
00:00000:00001:2006/11/20 09:43:19.78 kernel  Virtual device 6 started using standard unix i/o.
00:00000:00001:2006/11/20 09:43:19.86 server  Recovering database 'model'.
00:00000:00001:2006/11/20 09:43:20.26 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:20.45 server  Database 'model' is now online.
00:00000:00001:2006/11/20 09:43:20.45 server  Clearing temp db
00:00000:00001:2006/11/20 09:43:22.03 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:22.21 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:22.39 server  Database 'tempdb' is now online.
00:00000:00001:2006/11/20 09:43:22.39 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:22.65 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/11/20 09:43:24.16 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:24.36 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2006/11/20 09:43:24.47 server  Recovering database 'ydmis'.
00:00000:00001:2006/11/20 09:43:24.66 server  Redo pass of recovery has processed 13 committed and 0 aborted transactions.
00:00000:00001:2006/11/20 09:43:41.84 server  The transaction log in the database 'ydmis' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:42.05 server  Database 'ydmis' is now online.
00:00000:00001:2006/11/20 09:43:42.10 server  Recovering database 'lkyd_test'.
00:00000:00001:2006/11/20 09:43:59.34 server  The transaction log in the database 'lkyd_test' will use I/O size of 2 Kb.
00:00000:00001:2006/11/20 09:43:59.57 server  Database 'lkyd_test' is now online.
00:00000:00001:2006/11/20 09:43:59.58 server  Recovery complete.
00:00000:00001:2006/11/20 09:43:59.58 server  SQL Server's default sort order is:
00:00000:00001:2006/11/20 09:43:59.58 server          'bin_iso_1' (ID = 50)
00:00000:00001:2006/11/20 09:43:59.58 server  on top of default character set:
00:00000:00001:2006/11/20 09:43:59.58 server          'iso_1' (ID = 1).
00:00000:00001:2006/11/20 09:43:59.58 server  Loaded default Unilib conversion handle.