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!

cliff@dimension2000.com (Clifford Schneider) wrote in message news:<91388d57.0311130838.38a3553f@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