Questions tagged [dm-exec-sessions]
The dm-exec-sessions tag has no summary.
4 questions
4 votes
1 answer
724 views
What are the ramifications of long open sessions?
I'm looking after a SQL server having long open sessions. There is no open transaction, or actively running query (requests) for this session. What is the reason why a session may remain open? Is it ...
- 3,602
1 vote
2 answers
1k views
stored procedure runs fine in all sessions but one
There are procedures that run fine manually but not in a job, or fails when run from an application, or not work in SSIS SQL task Mine works in all sessions but one. this is the code I am running - it ...
- 17.3k
5 votes
1 answer
354 views
How does one map the client_version value (from sys.dm_exec_sessions) to TDS Version?
From Microsoft's SQL Server documentation of sys.dm_exec_sessions client_interface_name Name of library/driver being used by the client to communicate with the server. datatype: nvarchar(32) ...
- 579
2 votes
2 answers
10k views
how to find the T-SQL of a sleeping session that is blocking some other process?
I have a stored procedure called sp_radhe that I put on my servers and it has been helping me to "see" what is happening internally. here is the code of this stored procedure: USE [master] ...
- 17.3k