SQL Server 2008 - Resource Governor


Right click “Save as…”

SQL Server 2008 introduces Resource Governor, a feature than enables DBAs to provide a consistent and predictable response to SQL Server workloads and system resource consumption. In an environment where multiple distinct workloads are present on the same server, Resource Governor enables DBAs to differentiate these workloads and allocate shared resources as they are requested, based on the specified limits. These resources are CPU and memory. This session will illustrate the basic concepts, components and functionalities associated with the SQL 2008 Resource Governor and will demonstrate how to configure it in response to common business scenarios.
For more information, check out this course on Microsoft Virtual Academy:

Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.