SQL Server - What is C:\Windows\SYSMSI\SSEE directory?

Hi All,
I have inherited  an SBS2011 server that is running Microsoft Exchange 2010, AD, IIS. It is also running SQL Server that points to a database directory of C:\Windows\SYSMSI\SSEE.

Can anyone tell me what that directory is used for? and if SQL is required for SBS2011, Exchange 2010 or IIS. I don't believe so, but want to check.

The SQL server services says its a "Windows Internal Database(MICROSOFT ##SSEE) so I'm trying to figure out if its still needed or if I can shut it down.
LVL 2
ChiITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
This is the builtin database for WSUS.

Look at the administrative tools for windows server update services interface to manage

IIS will also have a site or a virtual directory within the default website depending on the selected options.

Look at your GPMC to see whether you have GPO/GPP that direct systems to contact the SBS server for windows updates.

c:\program files\update services\tools\wsusutil.exe is the tool if you need to repair/relocate the downloaded packages to a different location if it causes a drive to run out of space.
0
Chris MConsulting - Technology ServicesCommented:
Hi ChilT,
The location "C:\Windows\SYSMSI\SSEE" is not a database but a folder for Microsoft SQL server database usually for any server that has it's Windows Internal database enabled (hence the MICROSOFT##SSEE instance) or WSUS or SBS.

You certainly need it for your SBS2011 to run smoothly.
If you can, get a DBA to optimise your database.

If you want to move your DB to another location - perhaps to save space on C drive, you can do that with a good DBA to move all your production datafiles to another mount point.

All the best.
0
Chris MConsulting - Technology ServicesCommented:
It's best that you do not shut it down please, thanks.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Chris MConsulting - Technology ServicesCommented:
0
ChiITAuthor Commented:
Thanks everyone, a lot of info to digest. The reason it came up was I was looking at utilization of memory and it was chewing up a lot, not knowing of any SQL services on this machine I thought it might be able to be shut down.

I don't use WSUS for servers or workstations on this network, so not sure if that matters.

I noticed there was some reference to IIS as well in one of the posts, which is running and active on this server.

It's not a disk space issue, rather an issue regarding memory utilization. The only issue on disk I can see is that it is on C, which is the same running the operating system, etc, so not so much space but rather disk access.

There are error logs associated with it that seem to be filled with entries, I'll see if I can connect to it to see what's going on.
0
ChiITAuthor Commented:
Thank you Pastorchris
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.