Thursday, April 9, 2009

SQLSERVR Eating Memory on SBS

FIX:

GET PID from tasklist /svc from CMD
IE. sqlservr.exe 1400 MSSQL$SQLEXPRESS

RUN FROM CMD: osql -E -S SERVERNAME\sbsmonitoring

your server name needs to be in caps or it will not work
it will respond with a number 1 ready for your commands

AT 1 type: sp_configure 'show advanced options',1
it will respond with a 2

AT 2 type: reconfigure with override
it will respond with a 3

AT 3 type : go
it will respond with:
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
AT 1 type : sp_configure 'max server memory',100
it will respond with 2

AT 2 type : reconfigure with override
it will respond with 2

AT 3 type : go
it will respond with:
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 100.
Run the RECONFIGURE statement to install.
AT 1 type : quit


this will reset your max mem to 100MB

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
Web Design & Marketing - Click and get an instant quote on your project