Discover the fundamentals of monitoring SQL Server performance and learn effective strategies for managing a growing enterprise database farm in this 46-minute webinar. Explore the evolution of SQL Server management techniques, comparing past practices with modern approaches. Gain insights into the challenges of overseeing multiple database instances versus managing an entire farm. Learn where to begin and how to effectively monitor performance, analyze resources, and manage indexes across your database ecosystem. Delve into topics such as compatibility levels, activity monitoring, and inventory management for both active and unused databases. Master the skills needed to efficiently oversee your enterprise SQL Server environment and optimize its performance.
Monitoring and Managing Your Enterprise SQL Server Database Farm
PASS Data Community Summit via YouTube
Overview
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
Taught by
PASS Data Community Summit
