To check the MAX Worker Thread value

To check the MAX Worker Thread value
select max_workers_count from sys.dm_os_sys_info
to configure worker thread
USE master;
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE ;
GO
EXEC sp_configure 'max worker threads', 2048 ;
GO
RECONFIGURE;
GO