Worker Threads

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Clifford Schneider
    #1

    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!
    Tags: None
    • Simon Hayes
      #2
      Re: Worker Threads

      cliff@dimension 2000.com (Clifford Schneider) wrote in message news:<91388d57. 0311130838.38a3 553f@posting.go ogle.com>...[color=blue]
      > 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![/color]

      Have a look at this KB article:

      Error - Office.com
      http://support.microsoft.com/default.aspx?scid=kb;en-us;319942


      Simon

        Comment

        Previous template Next
        Working...