SQLServerCentral.com / Article Discussions / Article Discussions by Author / Discuss content posted by Muhammad Shujaat Siddiqi / Resource Governor / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 16:54:39 GMT20RE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxHi,I have a requirement to set the resource governor to utilize the resources for 90%. I am new to this and need an urgent help how to configure via SSMS.Wed, 17 Aug 2011 10:41:06 GMTnadeem0101RE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxHi, I need some advice on SQL 2008 server, We have 2 different applications and have 2 databases, and have one Windows Physical server at primary site. Is it better to have 2 instances and then one D/B per instance or is it better to have one instance with 2 D/B's on it. We also need to take reglular backup and both DB's wil be connected to SAN as well. and for failover we have a secondary site where another physical server would be deployed both D/B's wouldbe in passive mode and maintained through MSCS. So, With the help of Resource Governer, 1) can the hardware resource be dedicated to a database, if I have Two Instances on Single server with one database per instance?2) can the hardware resource be dedicated to a database, if I have Single Instance with two databases?Please reply soon.Fri, 14 Jan 2011 05:20:58 GMTrautelarajeevRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxPls see the KB article from Microsofthttp://support.microsoft.com/kb/972200Wed, 27 Oct 2010 04:03:51 GMTkerobin jesuRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxWhen you create your classifier code, can you assign pools according to database? We're looking at copying our ERP database to a different server for reporting purposes and, since "Joe/Jane User" can report from this, I'm anticipating some really lousy queries written against it. Limiting their ability to eat the server could be a very desirable thing.Wed, 25 Aug 2010 17:44:24 GMTWayne WestRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxI found the article little wordy (nice article though), wish you could add some pictures (may be visio diagrams) explaining some of the things described, which would have made the reading little more easier.Mon, 13 Oct 2008 12:33:19 GMTsqlemail@yahoo.comRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxNice article with good info....Sun, 21 Sep 2008 23:11:24 GMTAnipaulRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxThank you for the article. This is a long overdue great new feature. One instance I can immediately think of where it would be useful is when users need access to query production server. Bad practice? I know! But we all live in a real world. Throttling down their queries using resource governor approach described in the article would be a great safeguard to have!Sun, 21 Sep 2008 08:48:48 GMTMisha_SQLRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxVery well written article! Clear, concise and easy to understand. Thank you.Thu, 18 Sep 2008 14:54:04 GMTNicole BowmanRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxThanks for the thread, I almost finished reading itThen I tried to enable my Resource Governor and I got an exception, which explains itNow I don't have to finish reading the article :P as we won't see Enterprise edition anytime soonThe resource governor is not available in this edition of SQL Server. You can manipulate resource governor metadata but you will not be able to apply resource governor configuration. [b]Only Enterprise edition of SQL Server supports resource[/b][quote]See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************Microsoft.SqlServer.Management.Smo.FailedOperationException: Alter failed for ResourceGovernor 'Microsoft.SqlServer.Management.Smo.ObjectKeyBase'. ---&gt; Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---&gt; System.Data.SqlClient.SqlException: 'ALTER RESOURCE GOVERNOR RECONFIGURE' failed. The resource governor is not available in this edition of SQL Server. You can manipulate resource governor metadata but you will not be able to apply resource governor configuration. Only Enterprise edition of SQL Server supports resource governor. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Bo[/quote]Thu, 18 Sep 2008 09:52:36 GMTJerry HungRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxIt would only limit the resource when there is competition to acquire resources.Thu, 18 Sep 2008 09:27:45 GMTMuhammadSiddiqiRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxThanks for the article.I have question about the Effective Max %. Assume we have no workload in PoolA, PoolB, and PoolC. Can the Default pool get 100% reources or will it be limited to an Effective Max of 25% regardless? In otherwords, can the behavior be as follows. Give the Default pool 100% resources until a workload comes along from PoolA, PoolB, and/or PoolC and then reduce the Default's resources.Thu, 18 Sep 2008 08:10:20 GMTBradley DeemRE: Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxuseful info! thanks for the article!Thu, 18 Sep 2008 07:02:42 GMTSuperDBA-207096Resource Governorhttp://www.sqlservercentral.com/Forums/Topic571445-1386-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Resource+Governor/64034/">Resource Governor</A>[/B]Wed, 17 Sep 2008 21:26:16 GMTMuhammadSiddiqi