Waiting for worker thread
We analysed and found that this is caused due to fact that lot of jobs are running in parallel. There is a maximum number of concurrent job setting known as max_worker_thread and this determines the level of concurrency. Changing this setting will enable you to control number of jobs concurrently executing in SQL Server agent. This is a registry setting. More details on this can be seen in below KB link.
No comments:
Post a Comment