If you are using SQL funable multiplayer games for pc Server 2000 Standard Edition under Windows.0, Windows 2000 (any version or Windows 2003 (any version or are running SQL Server 2000 Enterprise Edition under the Standard Edition Windows.0, Windows 2000, or Windows 2003, or if your.
Once this step is done, the next step is to set the awe enabled option to 1 within SQL Server 2000 or 2005 Enterprise Edition, and then restart the SQL Server service.But if you are running other software on the server, or are running multiple instances of SQL Server, then you must specify the maximum amount of RAM that SQL Server can grab when it is started.Assuming you have the budget, adding large amounts of RAM to your rs aggarwal quantitative aptitude pdf 2013 server can greatly speed up many databases.GO, sP_configure awe enabled, 1, reconfigure.Details, note: There are multiple files available for this download.Updated 1-2-2004, continues, asuestion).If the operating system is Windows 2000 Advanced Server, SQL Server 2000 Enterprise Edition can us up to 8GB of RAM.Normally, 32-bit CPUs, such as the Pentium family of processors, can only support up to 4GB of RAM because of its limited address space.If your server is a dedicated SQL Server, then this might.For additional information, please refer.
GO sp_configure 'max server memory 6144, reconfigure.
Instead, it takes all of the available RAM (except about 128MB which is left for the operating system).
Reconfigure, gO sp_configure 'max server memory 6144, reconfigure, gO).If you dont specify this option, then SQL Server will only take advantage of 2GB of the first 4GB of RAM in the server, essentially wasting 1GB of RAM.If your server has 16GB or less of RAM, then using the /3GB switch is important.How much RAM SQL Server 2000 or SQL Server 2005 Enterprise Edition can use depends on which version of Windows 2000 or Windows 2003 you are using and how much RAM your server can support.While multiple instances of SQL Server can be used with AWE memory, you probably wont want to, as it can be a headache to manage.Sp_configure 'show advanced options 1, reconfigure, gO sp_configure 'awe enabled.If the operating system is Windows 2000 Datacenter Server, SQL Server 2000 Enterprise can use up to 64GB of RAM.
For example, to turn on AWE support: SP_configure show advanced options, 1, reconfigure.