Open an Administrative Command Prompt.
Type:
osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Now at the SQL prompt, type:
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
The screen displays:
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Type:
1> sp_configure 'max server memory', 512
2> go
(NB The RAM usage of 512Mb is a suggestion, use whatever is appropriate in your environment.)
The screen displays:
Configuration option 'max server memory (MB)' changed from 2147483647 to 512. Run the RECONFIGURE statement to install.
Type:
1> exit
Restart the service, or reboot the server. The database instance may be opened in the management applet using the above notation.
hats of for you Daniel B.
ReplyDeletesuch a good, short, and comprehensive description of using high memory..
keep it up
Thank you, Alicia
ReplyDeleteThanks! - Worked like a Charm
ReplyDelete- SPN
Glad to hear it!
ReplyDeleteGreat Man, good solution.
ReplyDeleteThis worked for me too. Thanks Daniel
ReplyDeleteIf sqlservr.exe is using huge amount of memory there is a reason behind. Forcing it to use less memory doesn't solve the problem.
ReplyDeleteYou should check files in C:\WSUS\SUSDB\UpdateServicesDbFiles as they are probably huge.
Wow, so simple, yet so effective
ReplyDeleteKudos
but i have 2 sql proccess. one of them is x32. it solved only in one proccess. how can i change the ather one?
ReplyDeleteit's sbs server 2008