Dynamics NAV SQL Server Performance and SIFT Diagnostic Pack (Navision)
This pack is for DBAs, IT admins, and NAV partners running on-premises Microsoft Dynamics NAV (Navision) with direct SQL Server access via SSMS or T-SQL. It is not for Business Central SaaS or any cloud-hosted NAV environment where direct SQL access is blocked. If your NAV database is slowing down during posting, grinding through list pages, or blocking users at month end, the cause is almost never what generic SQL Server tuning scripts surface. The real culprits are NAV-specific: SIFT indexed views ($VSIFT$ objects) that SQL Server must update on every write to your ledger tables, FlowField calculations that expand into cascading OUTER APPLY joins on every page load, runaway row counts in company-prefixed ledger tables, and lock contention patterns that only appear when NAV is posting. No stock DMV script knows any of this, because no stock DMV script knows your database is partitioned by company prefix or what a VSIFT view is. This five-script diagnostic pack uses only built-in SQL Server DMVs and NAV's own company-prefixed naming conventions to expose exactly those bottlenecks. It maps every company in the database, identifies the heaviest ledger tables by row count and size, inventories every $VSIFT$ indexed view and its write overhead, detects the FlowField and SmartSQL queries consuming the most I/O, and surfaces live blocking sessions scoped to NAV tables. You run each script directly in SSMS, read the output, and immediately know which objects are causing the pain and why. Script 01 builds a company map and ranks ledger hot tables by bloat across all company prefixes. Script 02 inventories every $VSIFT$ indexed view and quantifies the maintenance overhead SQL Server pays on writes. Script 03 detects the heaviest FlowField and SmartSQL query patterns by I/O and execution count, scoped to NAV tables. Script 04 reports missing, unused, and duplicate indexes scoped to NAV company tables to cut redundant write amplification. Script 05 delivers a live blocking and lock contention report filtered to NAV tables so you can pinpoint posting bottlenecks in real time. Every script is read-only, querying DMVs and catalog views without touching application data or schema. No installs, no agents, no elevated permissions beyond VIEW SERVER STATE. SQL Server version support is SQL Server 2016 and newer (tested: 2016, 2017, 2019, 2022).
Get it → bearndeals.gumroad.com