Use the below statement to get all SQL Server internal task details.
SELECT * FROM sys.dm_exec_sessions
WHERE is_user_process=0
The below statement too seems correct but it does not give all the internal tasks.
SELECT * FROM sys.dm_exec_requests
WHERE status='background'
nice article
ReplyDeletevery useful information.
keep sharing.
best windows server training in Bengaluru