Dynamics NAV Performance Tooling, Part 1

This is the first in the series of posts to help you monitor and understand your system’s performance indicators. There are several areas to look into when monitoring your system for performance: hardware, setup and configuration, database maintenance, indexing and queries, business logic. We will leave out the traditional topics of monitoring your hardware performance…

2

Table Information including Index information (Usage, Blocks and Reads)

  The query below combines these three queries into one:Index Usage QueryRecent Bocking HistoryTable Information Query   It can be used to just see the number of records in each table. But also by just changing “ORDER BY”, it can be used to see which index cause most blocking / wait time / updates or…