• +44 (0)20 3772 1081
  • sales@sqlmantratools.com
Database Maintenance module included
System Analysis module included
Performance Logging module included

Performance Tool for Dynamics NAV

SKU:P003

See exactly which Dynamics NAV user, which C/AL code and which SQL statement is behind every slow-running process, block and deadlock in your on-premises Dynamics NAV system, including the blocked and deadlocked C/AL code. Standard SQL Server tools can only tell you that the NAV service tier is blocking itself. The Performance Tool tells you that NAV user X is blocking NAV user Y, and why. It runs 24/7 in the background like a black box, so every incident is captured as it happens, ready to analyse by user, object, C/AL code and SQL. It also keeps your system free of performance problems by proactively optimising tables, indexes and their structure, including removing unused indexes. Its analysis module checks SQL Server setup, memory, CPU, disk response, database and NAV application settings against best-practice guidelines. Supports every version of Dynamics NAV and Navision.

£1199 (RRP) Annual
Modules Included
  • Database Maintenance
  • Performance Logging
  • System Analysis
  • Scheduler
License Information
  • License Type: Server
  • License Period: Annual
SQL Mantra Tools logo

SQL Mantra Tools monitors Dynamics NAV and Business Central performance 24/7, in the Microsoft cloud and on-premises, and pinpoints the root cause of every performance problem: the AL and C/AL code, the named Business Central or NAV user and the SQL code behind each slow query, blocking event and deadlock, plus network speed by user and site. Ask AI for Fix then turns each incident into a root cause and a ready-to-use AL code fix. This is what sets our software apart.


SQL Mantra Tools also analyses your SQL Server's key setup parameters, resources including key Dynamics NAV and Business Central setups, checks them against best practice and recommends the steps to remedy any gaps.


Our maintenance routines proactively keep Dynamics NAV and Business Central databases free from performance degradation, optimising their size and minimising database growth.


We support and tune every version of Navision, Dynamics NAV and Business Central, SaaS and on-premises, whether or not Microsoft still supports that version.