Skill

Microsoft MCSA SQL Server 2016 (70-764): Monitor SQL Server Instances

with Garth Schulte

Join Garth Schulte as we learn how to keep track of the performance and health of our servers in real-time. In a lab environment, we'll practice setting up alerts, tracking available space, and configuring failure actions that prevent downtime.

Recommended Experience

Basic understanding of SQL Server administrative features
Familiarity with monitoring tools in database environments
Experience with performance tuning would be helpful

Related certifications

Microsoft MCSA: SQL 2016 Database Administration (retired)

Related Job Functions

Database administrator (DBA)
SQL server engineer
Systems administrator

A former CBT Nuggets learner, John used online IT training to help him build a diverse skill set, which includes networking and cybersecurity.

Get started

Skill Outline

1. Monitor SQL Server Instances: SQL Server Instance Monitoring (0:36)
2. Monitor SQL Server Instances: Configure Database Mail (0:37)
3. Monitor SQL Server Instances: Create and Manage Operators (0:36)
4. Monitor SQL Server Instances: Create and Manage Alerts (0:37)
5. Monitor SQL Server Instances: Define Custom Alert Actions (0:36)
6. Monitor SQL Server Instances: Define Failure Actions (0:36)
7. Monitor SQL Server Instances: Configure Policy-based Management (0:37)
8. Monitor SQL Server Instances: Identify Available Space on Data Volumes (0:36)
9. Monitor SQL Server Instances: Identify the Cause of Performance Degredation (0:37)
10. Monitor SQL Server Instances: Lab (5:37)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Free Flashcards

Flashcards help you reinforce what you’ve learned before exam day.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews