午啪啪夜福利无码亚洲,亚洲欧美suv精品,欧洲尺码日本尺码专线美国,老狼影院成年女人大片

1、 四川XX銷售公司財務管理信息系統(tǒng) 數(shù)據(jù)庫性能優(yōu)化測試方案 四川省XX科技有限公司 目 錄1、方案制訂目的22、方案參與人員33、平臺構成33.1 硬件平臺構成33.2 操作系統(tǒng)平臺43.3 數(shù)據(jù)庫平臺43.4 群集軟件54、當前配置參數(shù)55、測試方案175.1優(yōu)化Sybase的內存使用參數(shù)175.2增加Sybase的內存使用296、系統(tǒng)升級建議301、 方案制訂目的四川XX銷售公司財務管理信息系統(tǒng)是海量數(shù)據(jù)庫系統(tǒng)，目前庫表容量達100GB。用戶使用過程中反映很慢，月底綜合查詢響應時長達半小時，平常錄入一條財務憑證的保存需要幾分鐘才能完成。Sybase性能分析I/O忙，為定性分析原因，查找系統(tǒng)2、瓶頸，達到用戶要求并為用戶下一步升級更新系統(tǒng)提供詳實參考，故制定本測試方案。2、方案參與人員為充分證實主機、存儲、數(shù)據(jù)庫等企業(yè)級產(chǎn)品的卓越性能。特邀主機、存儲、數(shù)據(jù)庫廠商的資深專家參與修訂并指導、實施本方案。并用海量數(shù)據(jù)庫系統(tǒng)的成功經(jīng)驗（如電信、移動的記費系統(tǒng)）來指導本方案。本方案應有以下人員參與：A：Sun的資深主機與存儲系統(tǒng)工程師B：Sybase的資深數(shù)據(jù)庫工程師C：系統(tǒng)集成商四川中陸科貿(mào)有限公司D：Sybase數(shù)據(jù)庫維護商3、平臺構成3.1 硬件平臺構成 客戶端 E6900A分區(qū) E6800A分區(qū) E6900B分區(qū) S6900node1 S6800node2 (17F)E-SW1 (173、G)E-SW2 (16F)SAN-FC-SW (17E)B-200E光纖交換機 (17B)(16A) Sun6140 磁盤陣列16*300GB FC磁盤（16B） Sybase數(shù)據(jù)庫存儲 Sun 6130磁盤陣列28*73GB FC圖例： Sun cluster 以太網(wǎng)絡 FC-AL數(shù)據(jù)通道 圖圖一 四川石油銷售公司財務信息系統(tǒng)架構圖系統(tǒng)相關設備如下：l 數(shù)據(jù)庫服務器：SUN E6900服務器一臺，劃分為2個獨立的硬件分區(qū)，分別運行Sybase數(shù)據(jù)庫和中間件，分區(qū)一和SUN E6800 A分區(qū)之間通過SUN Cluster軟件組成高可用工作方式；l 應用服務器：SUN E6900服務器的B硬件4、分區(qū)，運行平臺服務器；l 光纖交換機：采用一臺Brocade 3250和一臺Brocade 200E組成雙冗余的光纖存儲區(qū)域網(wǎng)絡（SAN），其中Brocade 3250配置8個光纖接口，目前已全部使用完，Brocade 200E配置為16口，當前激活12口，已使用10口；l 光纖磁盤陣列：采用一臺SUN ST6140和一臺SUN ST6130。ST6140配置16塊15KRPM 300GB硬盤，作為Sybase數(shù)據(jù)庫的存儲空間。系統(tǒng)硬件配置詳情表物理設備E6900 E6900E69800分區(qū)名（Domain）A分區(qū)B分區(qū)A分區(qū)Solaris Nodename S6900node1 S6900n5、ode2linshou1hostnameS6900node1S6900node2linshou1布置應用財務Sybase主數(shù)據(jù)庫服務器應用服務器配置清單系統(tǒng)板：SB1 SB3 SB4 IB8 CPU Core：24X1.8Ghz(內存：48GB系統(tǒng)板： SB5 I/O板：IB9CPU Core：8X1.8Ghz內存：16GB）系統(tǒng)板： SB0 I/O板：IB6CPU Core：12X1.2Ghz內存：48GB3.2 操作系統(tǒng)平臺系統(tǒng)均運行Sun Solaris10 Generic_118833-36操作系統(tǒng), OpenWin3.8,CDE1. 4。3.3 數(shù)據(jù)庫平臺運行Sybase12.5企業(yè)6、版數(shù)據(jù)庫。3.4 群集軟件Sun cluster3.1。4、當前配置參數(shù)A、存儲陣列參數(shù)Write back已使能block size：512K，未針對數(shù)據(jù)庫優(yōu)化B、Sybase參數(shù)1、 存儲使用的文件系統(tǒng)2、 內存使用參數(shù)情況如下#Configuration File for the Sybase SQL Server#Please read the System Administration Guide (SAG)#before changing any of the values in this file.#Configuration OptionsGeneral Information7、Backup/Recoveryrecovery interval in minutes = 1print recovery information = DEFAULTtape retention in days = DEFAULTCache Managernumber of oam trips = DEFAULTnumber of index trips = DEFAULTmemory alignment boundary = DEFAULTglobal async prefetch limit = DEFAULTglobal cache partition number = 8Named C8、ache:c_acfzjecache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_acfzslcache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed9、 Cache:c_achsjecache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achsje_uincache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAUL10、TNamed Cache:c_achsslcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achssl_uincache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = 11、DEFAULTNamed Cache:c_ackmjecache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_ackmslcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number 12、= DEFAULTNamed Cache:c_acwljecache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_acxjjecache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition numbe13、r = DEFAULTNamed Cache:c_aczrzxcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzdwgscache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition num14、ber = DEFAULTNamed Cache:c_hzdwsjcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzdyzdcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition n15、umber = DEFAULTNamed Cache:c_hzhzdcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzlzdcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition n16、umber = DEFAULTNamed Cache:c_lsacdwcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsbmjecache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition17、 number = DEFAULTNamed Cache:c_lsdwkmcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lshspzcache size = 1024Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partit18、ion number = DEFAULTNamed Cache:c_lshspz_uincache size = 300Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lshxsjcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache 19、partition number = DEFAULTNamed Cache:c_lskmxxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lskmzxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cach20、e partition number = DEFAULTNamed Cache:c_lspzbhcache size = 50Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lspzk1cache size = 1024Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal ca21、che partition number = DEFAULTNamed Cache:c_lspzk1_uincache size = 300Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussjcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlo22、cal cache partition number = DEFAULTNamed Cache:c_lsussj_bmcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_cpcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU repla23、cementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_dwcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_grcache size = 200Mcache status = mixed cachecache replacement policy = relaxed L24、RU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_hscache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_kmcache size = 200Mcache status = mixed cachecache replacement policy = r25、elaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_pzcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_xjcache size = 100Mcache status = mixed cachecache replacement po26、licy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_zxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lswljecache size = 200Mcache status = mixed cachecache replaceme27、nt policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lswlyscache size = 800Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lswlys_uincache size = 200Mcache status = mixed cachecache rep28、lacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:default data cachecache size = 8Gcache status = default data cachecache replacement policy = DEFAULTlocal cache partition number = 3216K I/O Buffer Poolpool size = 2048.0000Mwash size = DEFAULTlocal async pref29、etch limit = DEFAULTNamed Cache:syslog_cachecache size = 2048Mcache status = log onlycache replacement policy = DEFAULTlocal cache partition number = 16Named Cache:tempdb_cachecache size = 8192Mcache status = mixed cachecache replacement policy = DEFAULTlocal cache partition number = 3216K I/O Buffe30、r Poolpool size = 4096.0000Mwash size = DEFAULTlocal async prefetch limit = DEFAULTMeta-Data Cachesnumber of open databases = 20number of open objects = 50000open object spinlock ratio = DEFAULTnumber of open indexes = 50000open index hash spinlock ratio = DEFAULTopen index spinlock ratio = DEFAULTp31、artition groups = DEFAULTpartition spinlock ratio = DEFAULTDisk I/Odisk i/o structures = DEFAULTnumber of large i/o buffers = DEFAULTpage utilization percent = DEFAULTnumber of devices = 50disable disk mirroring = DEFAULTallow sql server async i/o = DEFAULTLanguagesdisable character set conversions 32、= DEFAULTUnicodeenable unicode normalization = DEFAULTenable surrogate processing = DEFAULTenable unicode conversions = DEFAULTsize of unilib cache = DEFAULTNetwork Communicationdefault network packet size = DEFAULTmax network packet size = DEFAULTremote server pre-read packets = DEFAULTnumber of re33、mote connections = DEFAULTnumber of remote logins = DEFAULTnumber of remote sites = DEFAULTmax number network listeners = DEFAULTtcp no delay = DEFAULTallow sendmsg = DEFAULTsyb_sendmsg port number = DEFAULTallow remote access = DEFAULTO/S Resourcesmax async i/os per engine = DEFAULTmax async i/os p34、er server = DEFAULTParallel Querynumber of worker processes = DEFAULTmemory per worker process = DEFAULTmax parallel degree = DEFAULTmax scan parallel degree = DEFAULTPhysical ResourcesPhysical Memorymax memory = 20971520additional network memory = DEFAULTshared memory starting address = DEFAULTallo35、cate max shared memory = DEFAULTdynamic allocation on demand = DEFAULTlock shared memory = DEFAULTheap memory per user = DEFAULTProcessorsmax online engines = 11number of engines at startup = 11SQL Server Administrationprocedure cache size = 2560000default database size = DEFAULTidentity burning set36、 factor = DEFAULTallow nested triggers = DEFAULTallow updates to system tables = DEFAULTdefault fill factor percent = DEFAULTdefault exp_row_size percent = DEFAULTnumber of mailboxes = DEFAULTnumber of messages = DEFAULTnumber of alarms = DEFAULTnumber of pre-allocated extents = DEFAULTevent buffers37、 per engine = DEFAULTcpu accounting flush interval = DEFAULTi/o accounting flush interval = DEFAULTsql server clock tick length = DEFAULTrunnable process search count = DEFAULTi/o polling process count = DEFAULTtime slice = DEFAULTcpu grace time = DEFAULTnumber of sort buffers = DEFAULTsize of auto 38、identity column = DEFAULTidentity grab size = DEFAULThousekeeper free write percent = DEFAULTenable housekeeper GC = DEFAULTallow resource limits = DEFAULTnumber of aux scan descriptors = DEFAULTSQL Perfmon Integration = DEFAULTallow backward scans = DEFAULTlicense information = DEFAULTenable sort-m39、erge join and JTC = 1abstract plan load = DEFAULTabstract plan dump = DEFAULTabstract plan replace = DEFAULTabstract plan cache = DEFAULTtext prefetch size = DEFAULTenable HA = DEFAULTnumber of histogram steps = DEFAULTsampling percent = DEFAULTUser Environmentnumber of user connections = 1000stack 40、size = DEFAULTstack guard size = DEFAULTpermission cache entries = DEFAULTuser log cache size = DEFAULTuser log cache spinlock ratio = DEFAULTLock Managernumber of locks = 500000deadlock checking period = DEFAULTlock spinlock ratio = DEFAULTlock address spinlock ratio = DEFAULTlock table spinlock ra41、tio = DEFAULTlock hashtable size = DEFAULTlock scheme = DEFAULTlock wait period = DEFAULTread committed with lock = DEFAULTprint deadlock information = DEFAULTdeadlock retries = DEFAULTpage lock promotion HWM = DEFAULTpage lock promotion LWM = DEFAULTpage lock promotion PCT = DEFAULTrow lock promoti42、on HWM = DEFAULTrow lock promotion LWM = DEFAULTrow lock promotion PCT = DEFAULTSecurity Relatedsystemwide password expiration = DEFAULTaudit queue size = DEFAULTcurread change w/ open cursors = DEFAULTallow procedure grouping = DEFAULTselect on syscomments.text = DEFAULTauditing = DEFAULTcurrent au43、dit table = DEFAULTsuspend audit when device full = DEFAULTenable row level access = DEFAULTcheck password for digit = DEFAULTminimum password length = DEFAULTmaximum failed logins = DEFAULTenable ssl = DEFAULTunified login required = DEFAULTuse security services = DEFAULTmsg confidentiality reqd = 44、DEFAULTmsg integrity reqd = DEFAULTsecure default login = DEFAULTExtended Stored Procedureesp unload dll = DEFAULTesp execution priority = DEFAULTesp execution stacksize = DEFAULTxp_cmdshell context = DEFAULTstart mail session = DEFAULTError Logevent logging = DEFAULTlog audit logon success = DEFAUL45、Tlog audit logon failure = DEFAULTevent log computer name = DEFAULTRep Agent Thread Administrationenable rep agent threads = DEFAULTComponent Integration Servicesenable cis = DEFAULTcis connect timeout = DEFAULTcis bulk insert batch size = DEFAULTmax cis remote connections = DEFAULTcis packet size =46、 DEFAULTcis cursor rows = DEFAULTenable snmp = DEFAULTenable file access = DEFAULTcis bulk insert array size = DEFAULTenable full-text search = DEFAULTcis rpc handling = DEFAULTJava Servicesenable java = DEFAULTsize of process object heap = DEFAULTsize of shared class heap = DEFAULTsize of global fi47、xed heap = DEFAULTnumber of java sockets = DEFAULTenable enterprise java beans = DEFAULTDTM Administrationenable DTM = DEFAULTenable xact coordination = DEFAULTxact coordination interval = DEFAULTnumber of dtx participants = DEFAULTstrict dtm enforcement = DEFAULTtxn to pss ratio = DEFAULTdtm lock t48、imeout period = DEFAULTdtm detach timeout period = DEFAULTDiagnosticsdump on conditions = DEFAULTmaximum dump conditions = DEFAULTnumber of ccbs = DEFAULTcaps per ccb = DEFAULTaverage cap size = DEFAULTMonitoringenable monitoring = DEFAULTsql text pipe active = DEFAULTsql text pipe max messages = DE49、FAULTplan text pipe active = DEFAULTplan text pipe max messages = DEFAULTstatement pipe active = DEFAULTstatement pipe max messages = DEFAULTerrorlog pipe active = DEFAULTerrorlog pipe max messages = DEFAULTdeadlock pipe active = DEFAULTdeadlock pipe max messages = DEFAULTwait event timing = DEFAULT50、process wait events = DEFAULTobject lockwait timing = DEFAULTSQL batch capture = DEFAULTstatement statistics active = DEFAULTper object statistics active = DEFAULTmax SQL text monitored = DEFAULTperformance monitoring option = DEFAULT5、測試方案 測試方案圍繞提高I/O性能進行。在系統(tǒng)平臺一定的情況下，影響I/O性能的表現(xiàn)不外乎如下：a. 存儲陣列的I/O性能參數(shù)51、優(yōu)選，包括其cach的使用策略和I/O block size選擇b. 數(shù)據(jù)庫的I/O block size與應用、OS、陣列的I/O block size的優(yōu)化與匹配c. 數(shù)據(jù)庫是否使用裸設備d. 數(shù)據(jù)庫使用文件系統(tǒng)時，文件系統(tǒng)的I/O參數(shù)優(yōu)化e. 數(shù)據(jù)庫碎塊對I/O性能的影響f. 數(shù)據(jù)庫使用的內存大小及內存使用參數(shù) 相對于100GB的數(shù)據(jù)庫庫表大小，該系統(tǒng)目前內存偏小。由于該應用系企業(yè)關鍵應用，目前可方便實施的測試也主要在內存上。所以本次測試主要從增加數(shù)據(jù)庫使用內存及內存使用參數(shù)進行。5.1優(yōu)化Sybase的內存使用參數(shù)內存使用參數(shù)請Sybase資深專家優(yōu)化，用戶與MIS軟件開發(fā)維護商一道按52、Sybase資深專家的要求，提供主要庫表結構的參數(shù)，如主要表目前的記錄數(shù)數(shù)量級、字段內容、各字段特點，字段間的相互關系，表、索引、報表間關聯(lián)信息等。 #Configuration File for the Sybase SQL Server#Please read the System Administration Guide (SAG)#before changing any of the values in this file.#Configuration OptionsGeneral InformationBackup/Recoveryrecovery interval in minut53、es = DEFAULTprint recovery information = DEFAULTtape retention in days = DEFAULTCache Managernumber of oam trips = DEFAULTnumber of index trips = DEFAULTmemory alignment boundary = DEFAULTglobal async prefetch limit = DEFAULTglobal cache partition number = 8Named Cache:c_acfzjecache size = 500Mcache54、 status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_acfzslcache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achsjecache size = 200Mcac55、he status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achsje_uincache size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achsslcache size = 256、00Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_achssl_uincache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_ackmjecache si57、ze = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_ackmslcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_acwljecache 58、size = 500Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_acxjjecache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_aczrzxcach59、e size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzdwgscache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzdwsjca60、che size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzdyzdcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzhzdc61、ache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_hzlzdcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsacdw62、cache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsbmjecache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsdw63、kmcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lshspzcache size = 1024Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_l64、shspz_uincache size = 300Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lshxsjcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cac65、he:c_lskmxxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lskmzxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed C66、ache:c_lspzbhcache size = 50Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lspzk1cache size = 1024Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed67、 Cache:c_lspzk1_uincache size = 300Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussjcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAUL68、TNamed Cache:c_lsussj_bmcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_cpcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number 69、= DEFAULTNamed Cache:c_lsussj_dwcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_grcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition70、 number = DEFAULTNamed Cache:c_lsussj_hscache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_kmcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache p71、artition number = DEFAULTNamed Cache:c_lsussj_pzcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lsussj_xjcache size = 100Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal72、 cache partition number = DEFAULTNamed Cache:c_lsussj_zxcache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lswljecache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU replacement73、local cache partition number = DEFAULTNamed Cache:c_lswlyscache size = 800Mcache status = mixed cachecache replacement policy = relaxed LRU replacementlocal cache partition number = DEFAULTNamed Cache:c_lswlys_uincache size = 200Mcache status = mixed cachecache replacement policy = relaxed LRU repla74、cementlocal cache partition number = DEFAULTNamed Cache:default data cachecache size = 16Gcache status = default data cachecache replacement policy = DEFAULTlocal cache partition number = 324K I/O Buffer Poolpool size = 2048.0000Mwash size = DEFAULTlocal async prefetch limit = DEFAULTNamed Cache:sys75、log_cachecache size = 2048Mcache status = log onlycache replacement policy = DEFAULTlocal cache partition number = 16Named Cache:tempdb_cachecache size = 8192Mcache status = mixed cachecache replacement policy = DEFAULTlocal cache partition number = 3216K I/O Buffer Poolpool size = 4096.0000Mwash si76、ze = DEFAULTlocal async prefetch limit = DEFAULTMeta-Data Cachesnumber of open databases = 24number of open objects = 50000open object spinlock ratio = DEFAULTnumber of open indexes = 50000open index hash spinlock ratio = DEFAULTopen index spinlock ratio = DEFAULTpartition groups = DEFAULTpartition 77、spinlock ratio = DEFAULTDisk I/Odisk i/o structures = DEFAULTnumber of large i/o buffers = DEFAULTpage utilization percent = DEFAULTnumber of devices = 60disable disk mirroring = DEFAULTallow sql server async i/o = DEFAULTLanguagesdisable character set conversions = DEFAULTUnicodeenable unicode norm78、alization = DEFAULTenable surrogate processing = DEFAULTenable unicode conversions = DEFAULTsize of unilib cache = DEFAULTNetwork Communicationdefault network packet size = DEFAULTmax network packet size = DEFAULTremote server pre-read packets = DEFAULTnumber of remote connections = DEFAULTnumber of79、 remote logins = DEFAULTnumber of remote sites = DEFAULTmax number network listeners = DEFAULTtcp no delay = DEFAULTallow sendmsg = DEFAULTsyb_sendmsg port number = DEFAULTallow remote access = DEFAULTO/S Resourcesmax async i/os per engine = DEFAULTmax async i/os per server = DEFAULTParallel Querynu80、mber of worker processes = 40memory per worker process = DEFAULTmax parallel degree = 6max scan parallel degree = 6Physical ResourcesPhysical Memorymax memory = 23068672additional network memory = DEFAULTshared memory starting address = DEFAULTallocate max shared memory = DEFAULTdynamic allocation o81、n demand = DEFAULTlock shared memory = DEFAULTheap memory per user = DEFAULTProcessorsmax online engines = 18number of engines at startup = 18SQL Server Administrationprocedure cache size = 2560000default database size = DEFAULTidentity burning set factor = DEFAULTallow nested triggers = DEFAULTallo82、w updates to system tables = DEFAULTdefault fill factor percent = DEFAULTdefault exp_row_size percent = DEFAULTnumber of mailboxes = DEFAULTnumber of messages = DEFAULTnumber of alarms = 200number of pre-allocated extents = DEFAULTevent buffers per engine = DEFAULTcpu accounting flush interval = DEF83、AULTi/o accounting flush interval = DEFAULTsql server clock tick length = DEFAULTrunnable process search count = DEFAULTi/o polling process count = DEFAULTtime slice = DEFAULTcpu grace time = 1000number of sort buffers = 15000size of auto identity column = DEFAULTidentity grab size = DEFAULThousekee84、per free write percent = DEFAULTenable housekeeper GC = DEFAULTallow resource limits = DEFAULTnumber of aux scan descriptors = DEFAULTSQL Perfmon Integration = DEFAULTallow backward scans = DEFAULTlicense information = DEFAULTenable sort-merge join and JTC = 1abstract plan load = DEFAULTabstract pla85、n dump = DEFAULTabstract plan replace = DEFAULTabstract plan cache = DEFAULTtext prefetch size = DEFAULTenable HA = DEFAULTnumber of histogram steps = DEFAULTsampling percent = DEFAULTUser Environmentnumber of user connections = 1000stack size = DEFAULTstack guard size = DEFAULTpermission cache entr86、ies = DEFAULTuser log cache size = DEFAULTuser log cache spinlock ratio = DEFAULTLock Managernumber of locks = 500000deadlock checking period = DEFAULTlock spinlock ratio = DEFAULTlock address spinlock ratio = DEFAULTlock table spinlock ratio = DEFAULTlock hashtable size = DEFAULTlock scheme = DEFAU87、LTlock wait period = DEFAULTread committed with lock = DEFAULTprint deadlock information = DEFAULTdeadlock retries = DEFAULTpage lock promotion HWM = DEFAULTpage lock promotion LWM = DEFAULTpage lock promotion PCT = DEFAULTrow lock promotion HWM = DEFAULTrow lock promotion LWM = DEFAULTrow lock prom88、otion PCT = DEFAULTSecurity Relatedsystemwide password expiration = DEFAULTaudit queue size = DEFAULTcurread change w/ open cursors = DEFAULTallow procedure grouping = DEFAULTselect on syscomments.text = DEFAULTauditing = DEFAULTcurrent audit table = DEFAULTsuspend audit when device full = DEFAULTen89、able row level access = DEFAULTcheck password for digit = DEFAULTminimum password length = DEFAULTmaximum failed logins = DEFAULTenable ssl = DEFAULTunified login required = DEFAULTuse security services = DEFAULTmsg confidentiality reqd = DEFAULTmsg integrity reqd = DEFAULTsecure default login = DEF90、AULTExtended Stored Procedureesp unload dll = DEFAULTesp execution priority = DEFAULTesp execution stacksize = DEFAULTxp_cmdshell context = DEFAULTstart mail session = DEFAULTError Logevent logging = DEFAULTlog audit logon success = DEFAULTlog audit logon failure = DEFAULTevent log computer name = D91、EFAULTRep Agent Thread Administrationenable rep agent threads = 1Component Integration Servicesenable cis = DEFAULTcis connect timeout = DEFAULTcis bulk insert batch size = DEFAULTmax cis remote connections = DEFAULTcis packet size = DEFAULTcis cursor rows = DEFAULTenable snmp = DEFAULTenable file a92、ccess = DEFAULTcis bulk insert array size = DEFAULTenable full-text search = DEFAULTcis rpc handling = DEFAULTJava Servicesenable java = DEFAULTsize of process object heap = DEFAULTsize of shared class heap = DEFAULTsize of global fixed heap = DEFAULTnumber of java sockets = DEFAULTenable enterprise93、 java beans = DEFAULTDTM Administrationenable DTM = DEFAULTenable xact coordination = DEFAULTxact coordination interval = DEFAULTnumber of dtx participants = DEFAULTstrict dtm enforcement = DEFAULTtxn to pss ratio = DEFAULTdtm lock timeout period = DEFAULTdtm detach timeout period = DEFAULTDiagnosti94、csdump on conditions = DEFAULTmaximum dump conditions = DEFAULTnumber of ccbs = DEFAULTcaps per ccb = DEFAULTaverage cap size = DEFAULTMonitoringenable monitoring = DEFAULTsql text pipe active = DEFAULTsql text pipe max messages = DEFAULTplan text pipe active = DEFAULTplan text pipe max messages = D95、EFAULTstatement pipe active = DEFAULTstatement pipe max messages = DEFAULTerrorlog pipe active = DEFAULTerrorlog pipe max messages = DEFAULTdeadlock pipe active = DEFAULTdeadlock pipe max messages = DEFAULTwait event timing = DEFAULTprocess wait events = DEFAULTobject lockwait timing = DEFAULTSQL ba96、tch capture = DEFAULTstatement statistics active = DEFAULTper object statistics active = DEFAULTmax SQL text monitored = DEFAULTperformance monitoring option = DEFAULT5.2增加Sybase的內存使用a. 系統(tǒng)目前配了48GB內存，目前sybase指定使用的是40GB，可將該值增至46GBb. 移兩塊F6800的1.2Ghz的Ultra Sparc III 系統(tǒng)板到F6900的B分區(qū)做應用服務器，將F6900B分區(qū)的一塊1.8Ghz的Ultra Sparc IV 系統(tǒng)板移到F6900A分區(qū)。這樣F6900B分區(qū)的操作系統(tǒng)及應用在不重安裝的情況下是能正常運行請Sun廠家技術確認。5.3 Sybase存儲碎片的處理如可行，可重建全部庫表和索引進行測試。6、系統(tǒng)升級建議根據(jù)應用特點，對用戶升級系統(tǒng)的幾點建議1、 主機內存配置應較高，數(shù)據(jù)庫使用內存應在100GB以上為宜2、 存儲陣列需選性能卓越的高端產(chǎn)品3、 存儲陣列的配置參數(shù)應對數(shù)據(jù)庫進行優(yōu)選。4、 數(shù)據(jù)庫宜使用裸設備5、 數(shù)據(jù)庫若使用文件系統(tǒng)，其文件系統(tǒng)宜針對數(shù)據(jù)庫優(yōu)化6、 數(shù)據(jù)庫的日志、零時表空間、系統(tǒng)表空間（設備），庫表宜分散存儲。