November 24, 2004 at 1:21 pm
I am wondering if I should check the "Reserve physical memory for SQL Server" (set working set size) option in my sql server. Here is my configuration:
1. Win2k3, SQL Server 2000 Enterprise
2. 8GB memory, configured for dynamic, 0 = min 6144 = max
3. boot.ini contains /PAE (no /3GB switch, we removed it for OS performance reasons)
4. disk is a NAS
5. paging file for OS is 10GB
6. server is dedicated to running SQL Server only
I am wondering what this option will give me. I understand this option is valid only when not using dynamic memory. I also understand that not checking the option will mean that if SQL Server has old memory pages, and some other process, including the OS, needs more memory pages to do something, SQL Server will give up those pages to the requeting service. The OS will swap those SQL Server pages to the paging file so the requesting service can use the memory pages, and then SQL Server will have to swap back in to memory later when those memory pages become available again; conversely, checking the option means that SQL Server will never give up those pages, forcing the requesting service to swap itself instead of SQL Server.
Any advice would be greatly appreciated.
Thanks
November 29, 2004 at 8:00 am
This was removed by the editor as SPAM
March 1, 2005 at 5:52 am
I have ours set with min/max memory and turned on working set = 1. It seems to be good. However, you are exactly right...if you NEED to swap the memory (I don't) for other applications or services, then you need to consider this further.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply