- 论坛徽章:
- 0
|
最近我给朋友升级了一台服务器HPML570 G4 装了windows2003 数据库为ASE12.5.3,CPU4个双核3.2G 内存达8G硬盘也升级1w转SAS,为什么我的应用还是不是很快??
我的应用为S/C构架,原来为570G2 2.G的CPU.
配置如下:
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
allow remote access 1 0 1 1 switch dynamic
max concurrently recovered db 0 0 0 0 number dynamic
number of checkpoint tasks 1 0 1 1 number dynamic
print recovery information 0 0 0 0 switch dynamic
recovery interval in minutes 5 0 5 5 minutes dynamic
tape retention in days 0 0 0 0 days dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
extended cache size 0 0 0 0 memory pages(2k) dynamic
global async prefetch limit 10 0 10 10 percent dynamic
global cache partition number 1 0 1 1 number static
memory alignment boundary 2048 0 2048 2048 bytes static
number of index trips 0 0 0 0 number dynamic
number of oam trips 0 0 0 0 number dynamic
total data cache size 0 1311414 0 1311414 kilobytes read-only
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
cis bulk insert array size 50 0 50 50 rows dynamic
cis bulk insert batch size 0 0 0 0 rows dynamic
cis connect timeout 0 0 0 0 seconds dynamic
cis cursor rows 50 0 50 50 number dynamic
cis packet size 512 0 512 512 bytes dynamic
cis rpc handling 0 0 0 0 switch dynamic
enable cis 1 0 1 1 switch static
enable file access 0 0 0 0 switch dynamic
enable full-text search 0 0 0 0 switch dynamic
enable snmp 0 0 0 0 switch dynamic
max cis remote connections 0 788 0 0 number dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
dtm detach timeout period 0 0 0 0 minutes dynamic
dtm lock timeout period 300 0 300 300 seconds dynamic
enable DTM 0 0 0 0 switch static
enable xact coordination 1 0 1 1 switch static
number of dtx participants 500 146 500 500 number dynamic
strict dtm enforcement 0 0 0 0 switch static
txn to pss ratio 16 3658 16 16 number dynamic
xact coordination interval 60 0 60 60 seconds dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
average cap size 200 0 200 200 bytes static
caps per ccb 50 0 50 50 number static
dump on conditions 0 0 0 0 switch dynamic
maximum dump conditions 10 0 10 10 number static
number of ccbs 0 0 0 0 number static
number of dump threads 1 0 1 1 number dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
allow sql server async i/o 1 0 1 1 switch static
disable disk mirroring 1 0 1 1 switch static
disk i/o structures 256 1122 8192 8192 number dynamic
number of devices 10 #42 50 50 number dynamic
number of large i/o buffers 6 3114 6 6 number dynamic
page utilization percent 95 0 95 95 percent dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
event log computer name LocalSystem 0 LocalSystem LocalSystem name dynamic
event logging 1 0 1 1 switch dynamic
log audit logon failure 0 0 0 0 switch dynamic
log audit logon success 0 0 0 0 switch dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
esp execution priority 8 0 8 8 id dynamic
esp execution stacksize 65536 0 65536 65536 bytes static
esp unload dll 0 0 0 0 switch dynamic
start mail session 0 0 0 0 switch dynamic
xp_cmdshell context 1 0 1 1 switch dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
configuration file 0 0 0 d:\sybase\c name dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
enable enterprise java beans 0 0 0 0 switch dynamic
enable java 0 0 0 0 switch static
number of java sockets 0 0 0 0 number dynamic
size of global fixed heap 150 0 150 150 memory pages(2k) dynamic
size of process object heap 1500 0 1500 1500 memory pages(2k) dynamic
size of shared class heap 1536 0 1536 1536 memory pages(2k) dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
default character set id 2 0 1 1 id static
default language id 0 0 0 0 id dynamic
default sortorder id 50 0 50 50 id static
disable character set conversi 0 0 0 0 switch static
enable unicode conversions 0 0 0 0 switch dynamic
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----
deadlock checking period 500 0 500 500 milliseconds dynamic
deadlock retries 5 0 5 5 number dynamic
lock address spinlock ratio 100 0 100 100 ratio static
lock hashtable size 2048 51 2048 2048 bytes static
lock scheme allpages 0 allpages allpages name dynamic
lock spinlock ratio 85 0 85 85 ratio static
lock table spinlock ratio 20 0 20 20 ratio static
lock wait period 2147483647 0 2147483647 2147483647 seconds dynamic
number of locks 5000 798 5000 5000 number dynamic
page lock promotion HWM 200 0 200 200 number dynamic
page lock promotion LWM 200 0 200 200 number dynamic
page lock promotion PCT 100 0 100 100 percent dynamic
print deadlock information 0 0 0 0 switch dynamic
read committed with lock 0 0 0 0 switch dynamic
row lock promotion HWM 200 0 200 200 number dynamic
row lock promotion LWM 200 0 200 200 number dynamic
row lock promotion PCT 100 0 100 100 percent dynamic |
|