SQL Mantra Tools Documentation

Everything you need to get started with SQL Mantra Tools: a quickstart for Performance Insights for Business Central, the full user manual, a video walkthrough of every analysis, and our Business Central and Dynamics NAV performance guides.

Quickstart: set up Performance Insights for Business Central
User manual
Video walkthrough
Performance guides
Getting help

Quickstart: set up Performance Insights for Business Central

Performance Insights for Business Central works with Business Central SaaS and on-premises (BC16.1 and later). It needs no SQL Server access, and nothing is installed in Business Central. Getting started takes five steps:

Contact SQL Mantra Tools with your company and contact details, and tell us whether your Business Central system is SaaS or on-premises.
Connect Business Central. For Business Central SaaS, enter the connection string in the Business Central admin center, enable Application Insights and save. This may restart the service tier, so do it in a maintenance window. For on-premises, follow the instructions SQL Mantra Tools provides for your environment.
Check Telemetry IDs. In Business Central, make sure every user card has a Telemetry ID. Where it is blank, use the field's build action and choose a random GUID.
Send us your setup details and your Business Central time zone, so every chart and table is shown in your local time with real Business Central user names.
Open the Performance Dashboard. Once the connection is confirmed, log in to the SQL Mantra Tools web portal, open Manage Customers, select your customer, choose Manage Customer License and click Performance Dashboard.

Full step-by-step instructions with screenshots are in section 3.10 of the SQL Mantra Tools user manual (PDF). Questions? Contact us.

User manual

The SQL Mantra Tools user manual (PDF) covers installation, configuration and use of all SQL Mantra Tools products. Useful sections include:

Section 3.2.5: Performance Insights features, including named-user analysis and fuzzy filtering on users.
Section 3.10: how to set up Performance Insights, step by step.
Section 3.8: how to install the on-premises tools, such as the Performance Tool for Dynamics NAV.
Section 3.9: loading the SQL Mantra Tools extension, which captures Business Central users and AL code for on-premises blocking and deadlocks.
Sections 3.6.17 to 3.6.19: live blocking, blocking and deadlock analysis, showing which user is blocking which, with the blocking and blocked code.
Section 6: troubleshooting.

Video walkthrough

Fix Business Central slow performance: full walkthrough of Performance Insights (26 minutes, with chapters and a full transcript) demonstrates every analysis: slow queries, blocking, deadlocks and network speed by named Business Central user, fuzzy filtering on users and groups, AL code and SQL code, and the partner dashboard.

Performance guides

Getting help

For setup help, support or performance consulting, contact us. Support is available until 5:30 pm US Eastern time, over Microsoft Teams with optional remote desktop access.

Frequently asked questions

How do I set up Performance Insights for Business Central?

Setup takes a few steps. 1) Contact SQL Mantra Tools with your company details and whether Business Central is SaaS or on-premises. 2) For Business Central SaaS, enter the connection string in the Business Central admin center, enable Application Insights and save; this may restart the service tier, so do it in a maintenance window. For on-premises, follow the instructions SQL Mantra Tools provides for your environment. 3) Check that every user card in Business Central has a Telemetry ID; where it is blank, use the field's build action and choose a random GUID. 4) Send SQL Mantra Tools your setup details and your Business Central time zone. Once the connection is confirmed, log in to the SQL Mantra Tools web portal, open Manage Customers, select your customer, choose Manage Customer License and click Performance Dashboard. Step-by-step instructions with screenshots are in section 3.10 of the SQL Mantra Tools user manual.