I am seeing the below error within the SQL logs on a server with 8 CPU cores.
Currently the max worker thread value is set to default.
There is a single Availability group with 200 Databases that are part of the AG.
Please advise what is the best value that we can set for the "Max worker thread" to resolve the issue.
Error message:
The thread pool for AlwaysOn Availability Groups was unable to start a new worker thread because there are not enough available worker threads. This may degrade AlwaysOn Availability Groups performance. Use the "max worker threads" configuration option to increase number of allowable threads.