The 17.0.11 SP1 docs state for the ALTER DATABASE RESTORE CACHE statement:
Question: Does this run in the background? The sp_read_db_pages() procedure has an optional "in_background" parameter but AFAIK the docs don't tell whether this parameter is set as default or not, and therefore it's not clear for ALTER DATABASE RESTORE CACHE either. We think about using that statement within a database start event if cache contents has been stored beforehand (as noted in SYSDBSPACE.saved_cache_pages), say for a regular restart. However, it should NOT disturb the database's availability, so background processing would be strongly favoured. |
Any information from the doc team would be appreciated... :)