SBS2011 SQL Express / WSUS issues

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.
LVL 10
Schuyler DorseyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Schuyler DorseyAuthor Commented:
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
Schuyler DorseyAuthor Commented:
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
Larry Struckmeyer MVPCommented:
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
Cris HannaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.