June 4, 2007 at 7:37 pm
Hi,
I have SQL Cluster box with SQL server 2000 enterprise edition and SP4.
From the last two days I'm facing this peculiar problem with the jobs. The backup jobs are taking very long time to run and then there are jobs with the status "waiting for worker thread". I stopped the sql server agent and then started it again.But then came the new error ,when I executed a job it said "cannot create a worker thread" and the job failed.
Any help would be greatly appreciated.
June 4, 2007 at 10:15 pm
Max number of worker threads is one of the configuration options in SQL Server. You can configure that in Enterprise manager Server properties or by using sp_confiure.
The typical setting would be 255. You can change the setting. Make sure that this wont disturb the server performance for tiny reason like backup.
The system will not be able to allocate new worker threads when the max number is reached and you are asking the system to do more work.
Its always advisable to take the backup when server activity is at its low.
Harris/
June 5, 2007 at 12:01 am
what is the use of rasing an error in stored procedure,when error should be raised,how should be implemented in sql server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply