How to find maximum number of workers that can be created?


Please execute below code to find maximum number of workers that can be created by SQL Server Instance

SELECT
max_workers_count
from
sys.dm_os_sys_info

Please be advised that this code will return the data on the OS where the particular SQL instance is residing. 

Note: This is tested on SQL 2008 R2 SP2

Comments