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