Chapter 10. The self-healing database
This chapter covers
- The self-healing database and automation
- Automatically recompiling slow routines
- Automatically performing index and statistics maintenance
- Automatically disabling or dropping unused indexes
- Automatically creating the most-important missing indexes
The concept of a self-healing database relates to the ability of SQL Server to self-correct problems and potential problems before they become noticeable to users. You can implement this by creating a series of SQL Server agent jobs that run periodically. This chapter covers a miscellany of functionality that collectively can automatically improve the performance of your database queries.
The scripts contained in this chapter will ...
Get SQL Server DMVs in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
