SQL Server Performance Forum – Threads Archive

set working set size option

If this option is set to 1, is it possible that a SQL Server 2000 will allocate more than 2GB for its use in a Windows 2003 server which has 4GB RAM?

---

What SQL do you have? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

BOL defines:
Use the set working set size option to reserve physical memory space for Microsoft® SQL Server™ that is equal to the server memory setting. The server memory setting is configured automatically by SQL Server based on workload and available resources. Do not set set working set size if you are allowing SQL Server to use memory dynamically. Also refer to this relevant topichttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6299#28798 in this forum. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

SQL Server 2000 Standard Edition.

---

With Standard Edition, you can reach up to 2Gb.
You need Enterprise Edition to reach more. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

If you’re managing the memory dynamically then leave as it is and to take advantage of more memory may upgrade as suggested by Luis. Standard edition restriction is 2GB only. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>