Our SQL Server machine is plugged into a D-Link router along with three other computers on our network. When someone connects to the SQL Server remotely or by accessing ASP pages that execute commands to the SQL Server, the router goes CRAZY. All of the port lights flash on and off. This kills our entire Internet connection, and the only way I've found to bring back up our Internet is to restart the SQL Server machine or by unplugging the CAT cable from the SQL box out of the router. I have to eventually restart the SQL machine if I want to be able to reconnect the SQL machine to the router.
Any ideas on what could be causing this?
Thank you for any help you may be able to provide!
From the limited information provided in your question, I'd be inclined to update all of your service packs (first) and then make sure that the router is good. But that's just a hunch. You'll have to do considerable investigation using Windows Performance Monitor or a third-party tool such as Quest's Spotlight or Idera's Diagnostic Manager. Also, check the SQL Server error logs and Windows Event logs to see what sort of messages may be appearing that are related to your troublesome behavior. Once you've looked for detailed information, it's time to start searching on Google or Microsoft's support site for ways to solve your problem.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.