SQL SERVER – Map SQL Server Session ID to OS Thread ID

During the recent Comprehensive Database Performance Health Check, I had a very interesting conversation with the IT Admin of my client. IT Admin was very familiar with the Windows environment and wanted to track the SQL Session ID as OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.

SQL SERVER - Map SQL Server Session ID to OS Thread ID OSThreadID1-800x245

Of course, there is a script for it. Here is it.

SELECT ost.session_id, osth.os_thread_id  
FROM sys.dm_os_tasks AS ost  
INNER JOIN sys.dm_os_threads AS osth  
	ON ost.worker_address = osth.worker_address  
WHERE ost.session_id IS NOT NULL  
ORDER BY ost.session_id;  
GO

Now you can run the above script and get the mapping of the SQL Session ID with OS Thread ID. You can also open Performance Monitor from your Windows OS and also track the behavior of the ID.

SQL SERVER - Map SQL Server Session ID to OS Thread ID osthreadid

Well, that’s it for today.

Let me know if you are interested to know more about this topic and I will write more blogs as well as create an SQL in Sixty Seconds video.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, , , ,
Previous Post
SQL SERVER – Parallelism and Threads with No Work

Related Posts

Leave a Reply

Menu