★★服务器速度慢，参照配置文件请大家提个意见！

bhuking

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

sun 450 ，前一段时间运行很好，有一天下午到现在一直很慢，不知是什么原因？
请给各意见？
[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 = 30
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 = 6
number of open objects = 1500
open object spinlock ratio = DEFAULT
number of open indexes = 1500
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 = 100
allow remote access = DEFAULT
number of remote logins = 50
number of remote sites = DEFAULT
max number network listeners = 15
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 = 200

[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 = 256000
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 = 200
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 = 500
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 = 25000
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

jasonshan

很难说怎样的参数配置才是最佳的，这和你的服务器硬件配置、应用都有关系，不过有几点可以供你参考的
1、你可以用sp_monitorconfig 'number of open indexes'，以及sp_monitorconfig 'number of open objects'来检查你的这两个参数是否够用
2、'total memory'的设置是否合理，如果你的服务器只做数据库应用的话，那么留给操作系统的内存太多没什么好处
3、如果你有两个以上的CPU，把'max online engines'设置成你的CPU个数，超过两个CPU的，把'max parallel degree'设置为CPU个数-1或CPU个数，'max scan parallel degree'设置为'max parallel degree'的值或该值-1，以使ASE充分利用CPU资源，并进行并发查询
4、用set showplan,noexec on来检查你的主要查询命令所使用的索引情况，并适当调整索引，必要时通过update statistics命令更新表的状态以使ASE能正确使用索引，之后用sp_recompile要求ASE重新编译存储过程和触发器以正确使用索引
5、其他方面就看你的应用了，如数据量、访问连接等

zhhui2000

另外也可以通过sp_sysmon看下瓶颈在哪儿

bhuking

非常感谢，我试试看