Thread: Worker Threads
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:47 PM
Clifford Schneider
 
Posts: n/a
Default 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!
Reply With Quote