Join Martin Guidry for an in-depth discussion in this video Implementing policy-based management, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, I'd like to walk through an example…where we're going to use policy management…to make sure we have an appropriate amount…of free space available to us in all of our files.…So first, we'll need to create a new condition.…I'll do this by right-clicking…and going to New Condition.…The name of the condition will be available space.…You can name it whatever you want.…It doesn't affect the functionality.…But, being in the long run, you could end up with…lots and lots of conditions,…you probably want to provide a meaningful name.…
If not, they will become very difficult to administer.…The Facet I'm interested in is Data File…and the Field I'm interested in is Available Space…and I happen to know that available space…is measured in kilobytes and I am interested in…files that have less than 1,000 kilobytes.…So, I will check for files that have…more than 1,000 kilobytes.…That'll be the condition that allows it to pass the test.…
So, any file that has more than 1,000 kilobytes…of free space will pass this test.…
- 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?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.