SBS 2008 Lockups SQL

Posted on 2011-10-18
Last Modified: 2012-05-12
I have SBS 2008 server with 16Gb of ram that I am having issues with lock ups.  It usually locks up when changing USB backup hard drives.  I have noticed that the sbs SQl instance and their SQL instance are taking up large amounts of RAM.  I have tried limiting the amount of memory that SQL uses through command line but after I reboot the server it seems to go back to the way it was. I have done all the recent MS updates too.


Question by:computerconcepts
    LVL 21

    Accepted Solution

    Do you mean the lockups are a usual occurance when ever the USB drives are changed, as in this might be cause and effect, or do you mean it locks up at other times, but more frequently when changing the USB drives?

    Does the OS lock up upon removal, or upon re-attach?  Does it make any difference if the power is applied and on or if you power on after attaching?

    What make and model  of USB drive?  Have you tried using a different USB port?  What events, if any are in the event logs that correspond to the time?  In control panel, right click the drive.  Under policies the drive should be set for quick removal.

    16 GB of RAM, but no information about amounts in use or amounts free.  Frankly, if your RAM never goes over 15,999, you may not have a RAM issue.

    For limiting the amount of RAM for SQL, see this blog post:
    But this should not be the cause of your sudden lockups.

    Author Comment

    The lockups are a usual occurance when the drives are changed.  It seems to when you reattach the drive.  I have tried different ports and that does not seem to make a difference.  I will check the quick removal.  If changing the drive after the server was rebooted recently it does not seem to happen then.  I did not see anything in the event log that corresponds to the lockups.  

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now