March 26, 2014 at 3:35 pm
Hi,
I have a set of processes I want to throttle. Some are started by SQL jobs and some are started by the service broker running an activated procedure. In the resource governor I have created my pool and group ( snapshot_group ), and in the classifier function I assign "snapshot_user" to the group.
The problem is that I cannot force them to execute as this user. The SQL jobs all execute under the same principal associated with the agent and the broker procedure executes as some internal sql thread.
I have set the owner of the jobs to snapshot_user and the "runas" property of the activation procedure to my snapshot_user to no avail.
Is there some other property I could set or check to accomplish this? I know I could probably do this with some custom tables but I don't want to create anything to complex that could make the classifier function take any longer than it needs to.
Thanks
Scott
November 13, 2014 at 11:07 am
Did you ever find a solution for this problem?
November 13, 2014 at 8:55 pm
Not that I recall. Management kicked back on the idea of enabling resource gov so I stopped pursuing it. I'm sure it will come up again though.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply