Windows SBS 2008 Freezes when starting up.

Our SBS 2008 started freezing on start up and what happens is that when you start up and login, everything freezes but clients can access files and only exchange does not work, everything else does. The server is very slow but after an hour or two unfreezes and things are back to normal. I only have to restart Exchange info store and it works. At first I was thinking that this had something to do with an array we have of SATA drives but it does not. Very unusual. Why would SBS 2008 freeze in that way and still function but the user interface being frozen. Any suggestions? The SBS is installed on 4 months old DL 380, 20 GB ram, SAS drives, enough space, all drives checked work ok, no warning on hardware. Any suggestions would be greatly appreciated as the server became almost useless.
ibozcAsked:
Who is Participating?
 
ibozcConnect With a Mentor Author Commented:
Execute this SQL statement on the DC server

DELETE FROM [SBSMonitoring].[dbo].[WMICollectedData]

this will clear the problematic data. Make sure you know what you do because otherwise you may hava some problems. Make sure you have full backup before you start this. It worked for me  many times and no problems but when you mess with SQL directly, at odd times there could be some problems.
0
 
Abhay PujariCommented:
Have you checked for RAM issues?
0
 
g000seCommented:
Hello ibozc,

Check the event logs and see if that will shine some light for you.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
ibozcAuthor Commented:
Ram issues? Meaning i have enough of it... as for the even log, it gives me some error msgs but it does not state anything related to why the system locks up, no hardware issues at all.. just MAD.exe and LDAP issues but that is related to services not starting up fast enough and no mentiontion of hardware related issues. The system locks up and good luck anything....  the DL 380 would tell me if there is an issue with hardware rather quickly.
0
 
g000seCommented:
Has anything changed recently on your server?  Were there some updates, programs, or drivers you may have installed?
0
 
ibozcAuthor Commented:
Nope... nothing... it used to happand from time to time and now it happands every time.
0
 
Abhay PujariCommented:
If you boot it in safe mode then can you see any processes running at startup using msconfig?
0
 
g000seCommented:
You may have tried this already, try re-seating the RAM on the system board.
0
 
ibozcAuthor Commented:
Mind you that was happening before I placed additional ram... it used to happen once in a blue moon. Would anyone know if there is a way to fix the installation like in the old versions of windows, when you run the setup you have an option to fix previous install.. I don't see that with the new version.
0
 
Abhay PujariCommented:
0
 
ibozcAuthor Commented:
I did find the solution for it and just to share with you guys,  it is very strange one, the SBSMonitoring DB that is installed on the primary server grew over 2 GB making the system so slow, the moment I deleted it, it was back to normal. I found out that it was the SQL express that was taking a lot of HDD resources so from there I found the issue. That is why it became slower over time. Very strange, i know how to monitor and delete the content of it now but I wonder if there is a way to make it delete itself automatically. I know that in full version of SQL there is a way but in express version, it looks very simplified. Very interesting issue. Thank you guys for your efforts.
0
 
ibozcAuthor Commented:
I may add that SBS 2008 is very badly documented and even less support offered from MS.
0
 
g000seCommented:
Thanks for sharing.  I am glad to hear you found out what it was.
0
 
Hyperlite84Commented:
I have the same issue with frozen at appying computer settings.  How did you get to this to delete the SBS monitoring DB?
0
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.

All Courses

From novice to tech pro — start learning today.