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