Server hang when connecting to Internet

It seems ever once in a while my server just hangs and doesn;t let anyone on my network connect to the internet. Before yesterday everything was working, however when I came in this morning no one in the network could connect to the Internet. I went on the server and tried myself to launch a browser to see if I could get on. It would just "hang" and take forever and never would allow me to load a page.

I did notice in my process screen that my .SQL was running really high and so too was the store (see attached screen shot 2.png) It seems that both process are running high.

To resolve the problem I rebooted the server and everything seems to be fine now. However I really would like a little more diagnose steps to determine the issue

Thanks in advance.
screen-shot-2.png
cmdolcetAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

IanThCommented:
did you get anything in event viewer it will still be there even after the reboot
akhalighiCommented:
If some processes consume your server resources ; then server doesn't respond to requests and will discard requests. Did you limit database resource usage in your SQL server ? it will eat up memory as much as it can if you don't put a limit.
ITguy565Commented:
Please try the following:

1. Check your proxy settings under Internet explorer

You can do this by :

Start -> Control Panel -> Internet Options -> Connections -> Lan Settings
Check if the Use a proxy has a check in it.

2. Open a command prompt and ping www.google.com
Server 2008 SBS : Start -> Search -> Command Prompt -> ping www.google.com -t
Server 2003 SBS : Start -> Run -> type "cmd" -> ping www.google.com -t

Let us know the results.
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

ITguy565Commented:
cmdolcet

Here is a good article to diagnose SQL performance problems:
http://support.microsoft.com/kb/298475

I would also recommend that you use the performance monitor to monitor the SQL processes so you can get a bigger picture of what is happening. Here is a good article for this:
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
WORKS2011Austin Tech CompanyCommented:
1. next time you have slow internet do a nslookup and see if there is a delay resolving site names.  

2. if you're running SBS2008 run dcdiag /test:dns and post the results.

3. on the server run ipconfig /flushdns and try connecting to sites again.

4. on workstations run ipconfig /flushdns then ipconfig /registerdns see if you can access internet faster.

4. check scope options in DHCP, open DHCP expand IPv4, scope and right click on Scope Options verify 003 Router => correct IP, 006 DNS Server => correct IP, 015 DNS Domain Name => domain.local

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
WORKS2011Austin Tech CompanyCommented:
May be a good idea to let us know what SBS you're running. Have you run the connect to internet wizard, doesn't hurt to run this if you're experiencing problems like your explaining. SBS loves the built in wizards.
cmdolcetAuthor Commented:
WORKS2011, just a follow- up with the hung IR connection in our network and on the server. I ran the connect to Internet Wizard and running the wizard did not resolve anything (All it does when IE or any browser is launch is sit and spin, this is the same with the client PC). I did do a ping from the server and the ping (www.yahoo.com) responded.

All I ever do is I restart the server and it seems to fix the issue.

Anymore insight would be helpful

Thanks
IanThCommented:
I have seen this before its normally a registry problem or ie problem you can try installing ie again as it could be corrupted
cmdolcetAuthor Commented:
OK I can try that. But the IE hangs on the server IE and also all Client PC's, so would I need to reload all the client PC's IE also?

It seems everything works again after a reboot
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.