Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4706
  • Last Modified:

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.
0
ChiIT
Asked:
ChiIT
  • 3
  • 2
1 Solution
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now