Question : I am unable to understand the performance of below query when collected data from XE events: Query DECLARE […]
Tag: extended-events
Extended Event not catching queries executed on my .NET application
Question : I created that extended event to identify long running queries on my database: CREATE EVENT SESSION [queriesLentas] ON […]
Extracting DDL Events for a database on Azure
Question : I have been trying to extract DDL changes from SQL Server via Extended Events, we needed to know […]
Why does a query on a local instance with local database files cause NETWORK_IO waits?
Question : I have followed this tutorial to get the wait stats of a particular query while it is ‘in […]
MSSQL Server XE column client_connection_id accessible through system view/table for auditing?
Question : In our .NET application we create a SqlConnection to talk to the database. After the connection is opened, […]
SQL Server Extended Events odd behavior trying to capture statements coming from SAS
Question : The problem: the Extended Events (EE) session we created to capture queries against a certain table is not […]
Querying system health data becomes slow as event volume increases
Question : We get the data from system health XE from SQL server and load into table for later querying. […]
Centralized Logs (error, deadlocks, slow queries) For SQL Servers
Question : I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk […]
Extended events vs SQL Audit – performance implications
Question : I would like to setup an audit trail kind of system on my database to monitor for UPDATE/INSERT […]
Blocking Extended events
Question : I have very basic table CREATE TABLE [dbo].[Table_1]( [Test] [int] NULL) INSERT INTO [dbo].[Table_1]([Test]) Select 1 sp_configure’block process […]