Team Blog

Erin Stellato walks through a quick and simple way to use Extended Events and the new XEvent Profiler to review queries on your system.
February 25, 2019 | SQLPerformance.com | Extended Events 0
Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events.
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
Aaron Bertrand shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
Aaron Bertrand describes a new way to track backup and restore extended events...

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial