SQL Server 2008 Resource Governor

CTP5 is out! OK, so maybe you already know that...

Carpe Datum — Mon, 26 Nov 2007 20:13:21 GMT

I got back from vacation ( more here if you want to read about where we go and what we do every other

re: SQL Server 2008 Resource Governor

Aaron Bertrand — Wed, 22 Apr 2009 02:05:28 GMT

I know this post is dated but I just want to clarify a few salient points.

You cannot re-classify (new workload group) a session that is already classified. You also cannot change the classifier function in flight (you need to dis-associate it from the resource governor first). Finally, not all changes take effect immediately (e.g. memory changes will not take effect until the next memory grant request).

re: SQL Server 2008 Resource Governor

Andrew_Fryer — Thu, 23 Apr 2009 14:50:21 GMT

Aaron thanks for the clarification

re: SQL Server 2008 Resource Governor

Liz — Tue, 28 Apr 2009 23:28:44 GMT

What database is the function created in?

re: SQL Server 2008 Resource Governor

Andrew_Fryer — Wed, 29 Apr 2009 19:38:24 GMT

Liz

My aplogies you need to create in the master database!

Normally something I only do by accident becuase I haven't set my conneciton properly watch my webcast on it here..

http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx

Andrew

re: SQL Server 2008 Resource Governor

Timothy — Tue, 02 Jun 2009 22:31:50 GMT

Very nice article! Thank you!

I do have a qustion, though, that I've researched without success so far.

Are we able to route to Workload Groups on the basis of Application Roles? In other words, can Resource Manager manage on the basis of Application Roles?

Many thanks for any help you can provide on this!

re: SQL Server 2008 Resource Governor

Andrew_Fryer — Thu, 04 Jun 2009 11:16:32 GMT

Timothy,

I'm afraid not. All you can use is what's in the connection string. sp_setapprole is run post login so all resource governor will know about is the login used by the applicatio itself.

Andrew