Process priority in Sql Server

• Pratyus Tripathy

  Right there with Babe

  Points: 780

  More actions

  March 18, 2009 at 1:07 am

  #127168

  Hi All,

  Is there any way to assign a priority to a sql server process? or put another way, is there a way to limit the amount of resources that a process will consume.

  For example is it possible to give more priority to a job requiring more resources compared to low resource consuming processes...

  Thanks,

  Pratyus

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  March 18, 2009 at 4:05 am

  #961677

  I think that SQL 2008 offers a feature (the resource governor) that's close to what you want, see

  http://msdn.microsoft.com/en-us/library/bb895232.aspx