a: Just like with every MSSQL server, you have to set a limit to how much memory it can use, or it will use it all.
C:\Documents and Settings\Administrator>HOSTNAME
SERVER1
C:\Documents and Settings\Administrator>OSQL -E -S SERVER1\SBSMONITORING
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure 'max server memory',100
2> reconfigure with override
3> go
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.
1>
No comments:
Post a Comment