SQL Server 2008 Resource Governor

Resource Governor enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests.

In an environment where multiple distinct workloads are present on the same server, Resource Governor enables you to differentiate these workloads and allocate CPU and/or memory as they are requested, based on the limits that you specify. Resource Governor is designed to address the following types of resource issues which are commonly found in a database environment:

• Run-away queries on the server
• Unpredictable workload execution
• Setting workload priority

Category:

Science & Technology

Tags:

• SQL
• Server
• 2008
• Resource
• Governor
• Magenic

[emad3hhh]

Thank you

[fbernardo]

thanks, i think it would have been a more effective video if you actually showed the resources being limited at the end...but thanks it's a great video.

[hi10010]

Thank You

[YoLninYo]

go slow my man! and take a breath once in a while, you're out of breath you're talking so fast ;-) lol nice video tho... try talking slow .. plx

[Trojaaan87]

i like