SQL Server Resource Governor Classification function based on db role membership

Inspired by a question on #SQLHelp on twitter here’s a quick classifier function for resource governor that lets you base the resource group based on the connections db role membership.

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

No comments yet.

Leave a Reply