Performance - partners can get insights into database wait statistics

Enabled for Public preview General availability
Users, automatically Apr 1, 2022 Apr 1, 2022

Business value

Developers and administrators can get insights into database performance.

Feature details

The database for a Business Central environment makes performance counters and information about SQL queries available through Dynamic Management Views (DMVs). It requires direct database access to be able to obtain this information, and for Business Central online environments, this is not possible due to security restrictions.

With this capability, the Business Central platform will make data about database wait statistics as a virtual table, so that the data can be accessed from AL code. We will also add a page on top of the new table to make it easy to get the data without having to write code.