I have noticed that SQL connections are being forcibly closed on one of my database boxes, it is also preventing backups from being completed.
If one connects to the database and leaves the connection on for 30 minutes, in this time the connection would have been closed and if one tries to run the any query in the SQL management studio query console, the following error message is received:
Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
One thing I would say is that last week I changed the startup parameter to add a –g flag to it, as my backups were failing and from m experience with my other databases, increasing the default memory allocation using the –G flag normally cures the problem. There has been no hardware changes of late, and on looking at the Error log, I cant see anything that raises an alarm.
Now, even user connections are being closed after a few minutes, would anyone be able to help here.