Last updated 11 November 2020.
Deadlocks - 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:
In the view, you can see detailed information about the records captured by the deadlock 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 Processes Overview - V8 Search XE - Product Documentation
|Deadlock 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|
Returns the text of the SQL batch that is identified by the specified sql_handle.
This query will show you the SQLHandle that was unique in the blocked process report and contains a value other than blank or 0x0.
The SQLHandle is a varbinary data type that is suitable for binary data of variable length. The sql_handle is a token that references a stored procedure or a batch.
You can be accessed for example via the function "Dashboard -> SQL Server -> SQL Management -> SQL Handle Short ".
Advanced view of target data from advanced events in SQL Server.
This function is no longer used in the current version and will not be visible in future versions of the V8 Search XE.