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 systemAT 1 type : sp_configure 'max server memory',100
administrator.
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
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 systemAT 1 type : quit
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 100.
Run the RECONFIGURE statement to install.
this will reset your max mem to 100MB
No comments:
Post a Comment