Configure MAXDOP (max degree of parallelism) on SQL Server 2016… 2019)

The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This topic has been discussed for many years, the best practices have changed more than once (see my old post about it – https://robertostefanettinavblog.com/2015/06/04/sql-server-maxdop-configuration-option-for-microsoft-dynamics-nav/) Microsoft has now released … Read more

Business Central SaaS Exporting Database Backup and Restore it on your Sql Server

Business Central SaaS Exporting Database Backup and Restore it on your Sql Server Since some days, Microsoft has activated the feature for downloading a backup of a Business Central SaaS Azure SQL Database directly from Admin Center. A selected database (in this case a BC v15 Wave 2 production database) can be backuped and exported … Read more

SQL Server Performance with Business Central

SQL Server Performance with Business Central Lately interesting articles have been published on how to optimize business central with sql server, how to better use the data cache, how to use partition tables, how to use compression, how to monitor performance, since they are interesting to report. Optimizing SQL Server Performance with Business Central https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/optimize-sql-server-performance … Read more

Detect Deadlocks in old NAVs

Detect Deadlocks in old NAVs (<2017) In old NAV releases (between NAV 2013 and NAV 2016) is very difficult to show and resolve blocking issues. IN NAV 2017 As a new feature in Dynamics NAV2017, you can configure that information about database deadlocks is written to the Windows Event Log. If database deadlock logging is … Read more

A Visual SQL Query Designer – Code project (SQL From NAV Part III)

A Visual SQL Query Designer – Code Project (SQL From NAV Part III) If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated query editors..) can use this nice tool to run SQL queries (or others T-SQL statements…). This tools recalls some typical features of SQL Studio … Read more

%d bloggers like this: