Avatar of KTBerwick
KTBerwick
Flag for Afghanistan asked on

SBS 2011 - SQL Server

Hi Experts.

Running a machine with SBS 2011 and using Exchange. We do not use SQL Server for anything but have noticed it takes up nearly 2GB of memory at all times. For performance reasons we would like to simply disable the service. Will this cause any problems? Does anything depend on SQL to work?

In SQL Server configuration manager the only service running is "Windows Internal Database (Microsoft##ssee)" on SQL Server 2005. Any idea what this does?


Many thanks.
SBSMicrosoft SQL Server

Avatar of undefined
Last Comment
KTBerwick

8/22/2022 - Mon
Raja Jegan R

No, don't turn off Windows Internal database as there are chances that SBS might be using it.
By default, Windows Internal database or SQL Server will reserve few memory for better performance. So, it would have reserved 2 GB of memory for better performance.

It should not be harmful until it impacts other services running on that server.
If you want to reduce the memory occupied by Windows Internal database, then we can configure Max Server Memory using the script given below where 2048 refers to 2048 MB ie., 2 GB

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 2048;
GO
RECONFIGURE;
GO
sognoct

you can reduce the usage of memory of SQL Express 2008.
Open the SQL Management studio as an administrator. Connect to each instance. Right mouse click on server and select memory. Set max memory to a smaller value.
ASKER CERTIFIED SOLUTION
ronnypot

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
KTBerwick

ASKER
That makes a lot of sense, ronnypot. I will leave things as they are.

We have 14GB of RAM installed and 6 main users all with active directory and redirected folders. OWA and Remote Desktop Services are used. It also runs DNS/DHCP for 10-20 machines at any given point and is used as a file server for backups etc.

We don't have any major performance issues but at times it does feel like things should be faster. Do you think more RAM be worthwhile?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ronnypot

In my opinion, for the configuration you describe 14GB would do fine.

You say you feel things should be faster, is this with a specific operation or program or do you have this feeling random>?
KTBerwick

ASKER
Just in general really but file transfer speeds and DNS lookup are normally the worst. Probably caused by impatience more than anything so I wouldn't worry about it. I just seen SQL taking up so much memory and wondered why since we don't use it.

Thanks for all the help.