ChiIT
asked on
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.
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.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Below is how to connect to the internal database:
http://blogs.msdn.com/b/sqljourney/archive/2012/04/06/sharepoint-and-the-windows-internal-database-an-interesting-saga.aspx
http://blogs.msdn.com/b/sqljourney/archive/2012/04/06/sharepoint-and-the-windows-internal-database-an-interesting-saga.aspx
ASKER
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.
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.
ASKER
Thank you Pastorchris
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.ex