Solved

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

Posted on 2010-11-19
4
2,141 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 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Find out what you should include to make the best professional email signature for your organization.
In this video we show how to create a Contact in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Contact ta…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

808 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