We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [resource-governor]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
1answer
828 views

Using Resource Governor with SQL Agent Jobs

I'm trying to setup Resource Governor for limiting IOPS for processes running using SQL agent jobs. The classifier function is set to identify a particular login (any spid that is running using that ...
3
votes
1answer
864 views

Run SQL Server agent job in a particular resource governor pool

I read Considerations for Writing a Classifier Function on MSDN. The only way I see possible is to create a separate user account for each resource governor pool and to classify sessions based on that ...