Could not set working size to...

[yakker]

Has anyone seen a message/error that comes up in the SQL 7 log and the Applications logs of NT4 server. It doesn't seem to be "too" critical at the moment but I'm not sure what it could mean.
All it says is "Could not set working size" and the a varying number of MB.
thanks

 

[tlbroadbent]

Working Size Set is a SQL Server option. We would get that message in SQL 7 after setting the Working Set Size. The error really didn't seem affect performance or cause any problems. We eventually SET the Working Set Size to 0.

The following info comes from an Article on MSDN.

Use the set working set size option to reserve physical memory space for SQL Server that is equal to the memory setting. The memory setting is automatically configured by SQL Server based on the workload and available resources. It dynamically varies between min server memory and max server memory. Setting the set working set size option means that Windows NT does not swap out SQL Server pages, even if they can be used more readily by another process when SQL Server is idle.

Do not set set working set size if you allow SQL Server to use memory dynamically. Before setting set working set size to 1, set both min server memory and max server memory to the same value, which is the amount of memory you want SQL Server to use. Dynamic memory is a powerful feature in SQL Server 7.0 and it is recommended that you use it in almost all cases.

Recommendation:

Leave set working set size set to 0 to enable SQL Server to dynamically manage the memory allocation.

Reference:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/storageeng.asp

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin