SBS2003 SQLSERVR.exe sucking too much memory

To check exactly WHAT sql instance was being the problem child, to go to a command prompt and type in tasklist /svc

Then go into Task Manager, click on the Processes tab [click on view/select columns options to make sure the PID [process identifier] option is selected and look for the different process IDs to see which process ID is using the memory.

PID 672 is MSSQL$SBSMONITORING

At a command prompt:

osql -E -S YOURSERVERNAME\sbsmonitoring  [hit enter]

[you'll now enter like a command screen]

sp_configure 'show advanced options',1 [hit enter]

reconfigure with override  [hit enter]]

go  [hit enter]

sp_configure 'max server memory',70 [enter the value of the max, in this example its 70]  [hit enter]

reconfigure with override  [hit enter]

go  [hit enter]

which looks like this:

Type Exit then quit the command window

Check the task manager for your rogue sqlservr.exe process which should now be a lot smaller:

And as you can see PID 672 shrunk down, job done!

 

Thanks to The SBS Diva Blog

(back to list)