Folder Long Duration
Last updated 02 March 2021.
Long Duration - Performance troubleshooting and profiling for Dynamics NAV | BC and SQL Server
Checks SQL Server in scope for some of most common skewed Best Practices and performance issues.
Valid from SQL Server 2012 onwards. By default all databases in the SQL Server instance are eligible for the several database specific checks, and you may use the optional parameter to narrow these checks to specific databases.
Only a system administrator/local host administrator is able to perform all checks or functions.
This code and information are provided "AS IS" without warranty of any kind, either expressed or implied. Furthermore, the author or Olav Treffurt IT Consulting shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.
Performance tuning is the process of analyzing query plans, execution plans, indexes, partitioning, etc. and finding ways to reduce the time a query takes or reduce resource usage by that query. There are 4 events that I found can help you to identify queries that can be performance tuned. They are deadlocks, application aborts, blocking, and long running queries.
Contains the following informational sections:
|Long Duration XEvents||
In the view, you can see detailed information about the records captured by the Long Duration process session. This view allows you to find the location in the AL source code using the SQL Server data.
For more information, see the - V8 Search XE - Product Documentation
|Long Duration Application||In the view you get information about how often an application blocked another application. This is NAV/BC interesting, because it is easy to see if third party products are interfering with the day-to-day operations in Dynamics.||2.0|
|Long Duration Dashboard||
Advanced view of target data from advanced events in SQL Server.
In the view you get information about how often an application blocked another application. This is NAV/BC interesting, because it is easy to see if third party products are interfering with the day-to-day operations in Dynamics.
|Long Duration Table Count||In the view you get information about how often a table is represented in the TSQL scripts in the period of the imported "long duartions". To see this data you have to execute the function "LD Table".||3.5|
|Long Duration Table Count||A new function has been implemented to analyze the T-SQL scripts from the "long durations". The function consists of two parts it formats all SQL scripts so that they can be executed and measured directly in SSMS Studio. The second part of the function extracts all table names from all T-SQL scripts of the "long durations". This allows the table names to be analyzed by frequency.||3.5|