question

artistlover avatar image
artistlover 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.
sql-server-2012
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

what is "everything?" Is it SSMS? Your line-of-business application? Something else? How is your network connectivity? Do you ever see network interruptions during the day?
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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.
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'd suspect something at the client then. Anything that isolated is very seldom a systemic problem.
1 Like 1 ·
the auto close is off. What is throttling or where is that so i can check that.
0 Likes 0 ·
I said throttling because I've been working too much with Azure lately. I meant Resource Governor. Check that.
0 Likes 0 ·
and it is so weird it is just one user with sql server 2012
0 Likes 0 ·
I agree i just have no clue where to start.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.