22-25 April 2026 
How sp_sqltrace Can Help with Your Performance Troubleshooting
2022TL; DR
Use sp_sqltrace to find out where the bottlenecks in your loops or to find that single plan among many.
Session Details
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.
3 things you'll get out of this session
Speakers
Erland Sommarskog's previous sessions
Don’t Let Your Permissions Be Hijacked!
Learn how malicious users can lure a power user such as sysadmin to run code that performs action to the benefit of the evil user by something I call permission hijacking and what means you can take to prevent this from happening.
Packaging Permissions in Stored Procedures
Learn in this session how you can package any database- or server-level permission in a stored procedure with help of certificate signing or EXECUTE AS and why one method is to prefer over the other.