Resource Governor

  • MuhammadSiddiqi

    SSC Veteran

    Points: 202

    Comments posted to this topic are about the item Resource Governor

  • SuperDBA-207096

    SSCrazy Eights

    Points: 8176

    useful info! thanks for the article!

  • Bradley Deem

    SSCrazy

    Points: 2565

    Thanks 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.

  • MuhammadSiddiqi

    SSC Veteran

    Points: 202

    It would only limit the resource when there is competition to acquire resources.

  • Jerry Hung

    SSChampion

    Points: 12908

    Thanks for the thread, I almost finished reading it

    Then I tried to enable my Resource Governor and I got an exception, which explains it

    Now I don't have to finish reading the article 😛 as we won't see Enterprise edition anytime soon

    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

    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'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> 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

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005
  • Nicole Bowman

    SSCommitted

    Points: 1555

    Very well written article! Clear, concise and easy to understand. Thank you.

    Nicole Bowman

    Nothing is forever.

  • Misha_SQL

    SSCertifiable

    Points: 5397

    Thank 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!

  • Anipaul

    SSC-Insane

    Points: 24681

    Nice article with good info....

  • sqlemail@yahoo.com

    SSC Eights!

    Points: 919

    I 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.


    paul

  • Wayne West

    SSC-Insane

    Points: 22586

    When 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.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • kerobin jesu

    SSC-Addicted

    Points: 464

    Pls see the KB article from Microsoft

    http://support.microsoft.com/kb/972200

  • rautelarajeev

    Valued Member

    Points: 71

    Hi,

    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.

  • nadeem0101

    SSC Rookie

    Points: 43

    Hi,

    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.

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply