Join Martin Guidry for an in-depth discussion in this video Exploring health data, part of SQL Server 2012: Designing Database Solutions.
- Now I'd like to look at some of the data…gathered by our health utility.…Here in Management Studio…off the View menu we'll look at Utility Explorer.…First thing it brings up is an overall dashboard…that has some information about all of the SQL servers…that it's managing.…It tries to classify them as either underutilized…or overutilized, both of which are things…that would be very interesting to most administrators.…If you do have some servers that are…overutilized or underutilized you can click on one…of these links and get a more detailed report.…
We also see at the bottom some overall information…about storage utilization.…In different timeframes, day, week, month, year,…I might have a little more data…than what you have on your system.…I've been letting this run for a day or so.…In the tree view we also can look at managed instances.…Right now mine has been filtered.…If you ever see this filtered view…and you want to unfilter it,…you'll right click and you'll say Filter, Remove Filter,…and that'll take me back up to the top level.…
- 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.