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