O'Reilly logo

SQL Server DMVs in Action: Better Queries with Dynamic Management Views by Ian W. Stirk

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required