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.
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 respondingWhat 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! |
|
|
|
|
|