Skip to main content

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

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?