Aggressive buffer pool warm-up after restart in SQL Server

Abstract

In many settings, a database server has to be restarted either in response to a failure event, or in response to an operational decision such as moving a database service from one machine to another. However, such restarts pose a potential performance problem as the new database server starts off with a cold buffer pool. As a result, the database… (More)
DOI: 10.1109/ICDEW.2016.7495612

18 Figures and Tables

Topics

  • Presentations referencing similar topics