配置 SQL Server 以便使用 2 GB 以上的物理内存(包括SQL Server 2005)

论坛 › 期权论坛     
选择匿名的用户   2021-5-31 08:44   130   0
<h1 style="MARGIN: 17pt 0cm 16.5pt 21.25pt"><a name="_Toc135475617"><span lang="EN-US" style="mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana"><span style="mso-list: Ignore"><font face="Verdana" size="5">1.</font><span style="FONT: 7pt &#34;Times New Roman&#34;">    </span></span></span><span style="FONT-FAMILY: 黑体; mso-ascii-font-family: Verdana"><font size="5">概要</font></span></a></h1>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">使用</span><span lang="EN-US"><font face="Verdana">Windows 2000 Server </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的操作系统，对于</span><span lang="EN-US"><font face="Verdana">SQL Server</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">而言，需要打开操作系统的</span><span lang="EN-US"><font face="Verdana">3G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">开关，它才能利用到</span><span lang="EN-US"><font face="Verdana">2G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">以上的物理内存，否则这些</span><span lang="EN-US"><font face="Verdana">4G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">以上内存只有</span><span lang="EN-US"><font face="Verdana">2G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">能够被</span><span lang="EN-US"><font face="Verdana">SQL Server</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">使用到。</span><span lang="EN-US"><font face="Verdana"> </font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><span style="mso-spacerun: yes"><font face="Verdana">      </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">如果服务器上的内存高于</span><span lang="EN-US"><font face="Verdana">4G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">，请打开操作系统的</span><span lang="EN-US"><font face="Verdana">/3G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">开关。这样重新启动后，</span><span lang="EN-US"><font face="Verdana">SQL Server</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">将会自动利用大内存来提升数据库的性能，而不再受到</span><span lang="EN-US"><font face="Verdana">2G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的内存使用限制！</span><span lang="EN-US"><font face="Verdana"> </font></span></p>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt"><span lang="EN-US"><span style="mso-spacerun: yes"><font face="Verdana">    </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">使用</span><span lang="EN-US"><font face="Verdana">Windows 2000 Advanced Server</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">、</span><span lang="EN-US"><font face="Verdana">Windows 2000 Datacenter </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">或</span><span lang="EN-US"><font face="Verdana"> Windows Server 2003</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">如果使用</span><span lang="EN-US"><font face="Verdana"> Boot.ini </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的</span><span lang="EN-US"><font face="Verdana"> /PAE </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">开关和</span><span lang="EN-US"><font face="Verdana"> AWE </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">启用选项</span><span lang="EN-US"><font face="Verdana">SQL Server 2000 </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">就可以使用</span><span lang="EN-US"><font face="Verdana">4G</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">以上内存。</span></p>
<h1 style="MARGIN: 17pt 0cm 16.5pt 21.25pt"><a name="_Toc135475618"><span lang="EN-US" style="mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana"><span style="mso-list: Ignore"><font face="Verdana" size="5">2.</font><span style="FONT: 7pt &#34;Times New Roman&#34;">    </span></span></span><span style="FONT-FAMILY: 黑体; mso-ascii-font-family: Verdana"><font size="5">支持的操作系统版本</font></span></a></h1>
<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 60.3pt; TEXT-INDENT: -21pt; mso-list: l1 level1 lfo2; tab-stops: list 60.3
回复
分享到 :
0 人收藏
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

16级独孤
选择匿名的用户

积分:3875789
帖子:775174
精华:0
+ 关注 私信
期权论坛 期权论坛
期权网络科技版权所有
关于我们
联系我们
加入我们
反馈问题
免责声明
积分充值
统一社会信用代码
积分规则
网站地图
爱文库
下属网站
官方
新浪微博
微信公众号
◆
下载
表情包
App下载
期权论坛 期权论坛

QQ咨询|关于我们|Archiver|手机版|小黑屋|( 辽ICP备15012455号-4 ) Powered by 期权论坛 X3.2 © 2001-2016 期权工具网&期权论坛 Inc.

发布
内容

下载期权论坛手机APP