Database Reference
In-Depth Information
8
Maintenance and
Monitoring
In this chapter, we will cover:
F
Implementing performance baseline practices
F
Monitoring resource usage with Extended Events
F
Implementing Management Data Warehouse features
F
Designing maintenance tasks on a mission-critical environment
F
Implementing Piecemeal restore strategies
F
Planning and designing of a Disaster Recovery environment
F
Implementing sustainable index maintenance practices for a VLDB and 24/7
environment
F
Configuring a manageable database consistency and integrity process for multiple
databases and a VLDB environment
F
Configuring a server storage system for scalability
F
Configuring SQL server storage architecture for quick recovery
F
Managing a storage system for analyzing bottlenecks
Search WWH ::
Custom Search