469,081 Members | 1,834 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Worker Threads

Everyone,

I have a data warehouse that at the moment includes around 2500
hundred jobs. I am planning for a worst case scenario and would like
to increase the maximum number of sql server threads so that more jobs
can execute simultaneously. Could this pose a problem and if so, at
what number of maximum threads??

Thanks!
Jul 20 '05 #1
1 2516
cl***@dimension2000.com (Clifford Schneider) wrote in message news:<91**************************@posting.google. com>...
Everyone,

I have a data warehouse that at the moment includes around 2500
hundred jobs. I am planning for a worst case scenario and would like
to increase the maximum number of sql server threads so that more jobs
can execute simultaneously. Could this pose a problem and if so, at
what number of maximum threads??

Thanks!


Have a look at this KB article:

http://support.microsoft.com/default...b;en-us;319942

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mark Hoffman | last post: by
7 posts views Thread by Charles Law | last post: by
reply views Thread by Gregory Gadow | last post: by
3 posts views Thread by =?Utf-8?B?Sm9obiBCYWlsZXk=?= | last post: by
7 posts views Thread by csharpula csharp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.