LockTimeoutDuration in AL

In the online environment, the lock timeout duration is set to 30 seconds and, until now, cannot be changed anywhere. On-premises there is a parameter in CustomSettings.Config to override the default value, called SqlLockTimeoutOverride: The default value is stored in $ndo$dbproperty table, locktimeoutperiod field (that is set, in Dynamics 365 Business Central 2025 Wave 2... Continue Reading →

Insights around Database Maintenance in Dynamics 365 Business Central Online

Sometimes, I am in the frontline spitting blood in making the most out from SQL Server installations. Needless to say, one of the most important part is to to setup a good maintenance plan, tailored on every database workload and resources available. Since SQL Server and Azure SQL are two brothers – but far to... Continue Reading →

Blog at WordPress.com.

Up ↑