Monday, February 20, 2012

Memory management

I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
of the 4 gb installed in the server. How do I reduce the amount of memory
SQL is using?
MBSSet the MAx Memory setting to the amount you want minus about 300MB and you
should be all set. You can do this via sp_configure or ssms.
Andrew J. Kelly SQL MVP
"MBS" <who@.nowhere.com> wrote in message
news:H8CdnbIX_t1gHsvYnZ2dnUVZ_uednZ2d@.su
scom.com...
>I am running MS sql 2005 workgroup on a SBS 2003 - R2 server. The only
>databases are Sharepoint and Small Business Monitor. SQL is using over 3 gb
>of the 4 gb installed in the server. How do I reduce the amount of memory
>SQL is using?
> MBS
>

No comments:

Post a Comment