Questions tagged [dm-exec-sessions]
4 questions
5
votes
1 answer
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)
client_version
TDS protocol version of the interface that…
EngineeringSQL
- 579
- 2
- 7
- 16
4
votes
1 answer
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 because a transaction is opened and not…
variable
- 3,590
- 4
- 37
- 100
2
votes
2 answers
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]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER…
Marcello Miorelli
- 17,274
- 53
- 180
- 320
1
vote
2 answers
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 calls a stored procedure that gets the trigger…
Marcello Miorelli
- 17,274
- 53
- 180
- 320