Video unavailable

SQLBits 2022

How sp_sqltrace Can Help with Your Performance Troubleshooting

Use sp_sqltrace to find out where the bottlenecks in your loops or to find that single plan among many.

sp_sqltrace is open-source tool written by Lee Tudor which is an excellent tool when you to find out why a specific process is slow, particularly when it's running loops. It's also very powerful when you want to look at a single plan from a batch that runs hundreds of statements. You can even use it as a statement debugger.

Speaker

Erland Sommarskog is an independent consultant from Stockholm. He has been working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has held the award since.

Erland Sommarskog's Sessions

Analysing and Resolving Deadlocks.

Ask the Expert - Group A (Thu 14:10 to 15:00)

Don’t Let Your Permissions Be Hijacked!

Collations and Performance

Don't Bite Off More than You Can Chew - Take it in Chunks

How sp_sqltrace Can Help with Your Performance Troubleshooting

Looping Abreast

Some Things You May Want to Know About Collations

SQL Titbits for the Inexperienced

Packaging Permissions in Stored Procedures

Dynamic Search Conditions