[求助]如何配置sybase12.53服务器
<p>各位大虾:</p><p> 本人现有dell服务器,配置了2个四核CPU,4G内存,安装了windows2003,在上面安装了Sybase 12.53 数据库的服务器端,如何配置Sybase ,使数据库能用到3G内存和发挥CPU的所有功能。</p><p> 急切等待!!!谢谢!!!</p> <p class="MsoNormal" style="TEXT-INDENT: 10.5pt; LINE-HEIGHT: 150%; mso-char-indent-count: 1.0;"><span lang="EN-US">exec sp_configure "max memory",1310720<span style="mso-tab-count: 2;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置数据库可用最大内存</span><chmetcnv unitname="g" sourcevalue="1" hasspace="False" negative="False" numbertype="1" tcsc="0" wst="on"><span lang="EN-US">2.5G</span></chmetcnv><span lang="EN-US"> 2560</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">×</span><span lang="EN-US">512<span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_cacheconfig "default data cache","<chmetcnv unitname="m" sourcevalue="512" hasspace="False" negative="False" numbertype="1" tcsc="0" wst="on">1280M</chmetcnv>"<span style="mso-tab-count: 1;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置缓存中数据库数据大小</span><span lang="EN-US">,<chmetcnv unitname="m" sourcevalue="512" hasspace="False" negative="False" numbertype="1" tcsc="0" wst="on">1256M</chmetcnv><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "procedure cache size", 250000<span style="mso-tab-count: 1;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置缓存中数据库存储过程大小</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "max online engines",2<span style="mso-tab-count: 3;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置</span><span lang="EN-US">Sybase</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">可以利用的</span><span lang="EN-US">CPU</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数目</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of open objects",10000<span style="mso-tab-count: 1;"></span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置可以同时打开的数据库对象</span><span lang="EN-US">
</span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of open indexes",5000<span style="mso-tab-count: 1;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置可以同时打开的索引</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of devices",30<span style="mso-tab-count: 2;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置可用的数据库设备数量</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of large i/o buffers",32<span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of user connections",200--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置用户连接数</span><span lang="EN-US">,</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">根据实际情况设备</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of open databases",30<span style="mso-tab-count: 1;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置可以同时打开的数据库数量</span><span lang="EN-US"><span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of aux scan descriptors",10000<span style="mso-spacerun: yes;"> </span></span></p><p class="MsoNormal" style="LINE-HEIGHT: 150%;"><span lang="EN-US"><span style="mso-spacerun: yes;"> </span>exec sp_configure "number of locks",30000<span style="mso-tab-count: 2;"> </span>--</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">配置锁</span></p> 还要打开windows2003的 /PAE
页:
[1]