August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 50
Resource Governor
In This Chapter
Understanding Fundamentals
Using Performance Monitoring of the Resource Governor
Exploring Views and Limitations
It's a DBA's nightmare. A query runs and eats up resources to the point that everything else slows to a crawl. The fault might belong to a software developer who didn't consider the resources that his queries chew up, but you get the call. And saying that you don't know what the problem is won't satisfy anyone.
You might get to the bottom of the problem, but what then? Do you sever the connection that the errant application comes in on? That could be a disaster for a mission-critical process. These issues challenged SQL Server DBAs in the past.
The 2008 release of SQL Server introduced the Resource Governor feature, which enables you to limit the CPU and memory usage by a specific application, hostname, user, or any other attribute of the connection session. Now you can stop having those nightmares because you can limit the resources for a query that might typically bring the server to a crawl.
Resource Governor is also an Enterprise Edition-only feature.
You can configure the Resource Governor in two ways. The first is through T-SQL commands. The second is via the Object Explorer from within SQL Server Management Studio.
Note
There is a difference between the Resource Governor and the Work Load Governor. The Workload Governor was part of earlier versions of SQL Server and limited the performance of SQL Server as a whole. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.