Extended Event to track and trace syntax errors

This might sounds like a strange requirement, but it can be converted to do a number of different things. The scenario is that for reason I won’t discuss here, I want to track any user / application which issues an SQL batch which contains invalid syntax. The value here is that this would be extremely…

0

Using Xquery to query Extended Events asynchronous file target results

This is the follow up (part 2) to the following post: http://blogs.msdn.com/grahamk/archive/2009/09/23/realistic-troubleshooting-example-of-extended-events-xevent-usage-in-sql-server-2008-part-1.aspx In the original post we configured an extended event session and issued a very simple query to review the results as XML. Here are some more intelligent XQuery examples. I’m documenting these purely because I hate XQuery so much, and it takes so…

1

Realistic troubleshooting example of extended events (XEvent) usage in SQL Server 2008 – Part 1

Here’s an example of how to collect and consume extended events in SQL Server 2008. It’s something that we in CSS are starting to use more and more frequently with the uptake of SQL 2008, and I believe it’s something that everyone who troubleshoots SQL can gain benefit from. Here’s a relatively simple example which…

0