asked
Disconnects after idle time
SQL server 2012 is disconnecting after about thirty minutes of idle time. For instance go out to lunch and come back everything is disconnected.
There is no idle connection timeout in SQL Server itself. But, you could have throttling enabled which could lead to connection timeouts. You could have auto_close enabled on the databases which could cause connection loss. Otherwise, I'd focus on what the clients are doing. Is the machine going into sleep mode? It's unlikely to answer any keepalive ping from the server at that point, so it'll be disconnected, but appropriately so.
I'd suspect something at the client then. Anything that isolated is very seldom a systemic problem.
the auto close is off. What is throttling or where is that so i can check that.
I said throttling because I've been working too much with Azure lately. I meant Resource Governor. Check that.
16 People are following this question.
