Configure Resource Pool for One Big Process job

• sri2015

  SSCrazy

  Points: 2780

  More actions

  February 9, 2016 at 2:22 am

  #399690

  How to configure Resource Governor for One Big Process SQL job in SQL Server 2014 ? this job is utilizing more Server resources due to this server getting slow and impacting on other jobs.

  I know how to configure Resource Governor but I want to configure for only one specific SQL Job.

• sri2015

  SSCrazy

  Points: 2780

  More actions

  February 15, 2016 at 3:35 am

  #1858738

  can anyone answer for my question ?

• Justin Manning SA

  Hall of Fame

  Points: 3190

  More actions

  February 15, 2016 at 5:49 am

  #1858754

  Maybe you could do something like this and throttle a specific user?

  User can be the owner of that specific job?

  http://dbazen.net/2014/02/03/using-resource-governor-to-set-maxdop-for-specific-sql-server-jobs/