bitplus
asked on
High memory usage sqlservr.exe, sqlservr.exe *32
I've got a Microsoft Small Business Server 2008 and the SQL Server 2005 with the default SBSMONITORING instance consumes a lot of memory. I've got two sql services:
sqlserv.exe takes about 389Mb;
sqlserv.exe*32 takes about 259Mb.
For the default sbs monitoring i think this is alot of memory!? Is ther a way to decrease the memory size?
sqlserv.exe takes about 389Mb;
sqlserv.exe*32 takes about 259Mb.
For the default sbs monitoring i think this is alot of memory!? Is ther a way to decrease the memory size?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
If you've got a dedicated SQL server I'd take one of the sql servers off (SHAREPOINT).
As @olafdc suggested you can limit the memory usage of the instance by logging in via SQL Management studio and disabling AWE, then tapping in the desired memory limit.