Windows SBS 2003 MICROSOFT##SSEE - Taking up lots of CPU usage and memory

Posted on 2008-11-16
Last Modified: 2012-05-05
Got a Windows SBS 2003 setup. There are 3 SQL services, 2 are absolutely fine, but one of them will start off consuming 250MB of RAM and will increase to over 500 the longer the server has been up. I tracked down the PID to MICROSOFT##SSEE.
This process will occasionally consume 50 - 70% of the CPU for a few minutes. I'm not sure what this particular instance is used for, so input on that first would be great. Also the performance and monitoring snap in, in server management will just crash out. When trying to open up the performance and monitoring snap in, the server will sit there for 5 minutes saying loading and the CPU goes sky high with this sqlservice being the culprit.
Any ideas of how to remedy this will be greatly appreciated.
Question by:bigfoot6
    1 Comment
    LVL 2

    Accepted Solution

    MICROSOFT##SSEE is an instance of Microsoft SQL Server Express Edition.  It is the Free version of Microsot SQL Server that gets installed by default with a lot of applications, like Sharepoint, for example.

    A lot of Microsoft Applications use the Express Edition of SQL Server, without the user ever realizing that SQL server is even necessary for that application.

    So, it might be doing a lot.  You can access that instance of SQL Server just like any other instance using the SQL Server client.  (I think for your version the client is called Enterprise Manager.)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now