示例 下面的示例说明了如何启用 AWE 并为服务器内存最大值选项配置 6 GB 的限制： sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GO sp_configure 'max server memory', 6144 RECONFIGURE GO
SQL Server 2000 Enterprise 和 SQL Server 2000 Developer Edition 都可以使用下列选项： • 如果在 SQL Server 中使用 Boot.ini 的 /PAE 开关和“启用 AWE”选项，SQL Server 2000 就可以使用 4 GB 以上的内存。没有 /PAE 开关，SQL Server 最多只能使用 3 GB 的内存。注意：在 Windows 2000 Data Center 上，要使 AWE 可以使用 16 GB 以上的内存，请确保在 Boot.ini 文件中没有使用 /3GB 开关。如果在 Boot.ini 文件中使用了 /3GB 开关，Windows 2000 可能无法正常提供任何 16 GB 以上的内存。在 32 GB 系统上分配 SQL Server AWE 内存时，Windows 2000 可能至少需要 1 GB 的内存来管理 AWE。
转贴一个FAQ：We have a server that we want to run SQL Server on. It has 4GB of RAM. Our dilemma is that we want to use all of the RAM for SQL Server, but the SQL Server 2000 Standard Edition will only use 2GB of it, and we don't want to pay for the extra cost of the SQL Server 2000 Enterprise Edition. What if we run two instances of SQL Server 2000 Standard Edition on the server? What are the pros and cons? AnswerIf you decide to run two instances of SQL Server Standard Edition on your server (in order to be able to take advantage of the 4GB of RAM in your server, you need to keep the following in mind: You will need to pay for two SQL Server Standard Edition licenses. The list price for this is (based on per process pricing), is $9,998 (for two licenses for a one processor server). While expensive, it is still less than the cost of one SQL Server Enterprise Edition license, which has a list price of $19,999 (per processor). You save 50%.Since you will be running two instances of SQL Server, more of the available RAM will be allocated to overhead as you have two copies of the code in RAM, not just one. This means you won't be able to take advantage of the full benefits of having 4GB of RAM in your server. On the other hand, the overhead is not that much, relatively speaking. And if your databases aren't huge, then the loss of RAM due to the extra overhead probably won't be noticed. On the other hand, if your database or databases you want to run are very large, then you may see a performance hit due to the overhead of the second instance of SQL Server.Similar to the above, running two instances of SQL Server will require more CPU overhead than one instance, although not a huge amount more. Again, if your databases are small, or not too busy, this won't be a problem.Administrating two instances of SQL Server over one instance will require a little bit more administrative work, but not much.While the Enterprise Edition costs more, it does provide features not available with the Standard Edition, such as full use of indexes views, log shipping, larger memory support, and clustering. If you need any of these features, then you have to get the Enterprise Edition.
下面的示例说明了如何启用 AWE 并为服务器内存最大值选项配置 6 GB 的限制： sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
• 如果在 SQL Server 中使用 Boot.ini 的 /PAE 开关和“启用 AWE”选项，SQL Server 2000 就可以使用 4 GB 以上的内存。没有 /PAE 开关，SQL Server 最多只能使用 3 GB 的内存。注意：在 Windows 2000 Data Center 上，要使 AWE 可以使用 16 GB 以上的内存，请确保在 Boot.ini 文件中没有使用 /3GB 开关。如果在 Boot.ini 文件中使用了 /3GB 开关，Windows 2000 可能无法正常提供任何 16 GB 以上的内存。在 32 GB 系统上分配 SQL Server AWE 内存时，Windows 2000 可能至少需要 1 GB 的内存来管理 AWE。
2、我就是没有看懂微软说的"/3GB","awe","pae"这三个开关的组合使用，大哥能否说一下呢？