Join Martin Guidry for an in-depth discussion in this video Managing server resources in a consolidated database infrastructure, part of SQL Server 2012: Designing Database Solutions.
- When a designing a system that's going to…consolidate some legacy databases onto one instance,…one of the concerns we might have is…will one of these databases hog so much resources…that it would prevent other databases…from having adequate resources.…We have a tool inside of SQL Server…that will allow us to control the amount of resources…given to different databases…or given to different groups of users.…That tool is called Resource Governor.…
In the Management branch of the tree,…we'll open that up,…and we'll see Resource Governor.…We'll open it up and we'll see…that it contains some Resource Pools.…So the way this works when a request…comes into the SQL Server,…that request will have to be sent…to a certain resource pool.…Those resource pools set minimums and maximums…on the amount of CPU and memory…that can be used by a particular operation.…The first step in doing this is creating…what's called a classifier function.…
That classifier function will be used…to analyze the incoming request…and say which resource pool they belong to.…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.