Monitoring SQL Server 2008

Register Login

Friday, May 18, 2012

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos 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

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

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

Privacy Statement

Terms Of Use