SQL Server TechCenter

Module 15: Monitoring

In this module, you will learn the following:

  • Formulate requirements and identify resources to monitor in a database environment
  • Types of monitoring that can be carried out to ensure:
    • Maximum availability
    • Optimal performance
    • Error-free operations
  • Availability of tools for monitoring

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 17 Minutes 26 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 15: Demo 1

In this demonstration you will learn to:

  • Locate and Review SQL Server Logs

Video Download
WMV

Length: 4 Minutes 10 seconds

Module 15: Demo 2

In this demonstration you will learn to:

  • Create custom error messages
  • Use Try..Catch Blocks
  • Simulate data validation
  • Review SQL Server Log Entries

Video Download
WMV

Length: 7 Minutes 50 seconds

Module 15: Demo 3

In this demonstration you will learn to:

  • Observe SQL Server services with the Windows Task Manager

Video Download
WMV

Length: 4 Minutes 32 seconds

Module 15: Demo 4

In this demonstration you will learn to:

  • Use the new SQL Server 2008 Activity Monitor to observe specific resources and queries

Video Download
WMV

Length: 5 Minutes 46 seconds

Module 15: Demo 5

In this demonstration you will learn to:

  • Define a Database Mail Profile and Account
  • Create an Alert based on SQL Server counter events
  • Review an automatically generated e-mail to a database administrator

Video Download
WMV

Length: 14 Minutes 32 seconds

Page view tracker