SQL Server 2008 R2 "Waiting for Worker Thread" error in Log Shipping.
Dear All, We need some clarification in Logshipping & Hardware Configuration. Could you please help me in this regard. We are using SQL Server 2008 R2 Standard edition installed on 32-bit Windows server 2008 Enterprise edition. The Size of RAM is 16 GB and processor is quad core. The count of database is 240. Please find their details below. **Size of DBs Count of DBs** 0 - 100 MB - 134 nos 100 MB - 1 GB - 72 nos 1 GB - 2 GB - 17 nos 2 GB - 10 GB - 13 nos 10 GB - 20 GB - 4 nos We have configured all the databases for Log shipping. The questions are 1) We are receiving "Waiting for Worker Thread" alert in "Job Activity Monitor" on the all the LS_Backup jobs. 2) whether the above Hardware configuration is enough for 240 databases(used for mid size OLTP Applications). Thanks & Regards, K.P.Senthil Kumar