Folder Extended Events XE Import
Last updated 11 November 2020.
SQL Extended Events XE - 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.
IMPORTANT pre-requisites:
Only a system administrator/local host administrator is able to perform all checks or functions.
DISCLAIMER:
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.
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.
DESCRIPTION:
Reads files created by the asynchronous extended events file destination. One event is returned per line in XML format. Afterwards the Extended Events .xel file will be imported into a SQL table in the V8 database. This data forms the main base for performance analysis with V8 Search XE.
Reads files created by the asynchronous extended events file destination. One event is returned per line in XML format. Afterwards the Extended Events .xel file will be imported into a SQL table in the V8 database. This data forms the main base for performance analysis with V8 Search XE.
Contains the following informational sections:
General
| SQL Query | Description | Version |
|---|---|---|
| Import NAV User XEvents |
View Target Data imports the accumulated data from multiple .XEL files from the given event session. After successful import, you will receive a message about the number of records imported into the V8 database.
For more information, see the Creating Extended Events - V8 Search XE - Product Documentation |
2.0 |
| Import Full SQL Trace XEvents |
See the above description.
For more information, see the Creating Extended Events - V8 Search XE - Product Documentation |
2.0 |