Search

An option to control Service Broker activation procedures by Resource Governor by Stas Bogachinsky

Active

15
0
Sign in
to vote
Type: Suggestion
ID: 780270
Opened: 2/28/2013 2:06:26 PM
Access Restriction: Public
0
Workaround(s)
Activation procedures are executed by SQL Server system processes and don't have connection properties, so it's impossible to control their resource usage by Resource Governor.
Details (expand)

Product Language

English

Category

SQL Engine

Proposed Solution

In Resource Governor classifier function there should be an option to classify Service Broker activation procedures based on originate database id and/or contract/queue name.

Primary Benefit

Improved Administration

Other Benefits


Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.