Business Central Onpremise – Create SQL Missing Indexes from AL

Through the page 9521 Database Missing Indexes it is possible to see the missing indexes suggested by SQL Server for Business Central (in fact, an SQL function is called which returns the missing indexes).

In this case the same function has been recreated on SQL (stored procedure) so that it can be launched both from BC (Onpremise) and from SQL.

Source : Roberto Stefanetti Blog
Read more…

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

In summary: This query shows a list of all tables and indexes in a SQL database to help identifying in which tables the most blocks happen, and to give a starting point for index tuning. For further details, refer to the original blog post.

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…