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


SBS 2008 Lockups SQL

Posted on 2011-10-18
Medium Priority
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 22

Accepted Solution

Larry Struckmeyer MVP earned 2000 total points
ID: 36996632
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

ID: 37032783
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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
Suggested Courses

571 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