In this chapter, we will cover:
Implementing systematized monitoring methods for data platform optimization
Designing a filtered indexes and statistics feature
Implementing table hints for advanced query tuning performance
Implementing query hints for optimized performance
Designing sustainable locking methods to improve concurrency
Implementing parallel query processing methods
Implementing the plan guide to enhance compile-time and runtime execution plans
Configuring and managing storage system for optimized defragmentation processes
Building best usage processes of Dynamic Management Views
Implementing a benchmarking framework on multiple instances