Creating Extended Events
Last updated 11 November 2020.
V8 Search XE's support for SQL Server extended events
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.
In order to provide richer and more accurate information, V8 Search XE now support extended events
Currently V8 Search XE supports 5 different Extended Events. However, additional events will be supported in the future.
-
Blocking process (BL)
-
Deadlock (DL)
-
Long-running query (LD)
-
Full SQL Tracing Dynamics NAV/BC (entire transactions)
-
Full SQL Tracing Dynamics NAV/BC (Windows Username vs. SQL SPID)
Requirements for Extended Events
Extended events are only supported on monitored instances with version SQL 2008 and greater.
Please note that there is a known issue using Extended Events on SQL Server 2012. Please see https://support.microsoft.com/en-us/help/2878139/fix-using-dbghelp-dll-version-4-0-5-error-is-logged-in-sql-server-2012 for further information.
Please ensure that the credentials used to monitor each instance have sufficient permissions to create extended events:
- For SQL Server 2012 and greater, the user must be granted ALTER ANY EVENT SESSION permissions
Create Extended Events for V8 Search XE
Go to File > Settings :
Node under Settings, select Files:
-
Change the "Use SQL server Extended event status" to "Enabled"
-
You can select where to save the output files of the extended event (xel files) using the blue button. It is also possible to enter an unc path.
Note: When choosing the directory, make sure that the productive SQL Server (with the Dynamics NAV/BC database) can write to this directory. This path is used to import the analysis data into the V8 database. Click "OK"
-
Go back to the GUI Main Window.
-
Click the File tab ""Data".
-
The V8 Search XE backstage view is used to manage files and file-specific data.
- Press the "SQL Server" button:
- Press the "Extended Events" button:
- Change the "Extended Event " (for example Full SQL Trace NAV ...) to "Enabled" and click "OK"
- Go back to the GUI Main Window.
-
If everything worked, the extended event session should be visible in the SSMS.
Please see https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server?view=sql-server-ver15 for further information.