February 24, 2009 at 8:47 am
Hi All,
I am having problems with my production system.
Problem: application keeps stopping or get hung in the logs it says connection to DB has been lost.
Environment is SQL 2K5 sp2
Win 2003 R2
Thanks in advance,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
February 24, 2009 at 9:09 am
The question is a bit vague. But from what I could understand, you have an app that is running that is connected to the DB and is polling for something, or running some queries.
You could check what is happening by using the profiler and find out if was doing something. Maybe the query that it is running is taking too much time and you have a Timeout set somewhere.
Or you are having problems with the network.
Could you provide a bit more details?
-Roy
February 24, 2009 at 9:09 am
Are you seeing errors in the SQL Server logs? Do you have an error number or severity on the client? There are a lot reasons for a disconnect. Without more information it'd be hard to tell you why yours is occuring.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply