Database optimization and maintenance
This section outlines best practices for maintaining the performance of Sitecore XM databases in On-Premise, Azure IaaS, and Azure PaaS deployments. It covers index maintenance strategies, statistics maintenance, publishing and queue table cleanup, and role-specific database behaviors. It also contains information on how to automate index and statistics maintenance as well as how to troubleshoot performance issues.
XM databases
The key Sitecore XM databases are:
-
Core – system settings, user accounts, and application state
-
Master – content authoring and versioning
-
Web – live site content for delivery
Resources
The following resources are available to help you optimize and maintain the databases:
-
Ola Hallengren - https://ola.hallengren.com
-
Microsoft documentation - sys.dm_db_index_physical_stats
-
Sitecore KBs -
EventQueuecleanup, History table management