November 8, 2002 at 10:32 am
Here we go again! We have a Sql 7, mdac 2.5, server that is generally in good health. But for the last two days we have received several "08S01:[Microsoft][ODBC Sql Server Driver]Communication link failure" messages at random times. Somedays we are hit hard; other days we don't see the message at all. (The message appears on the client trying to talk to the Sql 7 box.)
Any ideas how to track this problem down much appreciated.
Bill
November 8, 2002 at 10:53 am
Strange... I was just going to post the same question/problem with a SQL 2000 server we're running.
I get the errors when trying to change column properties through EM. If I issue an alter command from QA, it works fine.
November 8, 2002 at 11:02 am
Sometimes you'll see these as a result of a failure in a component, in which case you'll see the debug results in the SQL Server logs.
Other times it's because something is going on with your network that's causing the connection to drop. From the SQL Server side, when this activity starts to get hot and heavy, you may fire up profiler (probably need to do so on the server and watch for Error and Warning events to see if they precede a Logout.
If that doesn't resolve it, you may need to have your network engineers start looking at the traffic to see why these connections are suddenly being dropped.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 8, 2002 at 12:04 pm
We used to get this error whenever one of the clusters goes down(in the cluster environment with physical load balancing ).Once we fail it over then the error used to disapper automtically.So what I suspect is the network issue.
November 8, 2002 at 12:16 pm
a little more info...
I can issue an alter statement from QA and from DBartisan (Embarcadero) and everything works fine.
Why is the issue only from Enterprise Manager? I even get the error when making the change using the local install of EM. Wouldn't this rule out a network issue?
We re-installed MDAC 2.6.1, and no improvement.
November 8, 2002 at 1:54 pm
If you are getting the error even on the local install, it sounds like something is crashing and taking out the session. In the SQL Server logs, are there any readouts which appear to be crash dumps?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply