PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
9 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
High memory usage sqlservr.exe, sqlservr.exe *32
Posted on 2010-11-19
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
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##
You can reenabkle the administrator account in Active Directory Users and Computers.
Hope that helps,
Olaf
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##
You can reenabkle the administrator account in Active Directory Users and Computers.
Hope that helps,
Olaf
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article will help to fix the below error for MS Exchange server 2010
I. Out Of office not working
II. Certificate error "name on the security certificate is invalid or does not match the name of the site"
III. Make Internal URLs and External…
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
In this video we show how to create an Accepted Domain 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 Mail Flow >> Ac…
To show how to create a transport rule 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 Mail Flow >> Rules tab.: To cr…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.