What are the ramifications of long open sessions?

4 votes

1 answer

710 views

                          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?

Asked by variable (3590 rep)

Jan 9, 2024, 12:12 PM
Last activity: Jan 9, 2024, 01:14 PM

What are the ramifications of long open sessions?

Related Questions