I am seeing User thread count is higher than the max work threads on the server.
Max worker thread is 512
User worker thread count is showing 521.
Can anyone explain why thread is created more than max?. I knew the system related tasks which use the worker thread will not be counted while creating a new worker. I shown only the user process using the below query.
SELECT
r.command,
r.sql_handle,
r.plan_handle,
r.wait_type,
r.wait_resource,
r.wait_time,
r.session_id,
r.blocking_session_id
FROM sys.dm_exec_requests r INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id
WHERE s.is_user_process = 1