A complete introduction to SQL Server 2008 Profiler: creating, watching, storing and replaying traces, and whether to run it on a production server.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009
My user group meeting review for Ahmedabad on March 21, 2009: how Profiler works and how to find the most popular and longest running queries.
SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
I thought adding a column filter in SQL Server Profiler would lower CPU load. My test with large sample data showed the opposite: the filter raised CPU usage.
Reading the Default Trace
Reading the default trace can reveal recent object and configuration changes while its rolling files still retain the evidence.