Link to home
Start Free TrialLog in
Avatar of bitplus
bitplusFlag for Netherlands

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?
ASKER CERTIFIED SOLUTION
Avatar of Olaf De Ceuster
Olaf De Ceuster
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of joshgeake
joshgeake

Yes those memory values seem normal...although I know myself it's a pain how much memory it takes up.

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.
Avatar of Glen Knight
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.