• +44 (0)20 3772 1081
  • sales@sqlmantratools.com

Performance Logging for Business Central & Dynamics NAV

SQL Mantra Tools Performance Logging module will record performance related KPIs 24/7 automatically and will work as a “black box” providing vital inside information for a performance incident. This makes the performance logging module the heart of a busy multiuser system. With the analysis module, the logging module would play a major role in providing invaluable inside information for performance tuning and troubleshooting and will lead to extending systems life and its scalability.

The following key performance KPI’s are logged:
  • Blocking*
  • Deadlocks*
  • Slow Queries
  • Index Usage
  • Disk Response
  • CPU Usage
Note:

* With an optional feature for Dynamics NAV and Business Central (versions NAV2013 to all BC versions) SQL Mantra Tool will capture the Dynamics NAV/BC user detail as well as the Dynamics NAV/BC Application code details involved in each of the performance incident in the logs making it possible to identify and tackle performance problems and bottlenecks with pin point accuracy.

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.