SYBASE参数设置

《SYBASE参数设置》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、SYBASE参数设置主要修改参数为：[DiskI/O]numberofdevices=20[PhysicalMemory]totalmemory=512000##数据库可用物理内存，以2k为单位[Processors]maxonlineengines=2##CPU数[U]HPWG.cfg全文如下：################################################################################ConfigurationFilefortheSybaseSQLServer##Pleaser

2、eadtheSystemAdministrationGuide(SAG)#beforechanginganyofthevaluesinthisfile.###############################################################################[ConfigurationOptions][GeneralInformation][Backup/Recovery]recoveryintervalinminutes=DEFAULTprintrecoveryinformation=DEFA

3、ULTtaperetentionindays=DEFAULT[CacheManager]numberofoamtrips=DEFAULTnumberofindextrips=DEFAULTprocedurecachepercent=DEFAULTmemoryalignmentboundary=DEFAULTglobalasyncprefetchlimit=DEFAULTglobalcachepartitionnumber=DEFAULT[NamedCache:defaultdatacache]cachesize=DEFAULTcachestatu

4、s=defaultdatacachecachereplacementpolicy=DEFAULTlocalcachepartitionnumber=DEFAULT[Meta-DataCaches]numberofopendatabases=DEFAULTnumberofopenobjects=DEFAULTopenobjectspinlockratio=DEFAULTnumberofopenindexes=DEFAULTopenindexhashspinlockratio=DEFAULTopenindexspinlockratio=DEFAULT

5、[DiskI/O]allowsqlserverasynci/o=DEFAULTdiski/ostructures=DEFAULTpageutilizationpercent=DEFAULTnumberofdevices=20disablediskmirroring=DEFAULTdisablecharactersetconversions=DEFAULTenableunicodeconversions=DEFAULTsizeofunilibcache=DEFAULT[NetworkCommunication]defaultnetworkpacke

6、tsize=DEFAULTmaxnetworkpacketsize=DEFAULTremoteserverpre-readpackets=DEFAULTnumberofremoteconnections=DEFAULTallowremoteaccess=DEFAULTnumberofremotelogins=DEFAULTnumberofremotesites=DEFAULTmaxnumbernetworklisteners=15tcpnodelay=DEFAULTallowsendmsg=DEFAULTsyb_sendmsgportnumber

7、=DEFAULT[O/SResources]maxasynci/osperengine=500maxasynci/osperserver=DEFAULT[ParallelQuery]numberofworkerprocesses=DEFAULTmemoryperworkerprocess=DEFAULTmaxparalleldegree=DEFAULTmaxscanparalleldegree=DEFAULT[PhysicalResources][PhysicalMemory]#数据库可用物理内存，以2k为单位totalmemory=512000

8、additionalnetworkmemory=DEFAULTlocksharedmemory=DEFAULTsharedmemorys