Extended Events are a powerful new way of troubleshooting problems with SQL Server, and the addition of UI support in SQL Server 2012 Management Studio
One of the challenges with inheriting an existing set of SQL Servers and databases when you start a new job can be determining which of
I’ve previously blogged about the changes to the xml_deadlock_report in Extended Events to support multi-victim deadlock analysis. One of the side effects of this change
I have been so busy this week that I didn’t get a chance to blog about this yesterday when it happened, but I had a
After my last post, I was contacted by email about the usefulness of query_hash in actual troubleshooting scenarios since the query_hash value is based on
One of the features of the Extended Events UI in SQL Server 2012 is the ability to export an event session definition out to a
For a few weeks now, there has been a long running thread on SQL Server Central about UPDATE operations that don't perform any changes because
This blog post is courtesy of a question I received from Chris Adkin (Twitter) by email. Chris was trying to use Extended Events to track
My latest article on Simple-Talk was published recently. In this article I dig into how to track allocation bitmap contention in tempdb in SQL Server
While I was writing about the new features of the Extended Events UI in SQL Server 2012, I realized that I hadn’t written about the
I’ve been asked questions about these two features a number of times in the last year where the specific concepts for them have been severely
The sqlserver.sql_text action in Extended Events is one of the worst named objects in Extended Events. The name suggests that you are going to get
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.