Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Resource Governor on SQL Agent Job

Author  Topic 

benking9987
Posting Yak Master

124 Posts

Posted - 2014-07-16 : 16:16:07
Hello:

im 100% new to the Resource Governor, but I have a rogue SQL Agent job that performs a vital task, but it is very expensive in terms of CPU usage. Im wondering if I can just max out the CPU usage availalb to that specific process using the resource governor.

again, Im at ground level on this conceptually. I do have the governor in my SQL instance and it is enabled. But thats about as far as Ive gotten.

Any help would be great.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-16 : 17:30:28
You will have to find out under which security context and account the vital task is performed.
Then you add that account to the function used for RG.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-07-22 : 06:57:12
If you download the Resource Governor white paper from here: http://technet.microsoft.com/en-us/library/ee151608%28v=sql.100%29.aspx

They discuss a technique to identify specific jobs within the classifier function, and set their pool accordingly. They also give a great deal of background on how to optimize and what to avoid when using Resource Governor.
Go to Top of Page
   

- Advertisement -