SQL Server Worker Thread Alert

--Author - Ed Pochinski 04232019
--Purpose - AG Worker thread alert
--SSC posting copy
Declare @availableThreads varchar(25), @workers_waitingForCPU varchar(25), @Request_waiting_ForThread varchar(25),@msgbody varchar(500), @msgsubject varchar(500)
Select @availableThreads = (select  max_workers_count from sys.dm_os_sys_info)-sum(active_Workers_count) from  sys.dm_os_Schedulers where status='VISIBLE ONLINE'
Print @availableThreads
Select @workers_waitingForCPU = sum(runnable_tasks_count) from  sys.dm_os_Schedulers where status='VISIBLE ONLINE'
Print @workers_waitingForCPU
Select @Request_waiting_ForThread = sum(work_queue_count)  from  sys.dm_os_Schedulers where status='VISIBLE ONLINE'
Print @Request_waiting_ForThread
--edit threshold to accomodate this is a test machine with no load so the number is high to facilitate the alert for testing
If @availableThreads <=545 
Begin
Print ' Send a email alert here !!!!! Worker threads are low: ' + @availableThreads + ' Workers Waiting on CPU: ' + @workers_waitingForCPU + ' Requests Waiting for thread: ' + @Request_waiting_ForThread
set @msgbody ='Worker threads are low on Server: ' + @@servername + ' - Available Thread Count: ' + @availableThreads 
set @msgbody = @msgbody + char(13);
set @msgbody = @msgbody + ' Worker Threads Waiting on CPU count: ' + @workers_waitingForCPU + char(10);
set @msgbody = @msgbody + ' Requests Waiting for worker thread count: ' + @Request_waiting_ForThread
set @msgsubject = '!!! AG Worker Thread Alert on SQL Server: ' + @@servername + ' !!!'
EXEC msdb.dbo.sp_send_dbmail
  @profile_name = 'Your_Email_Public_Profile',
  @from_address = 'YourEmail@here.com',
  @recipients= 'YourEmail@here.com',
  @subject= @msgsubject, 
  @body = @msgbody
End