Dynamics 365 Business Central
Category
Sep 24, 2024
Published date
Text
Article Type
AI Summary
- The article discusses the importance of setting up a good maintenance plan tailored to every database workload and available resources in SQL Server installations.
- It explores how database maintenance plans are handled in the Online version of SQL Server and Azure SQL, including the ability to download and restore production environments from Tenant Admin Center into Azure Blob Storage.
- The article mentions limitations on downloading bacpac files, automation using Tenant Admin Center API, and the requirement for paid Production environments for the download and restore process.
- It delves into the contents of the bacpac files, highlighting the Azure SQL version, object statistics, property options for the database online, and specific parameters like MAXDOP and IsReadCommittedSnapshot.
- The author expresses surprise at the MAXDOP setting being at 1 and discusses the potential benefits of enabling parallelism in Dynamics 365 Business Central online databases.
- The article touches on features like Autotune Queries, DAMS service, LogfileUsage, and ReindexerExclusionList found in the restored bacpac files, emphasizing Microsoft's expertise in handling maintenance tasks for online databases.
- It concludes by highlighting the advantages of automatic tuning of query execution plans, the presence of DAMS microservice for maintenance tasks in Azure SQL databases, and the need for parallelism optimization in production databases.
- The author expresses a desire for more insight into the timing and execution of maintenance tasks in online databases, mentioning the importance of environmental telemetry signals for monitoring.
Registered users can view the full text for FREE!
Sign In Now!