The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
2answers
17 views

Filtering extended events with configuration table

I've created E.E. session to audit logins, but there are many logins that I need to filter out. I'm wondering, if there is a better option(like creating conf. table with unwanted logins and filter ...
0
votes
0answers
11 views

Extended Events Live Data Not Reporting All Events [duplicate]

I'm fairly new to Extended Events and am currently working with how to view the data that gets captured. One of the things that I really liked was the "Watch Live Data" view; you can see everything ...
1
vote
1answer
31 views

Change Name of Extended Event Session

I've just recently started working with Extended Events and am loving it. However, I ran into a small annoyance and am wondering if there's a way around it. I had a very simple ExEvent session that ...
4
votes
2answers
108 views

Extended events vs SQL Audit - performance implications

I would like to setup an audit trail kind of system on my database to monitor for UPDATE/INSERT statements on a specific table with very high activity. I have two options in front of me: using the SQL ...
3
votes
1answer
34 views

Chance of skipping extended events when using an offset for the file target

I am exploring extended events and came across a question I can't solve using the Microsoft documentation: When reading events from the file target we can specify and initial offset so we can read ...
3
votes
1answer
101 views

MEMORYCLERK_XE Memory Usage Will not Clear

We've been having an issue where memory usage from Extended Events grows to over 1 GB and then will not clear - even when we stop all XEvent session on the instance. This hasn't been an issue yet on ...
0
votes
0answers
23 views

Performance Comparison using extended events

I am using SQL Server 2012. In my development database I have an old (MySP_Old) and new(MySP_New) versions of a stored procedure. This procedure has around 10 big queries in it. I need to compare each ...
2
votes
1answer
49 views

Extracting DDL Events for a database on Azure

I have been trying to extract DDL changes from SQL Server via Extended Events, we needed to know the type of change and the user who made the change. We wanted to avoid the use of triggers where ...
2
votes
1answer
32 views

Multi-Server Extended Events investigations

Do you happen to know if there's a method of centralizing the Extended Events information of many servers in one place (for easier administration and diagnostic). Ideally I would like to have ...
2
votes
1answer
48 views

How to use two actions and a function in an Extended Events Histogram for deadlocks?

I'd like to get a histogram through extended events that shows the count of deadlocks per databasename by date, but I'm hitting two walls: How get a histogram to include two actions How to get the ...
4
votes
1answer
84 views

Blocking Extended events

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 threshold', 1 --> 1 sec go To create ...
0
votes
0answers
19 views

Filtering On Multiple Columns in MS SQL Extended Events Or Tracing

Anyone have a good way to filter to only collect results that provide a unique client HostName and client Application Name using extended events or another technology? I'm hoping to use this to ...
0
votes
0answers
46 views

How do you use Extended Events to find port numbers?

I'm migrating some TSQL code from one server to another. The server I'm moving it from is production, so I'm not easily able to adjust settings for obvious reasons. The code runs fine on the ...
11
votes
1answer
481 views

How can I shred this Extended Events XML as fast as possible?

I created an Extended Events session in SQL Server 2008 R2. The session runs, and collects events as they happen, exactly like you'd expect. If I shred the xml when there are relatively few events, ...
1
vote
0answers
29 views

Best event to track the DML operations being performed on Server along with the hostname performing those operations?

Currently I'm using the XE event sql_statement_completed to track the DML statements that are being executed and the hostname that is performing the same. However this event gets fired for each and ...
2
votes
1answer
84 views

Seeking help with Extended events behaviour

I'm using Extended Events to track the procedures that are being executed on the server, along with the Hostname of its executor. I've used the following XE script for the same: CREATE EVENT SESSION ...
3
votes
2answers
196 views

How to prevent Extended Events from tracking system fired events?

I have employed Extended Events to track the DML and DDL operations that are being performed on the tables within a particular database. Apart from this I'm also tracking the procedures that a user(...
0
votes
0answers
162 views

Audit DML with Extended Events

I'm trying to use Extended Events to log the DML operations (the particular DML statement) that are being performed, and to identify the individual performing them, I'm resorting to enlisting that ...
2
votes
1answer
174 views

Extended Events XML querie to show relevant info about deadlocks - SQL Server 2014

While trying to get together information about deadlocks I came across this link which asks a question regarding a trace: Interpretation of a column in SQL Server profile trace The answer dealt with ...
2
votes
1answer
96 views

what are the costs of enabling extended events?

I have been dealing with deadlocks, specifically getting their information, as you can see on this post here. On this same post Shanky recommended "You must now rely on extended events trace to ...
6
votes
1answer
359 views

How to find the stored procedure which executed an event?

I have a problem where a certain stored procedure disappears occasionally and I need to find out which script deletes it. I found this piece of code which gives the events related to the deletion of ...
2
votes
1answer
523 views

Unable to Watch Live Data on Extended Events Session

I am running SQL Server 2014 Developer Edition on my PC. I am trying to view the data in the system_health session. In SSMS, I have connected to the database, expanded the server / Management / ...
0
votes
0answers
96 views

Troubleshooting Memory-Pressure on SQL Server with 80+Gb RAM

I have a SQL Server cluster with 80+Gb of RAM and multiple production enterprise databases and applications running. We are encountering memory-pressure errors and are trying to troubleshoot what's ...
2
votes
1answer
28 views

Any merit to MSSQLSERVER Trace from logman as opposed to XEvent Package 0

The general understanding of monitoring SQL Server activity is that using SQL Profiler is very heavy, server side traces are less heavy, but extended events are even less heavy. Today I discovered ...
0
votes
1answer
94 views

XQuery on Extended Events joining with dm_exec_query_plan not working [duplicate]

I have this XQuery for my extended event session which works fine but when I try joining the plan_handle to dm_exec_query_plan to get the query plan, it says Msg 257, Level 16, State 3, Line 1 ...
4
votes
1answer
320 views

Can SQL Server 2008 R2 extended events execute stored procedure or query?

I'm trying to use extended events to track queries that never complete using Event Pairing as a target. (see this question I asked a few days ago). The event pairing target should let me find ...
2
votes
0answers
85 views

Is it possible to trace queries that never complete with SQL Server 2008 R2?

Running SQL Server 2008 R2. We have some queries that typically take less than one second to complete, but, occasionally, they are taking longer than 30 seconds which causes a client timeout. ...
4
votes
0answers
87 views

Take action from extended event?

I've seen it mentioned a few times that you can configure an event session to take an action when an event fires. Does anyone have any information on how to do this? I know that you can use the ...
1
vote
0answers
75 views

Does XP_API deprecation announcement mean that sp_executesql will not be supported in the future?

I have setup an Extended Events session in SQL 2008 R2 to track the deprecation_final_support and deprecation_announcement events. I noticed some "deprecation_announcement" events in my log with "...
2
votes
1answer
187 views

SQL Server 2012 extended event session to expose the network protocol

I am using SQL Server 2012 (11.0.5058.0) extended events, and wish to know the network protocol used by each connection (TCP/IP, shared memory etc). Event session created for the login event via: - ...
2
votes
0answers
193 views

This Extended Events session works on Dev but not on Pro. Why? [closed]

I do have the following Extended Event session on my Dev and Pro boxes: CREATE EVENT SESSION [sp_showplan] ON SERVER ADD EVENT sqlserver.query_post_execution_showplan(SET collect_database_name=(1) ...
0
votes
0answers
207 views

Why does Extended Events server_principal_name return NULL sometimes?

I have an extended event session setup. This is the definition. CREATE EVENT SESSION [Successful-Logins] ON SERVER ADD EVENT sqlserver.connectivity_ring_buffer_recorded ( ACTION ( sqlserver....
2
votes
1answer
728 views

How can I filter an extended event by database in SQL Server 2008 R2

If I do an extended event session like this in SQL Server 2008 R2: CREATE EVENT SESSION [Query tracing] ON SERVER ADD EVENT sqlserver.rpc_completed ( ACTION(sqlserver.sql_text) ...
5
votes
2answers
436 views

Getting ApplicationName (sqlserver.client_app_name) to show up in an xevent

I am trying to examine some T-SQL with extended events like I used to with SQL profiler. I have the following event session: IF EXISTS (SELECT name FROM sys.dm_xe_sessions WHERE Name = 'PySoup ...
12
votes
1answer
707 views

Visualizing SQL Server Extended Events data

Lately I've been exploring using Extended Events in SQL Server to help me benchmark and optimize various queries. So far, to view the event data I have been using the "Watch Live Data" feature in SSMS....
4
votes
1answer
139 views

System Health Extented Event - Security_Ring_Buffer_Error_Recorded

I've recently upgraded a Production SQL instance from 2005 SP4 to 2012 SP2 and have noticed a large amount of the following entries in the system_health extended event:- I've been looking into this ...
4
votes
1answer
778 views

Failover Cluster Diagnostic Logs

I know there must be a simple answer to this question, but I cannot find it anywhere. Our SQL 2012 FCI have SQLDIAG .XEL files in their MSSQL\LOG folder. In some instances, these files are often ...
3
votes
1answer
2k views

Performance impact of Extended Events filter [like_i_sql_unicode_string]

I have created an extended events session in which I wanted to see all queries using nolock hint. I have decided to use it instead of sql trace in order to minimaze possible performance impact. ...
1
vote
0answers
52 views

Extended Events missing documentation

I have been looking pretty hard for the documentation regarding the RingBufferTarget <RingBufferTarget truncated="0" eventsPerSec="1370714" processingTime="7" totalEventsProcessed="9595" ...
2
votes
2answers
1k views

Permissions required for running extended events

I've found this link: Changes to Extended Events Permission Requirements in SQL Server 2012 that mentions the need of CONTROL SERVER permission for using extended events on SQL Server 2008. I want to ...
7
votes
2answers
809 views

SQL Server performance: PREEMPTIVE_OS_DELETESECURITYCONTEXT dominant wait type

I received a call yesterday from a customer who was complaining about high CPU usage on their SQL Server. We're using SQL Server 2012 64 bit SE. Server is running Windows Server 2008 R2 Standard, 2.20 ...
0
votes
1answer
449 views

In Extended Events what is the difference between rpc_completed and sql_batch_completed? [duplicate]

I understand that rpc_completed is defined as the completion of a remote procedure call and sql_batch_completed is the completion of a t-sql batch. However can anyone explain in concrete terms what ...
4
votes
0answers
844 views

Collecting parameter values from Extended event session

I'm using extended events to trace the statements used by our application. I have created a session that will collect the information that I want, except that I would also like to know the actual ...
37
votes
1answer
11k views

What event information can I get by default from SQL Server?

I often see questions where people want to know if a certain thing happened, or when it happened, or who performed the action. In a lot of cases, SQL Server just doesn't track this information on its ...
4
votes
1answer
409 views

Extended event (sp_statement_completed) firing multiple times

I'm using SQL Server 2008 R2 enterprise and this is my first foray into extended events. It's pretty cool stuff. I'm wanting to create a session that will run basically all the time to audit query ...
4
votes
1answer
586 views

Sql Server 2012 Extended Events for Selective Xml Indexing not showing results

I created a Extended Event to monitor and tune a Selective Xml Index CREATE EVENT SESSION [SelectiveXmlIndexing] ON SERVER ADD EVENT sqlserver.selective_xml_index_no_compatible_sql_type, ADD EVENT ...
5
votes
1answer
1k views

What does the wait type PREEMPTIVE_XE_CALLBACKEXECUTE mean?

I have two instances in the last week where a DROP command for an Extended Events session has taken over a day to complete, sitting with the wait: PREEMPTIVE_XE_CALLBACKEXECUTE. Can anyone explain ...
1
vote
1answer
557 views

MySql one time event never runs?

Please have a look at below events 1) create EVENT Test1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 20 second ON COMPLETION PRESERVE ENABLE DO ... 2) create EVENT Test2 ON SCHEDULE EVERY 20 ...
3
votes
2answers
1k views

Can I get notification when event occur?

SQL Servers has Traces and XEvents. These are used to capture and analyze what is going on with our SQL Server Instances. Events are stored in the stack for later analysis. For example, If I decide ...
3
votes
1answer
337 views

Is there an effective way to create extended event data that includes stacktraces in SQL Server on a local db instance?

I read Paul Randal's article on getting the symbols for SQL Server. I have a theory that I could get the extended events to read the symbols from the symbol server catch directory by setting the ...