4

I'm looking after a SQL server having long open sessions.

There is no open transaction, or actively running query (requests) for this session.

  1. What is the reason why a session may remain open? Is it because a transaction is opened and not closed?

  2. What are the ramifications of having such an open session?

variable
  • 3,590
  • 4
  • 37
  • 100

1 Answers1

7
  1. What is the reason why a session may remain open?

Connection Pooling.

Is it because a transaction is opened and not closed?

There is no open transaction, or actively running query (requests) for this session.

You said yourself there isn't an open transaction. Of course if there was one, the session would still need to be open too.

What are the ramifications of having such an open session?

Not many if the session isn't actually doing anything. The only one I can think of is there's a limit to how many connections the server allows at one time of 32,767 user connections. If for some reason you were at that limit (unlikely) then a new user connection wouldn't be able to be established.

J.D.
  • 40,776
  • 12
  • 62
  • 141