The extended-events tag has no wiki summary.
3
votes
2answers
47 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 ...
1
vote
0answers
29 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 ...
3
votes
1answer
76 views
How can I determine what is using a particular resource (table, view, or function, etc) on my SQL Server?
I've been looking for tables that could use better indexing. I've created a stored procedure that provides a list of tables that have no indexes other than a primary key:
CREATE PROCEDURE ...
2
votes
2answers
221 views
What real-world problems have you solved with Extended Events? [closed]
I have a confession to make: I don't use extended events nearly as much as I've been led to believe I should. Any time I see a blog post on them or read about them in documentation, I say "that's ...
1
vote
1answer
232 views
Querying Extended Events in SQL Server 2008
I have created the following event session using a script I got from Kimberly Tripp's SQL Server 2008 Internals book. It has been modified to send to a file instead of the ring buffer.
CREATE EVENT ...
1
vote
2answers
429 views
Are there any MySQL Triggers or Events that my program can wait for?
Say I want a live feed of emails on a web based email system. Emails are inserted into MySQL tables. Let's say I want my program to know immediately when the table is updated so it can check for new ...
7
votes
1answer
945 views
When should extended events be used instead of SQL Profiler/perfmon?
The extended events seem like a better technology and less stress on the server, but the SQL Profiler/perfmon has better tooling. Also the extended events seem to have a steeper learning curve. In ...
