Join Martin Guidry for an in-depth discussion in this video Introduction to server health monitoring, part of Designing Database Solutions for SQL Server 2012.
- In this section, I'd like to demonstrate…creating a Utility Control Point,…or UCP that we're going to use…to monitor the health of our SQL server.…To create the Utility Control Point…inside of SQL Server Management Studio…off the View menu, the third option from the top…is Utility Explorer.…In this interface, the item I'm interested in…is the top line, Create a Utility Control Point.…This'll kick off a wizard.…
The first step of the wizard is just an Introduction.…So we'll click Next.…The next page asks me which SQL Server Instance…I would like to use.…So I'll hit Connect,…and I'll input the appropriate information…from my SQL Server.…It's then asking for a name.…It suggested the default name of 'Utility'…and I'm fine with that, so I'll just click Next.…Then it's asking me for an account.…In a production system, you would probably create…an account just for this purpose.…
But here in the demonstration, I'll just use my own account.…The next page goes through a series of checks.…Hopefully, we'll get a green check mark on each of them.…
- 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.