O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performance Tuning with SQL Trace and Extended Events

Tara Kizer

We can gather information about activity on our SQL Servers in numerous ways, such as using Dynamic Management Views (DMVs), Performance Monitor, Extended Events and SQL Trace. Due to the level of detail it provides and its relative ease of use, the latter is one of my most-used tuning tools due to the level of detail it provides and its relative ease of use. SQL Trace allows us to collect and analyze data for different types of events that occur within SQL Server. For example, SQL Server acquiring a lock is an event, as is the execution of a statement or stored procedure, and so on. We can find our worst performing queries, see how often a query executes, check what exceptions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required