mwilmot

SQLShort: SQL Server Resource Governor

Download this episode

Download Video

Description

 

Here is an overview of the SQL Server Resource Governor in slides and some demos.

http://blogs.msdn.com/mwilmot/archive/2009/10/13/sql-server-resource-governor.aspx

SQL Server 2008 provides Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU and memory that incoming application requests can use.

 

Resource Governor is configurable in SQL Server Management Studio by using Transact-SQL statements or by using Object Explorer.

 

Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

 

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    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.