PROFILER is very handy tool to trace the events on SQL Server, like wise SQL Server 2008 gets the new feature Extended Events which is a light-weight & less intrusive tool. Still there are number of DBAs out there are really scared to invoke PROFILER...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Fri, Jul 16 2010
Filed under: Filed under: sql server, profiler, trace, best practices, collection, ebook, pssdiag, free space, server side, gui, low space