Saturday, April 19, 2014
 
  Monitoring SQL Server 2008

Monitoring SQL Server 2008

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
  Reviewing SQL Server Error Logs

Reviewing SQL Server Error Logs

In this demonstration you will learn to:

  • Locate and Review SQL Server Logs






  Monitoring Errors Using TRY...CATCH

Monitoring Using TRY..CATCH

In this demonstration you will learn to:

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





Monitoring SQL Server 2008

In this module you will learn about formulating requirements and identify resources to monitor a database, types of monitoring, and tools for monitoring.

  Monitoring using Windows Task Manager

Monitoring Using Windows Task Manager

In this demonstration you will learn to:

  • Observe SQL Server services with the Windows Task Manager



  Using Activity Monitor

Monitoring Using Activity Monitor

In this demonstration you will learn to:

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


  Using DBMail and Alerts

Using DBMail and Alerts

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
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM