############################################################################## # # Configuration File for the Sybase SQL Server # #  lease read the System Administration Guide (SAG) # before changing any of the values in this file. # ############################################################################## [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 = DEFAULT 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 = 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 = 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 = DEFAULT 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 = 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] total memory = 384000 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 = DEFAULT 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 = 50 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 = 45000 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
|