November 5, 2003 at 8:49 am
I have a new server with 6 GB of RAM. AWE is enabled, I have the /PAE and /3GB flags set in the boot.ini file. SQL is using only 2.8 GB of RAM. The memory usage is static with the max value allowed by SQL is 5 GB. How can I take advantage of the additional 2 GB? I've read some articles but they are a little confusing. All responses are appreciated.
Terry
Terry
November 5, 2003 at 8:59 am
Sorry, should have also stated that we're running Spotlight and the way I can determine that we're only getting 2.8 GB is we get a buffer cache hit alert on occasion but we never see the amount of memory usage increase. Our database is only 6GB so we thought we sized the new server for optimal performance.
Terry
Terry
November 5, 2003 at 9:05 am
Which version of SQL Server you are running?
To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege.
Edited by - allen_cui on 11/05/2003 09:07:33 AM
November 5, 2003 at 9:16 am
We're running SQL 2K sp3, enterprise edition.
Terry
Terry
November 5, 2003 at 9:24 am
The account did not have the privilege but does now. Our network admin believes the server will require a reboot for this to take affect so once we can get an outage, I'll reboot and respond to this topic. Anything else that may need to be looked at?
Terry
Terry
November 11, 2003 at 11:08 am
We added the priveleges described above. It locked memory reserved for the OS and absolutely killed processing times (some jobs went from 5 minutes to 3+ hours). Am I missing something else?
Terry
Terry
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply