Using SQL Server 2005 Profiler

In this presentation, Brian introduces SQL Server 2005 Profiler. He shows you to integrate System Monitor logs (also called perfmon) to find what queries were running against your machine during key performance failures. He also shows you how to output the query plan into an XML file.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Benjamin Lotter on 10/16/2008

Very interesting -- especially how you can correlate perfmon data with the trace statement execution timeline.

Venkata Taduri on 2/10/2009

Covered in detail. Thank you.