SQLAuthority News – Whitepaper – Using the Resource Governor

Using the Resource Governor
SQL Server Technical Article
Writer: Aaron Bertrand, Boris Baryshnikov
Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe
Published: June 2009

SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.

The Resource Governor is a new feature in the Microsoft SQL Server 2008 Enterprise. It provides very powerful and flexible controls to dictate and monitor how a SQL Server instance behaves in terms of CPU, memory and response time.

This white paper is targeted at IT professionals and database administrators responsible for managing scale, concurrency, high availability, consolidation, virtualization, or service level agreements for the SQL Server instances in their production environments. In this paper you are shown various ways in which you can use the Resource Governor to analyze and streamline the way resources are utilized within your SQL Server instances, by explaining:

  • How the Resource Governor works, including limitations and best practices.
  • Methods for building a consolidation plan, and testing those methods.
  • Techniques for preventing runaway queries, or at least minimizing their impact.
  • Approaches to meeting service level agreements (SLAs) driven by response time and concurrency.
  • Basic ideas about implementing a chargeback system to recover resource costs.
  • Ways to monitor SQL Server using new Resource Governor functionality.

Download Whitepaper Using the Resource Governor

Abstract courtesy : Microsoft

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Documentation, SQL Download, SQL White Papers
Previous Post
SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database
Next Post
SQL SERVER – Get Last Running Query Based on SPID

Related Posts

2 Comments. Leave new

  • Kusum Bhardwaj
    July 27, 2009 4:34 pm

    Hi Penal Dave,

    I usually read your post and always found them real helpful.

    This time also I m in a big problem. but didn’t find any helpful post this time.

    I have installed a new Sql server 2008 enterprise edition.
    At the time of installation I have configured it with mixed mode authentication and was having two logins
    one is my domain user login account.
    I am able to access the integration services using only that
    domain user account.

    Now I have to configure that server on different domain.
    I did it somehow. I am able to access the database engine using sa login.
    my question is how can I access my integration services
    with the new domain user account.

    Is there any way accept new install.
    Any help would be highly appreciated.

    Thanks and Regards,
    Kusum Bhardwaj

  • Zlatko Rusev
    June 30, 2010 1:06 am


    Thanks for good article.

    My question is, is there Resorce Governor in FireBird ?

    Thanks fro answer

    Best regards
    Zlatko Rusev


Leave a Reply