Monitoring and Managing Your Enterprise SQL Server Database Farm

This course covers fundamentals for monitoring SQL Server performance and managing growing database farms. It examines resource use, index management, compatibility levels, and how farm-wide management differs from handling a few instances.

Syllabus

Intro
Managing SQL Servers in the past
Managing SQL Servers today
Managing a SQL Server database farm
Where should I start? How should I manage my farm?
Managing a few instances - Performance Monitoring
Managing a database farm - Performance Monitoring
Managing a few instances - Resource analysis
Managing a database farm - Resource analysis usage view
Managing a few instances - Index Management
Managing a database farm - Index Management
Managing a few instances - Compatibility level
Managing a database farm - Compatibility level
Managing a database farm-Used databases|Activity level
Managing a database farm-Unused databases
Managing a database farm - Inventory