Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

High memory usage sqlservr.exe, sqlservr.exe *32

Posted on 2010-11-19
4
Medium Priority
?
2,168 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:bitplus
4 Comments
 
LVL 22

Accepted Solution

by:
Olaf De Ceuster earned 2000 total points
ID: 34172358
Those value are quite reasonable.
If you want to tweak them down just use the sql server Management studio express console, open the the sql instance you want to tweak, right click on it, open Memory and set upper value.
Foe MSSQL instance open: \\.\pipe\mssql$microsoft##ssee\sql\query as the original aministrator (not the one sbs made at installation time) and change values.
You can reenabkle the administrator account in Active Directory Users and Computers.
Hope that helps,
Olaf
0
 
LVL 2

Expert Comment

by:joshgeake
ID: 34172407
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.
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 34877673
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.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
This video discusses moving either the default database or any database to a new volume.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question