June 24, 2005 at 8:22 am
Hi, I'm running SQL Server 2000 Ent Edition on a Windows 2000 Advanced Server OS. The server itself has 8gb RAM so the boot.ini file has both the /3gb and /PAE switches set. I set sp_configure to AWE Enabled & Set Working Set size enabled. Given I have 8gb memory on this machine I set the min and max server memory to 6gb to allow memory for OS etc..
However at each stop/start of SQL, the Error log shows 'initdata: Warning could not set working set size to 2gb'
There is nothing else running on this box so I'm not sure why I'm getting this error message let alone the fact its trying to set it to 2gb ?? Windows Task Manager shows that there are 6500 committed mb's of memory. SQL Server is running under a domain account with full admin privileges on the server.
Any clues would be much appreciated.....thank-you
June 24, 2005 at 10:48 am
Remove your "Set working set size" configuration option in your setup - it does not work with AWE memory.
In Enterprise Manager, this option is found in:
Right-Click Server
Properties
Memory tab;
Reserve physical memory for SQL Server checkbox
This checkbox should be cleared.
July 5, 2005 at 4:37 am
Thank-you for that...all ok now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply