Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 EventId 17055 Could not set working set size

Author  Topic 

Peter.Bij@klm.com
Starting Member

12 Posts

Posted - 2003-06-24 : 04:53:00
After starting SQL Server 7.0 on a NT4 engine a message is found in the eventlog which tells us
17122 :
initdata: Warning: Could not set working set size to 1038784 KB.

When certain SP runs, the server stops responding

What is the matter, who can help

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-06-24 : 05:28:18
How much memory do you have in the box ? How much has SQL been allocated, has it been limited to less than 1 GB?

From BOL :

The Working Set counter shows the amount of memory used by a process. If this number is consistently below the amount of memory SQL Server is configured to use (set by the min server memory and max server memory server options), SQL Server is configured for more memory than it needs. Otherwise, fix the size of the working set using the set working set size server option. For more information, see set working set size Option.

It seesm to me that you are trying to allocate more than is available ...

What SP are you running ?

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -