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.
| 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 |
 |
|
|
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.aspxThey 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. |
|
|
|
|
|
|
Resource Governor on SQL Agent Job