?
Solved

SBS2011 SQL Express / WSUS issues

Posted on 2013-01-08
4
Medium Priority
?
724 Views
Last Modified: 2013-02-06
I have an SBS 2011 box with issues seeming to revolve around WSUS or SQL. If I try to access the WSUS page from the SBS console or the WSUS mmc, it crashes every time. I also discovered that if I try to open SQL mgmt studio, it goes VERY slowly. I should also note that when this WSUS issue started, the entire box has been plagued with VERY slow performance.

This is in a virtual environment and the SBS box has plenty of resources (8 vCPUs and 12gb of ram). I am perfectly okay getting rid of WSUS from SBS if that won't break anything in SBS as I have already setup another WSUS box since this one stopped working.
0
Comment
Question by:Schuyler Dorsey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Author Comment

by:Schuyler Dorsey
ID: 38756759
As far as the performance, the disk IOPs seem to be the culpit. CPU is sitting at 0-10%, memory at 9/12 gb but the avg. disk sec/write and read are spiking a LOT in perfmon.
0
 
LVL 10

Author Comment

by:Schuyler Dorsey
ID: 38756764
I stopped the WSUS and Windows Internal DB services. They did not help the disk read/write. I am not seeing errors in event viewer.
0
 
LVL 22

Expert Comment

by:Larry Struckmeyer MVP
ID: 38758359
12 GB RAM and SATA drives could cause the high disk i/o, but you can check it with perfmon.  Since you know WSUS is not the issue, would be worth a check.  If you can spare a few hours without Exchange, stop all those services and see if things improve.  As you no doubt know, Exchange will use as much RAM as it can get, and I have seen systems with 12 GB RAM max out more than I like.

If there is avialble RAM in the parent, try pushing the SBS to 16.

As for the issues with WSUS on the SBS, you can just stop those services also.  If you want to get the console, and WSUS working again I think you should solve the RAM/slowness issues then work on WSUS.
0
 
LVL 35

Accepted Solution

by:
Cris Hanna earned 2000 total points
ID: 38759030
Agree with  fl_flyfishing,  Depending on what your users are doing on the system 12GB on VM may not be enough.  When looking at Perfmon, you should also be looking at Paging http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1687
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 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