Chinaunix首页 | 论坛 | 博客
  • 博客访问: 675264
  • 博文数量: 220
  • 博客积分: 4813
  • 博客等级: 上校
  • 技术积分: 2364
  • 用 户 组: 普通用户
  • 注册时间: 2005-10-31 21:54
  • 认证徽章:
个人简介

All right, waiting for you to die, I'll laugh ...

文章分类

全部博文(220)

文章存档

2016年(4)

2014年(4)

2013年(4)

2012年(4)

2011年(49)

2010年(127)

2009年(6)

2008年(16)

2007年(4)

2006年(1)

2005年(1)

分类: Sybase

2008-09-03 09:24:04

主要修改参数为: 
[Disk I/O] 
number of devices=20 
[Physical Memory] 
total memory = 512000 ##数据库可用物理内存,以2k为单位 
[Processors] 
max online engines=2 ##CPU数 
HPWG.cfg全文如下: 
############################################################################## 

# Configuration File for the Sybase SQL Server 

# Please read the System Administration Guide (SAG) 
# before changing any of the values in this file. 

############################################################################## 
 
[Configuration Options] 
[General Information] 
[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 = DEFAULT 
memory alignment boundary = DEFAULT 
global async prefetch limit = DEFAULT 
global cache partition number = DEFAULT 
[Named Cache:default data cache] 
cache size = DEFAULT 
cache status = default data cache 
cache replacement policy = DEFAULT 
local cache partition number = DEFAULT 
[Meta-Data Caches] 
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 
[Disk I/O] 
allow sql server async i/o = DEFAULT 
disk i/o structures = DEFAULT 
page utilization percent = DEFAULT 
number of devices =20 
disable disk mirroring = 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 = DEFAULT 
allow remote access = DEFAULT 
number of remote logins = DEFAULT 
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 = 500 
max async i/os per server = DEFAULT 
[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] 
#数据库可用物理内存,以2k为单位 
total memory = 512000 
additional network memory = DEFAULT 
lock shared memory = DEFAULT 
shared memory starting address = DEFAULT 
max SQL text monitored = DEFAULT 
[Processors] 
max online engines = 2 #CPU数 
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  网管bitscn_com
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  网管u家u.bitsCN.com
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 = 10 
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 = 100 ##用户连接数 
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 = 50000 #锁数 
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 
网管bitscn_com
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
阅读(3130) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册