Resource Governor Basics
by Brent Ozar
In very large databases, ad-hoc user queries can easily run on for minutes or hours. Patient users often kick off long reporting queries and then walk off to get coffee while their queries run on endlessly. We call these queries zombies. Your weapon against the zombies is the Resource Governor, new in SQL 2008. Learn how to use the shovel in this video.
Get the Flash Player to see the wordTube Media Player.
For more about the Resource Governor and other VLDB tips, check out our Very Large Databases wiki article.
Subscribing or Downloading the Podcast
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later:
Tags: resource governor, vldb
