Трассировка серверным профайлером

Простой вариант автоматического создания скрипта серверного профайлера описан тут

Управление профайлером с помощью t-sql тыц

Ссылки по теме:
http://scarydba.wordpress.com/2008/12/18/profiler-research/
http://sqlserverpedia.com/wiki/The_Server-side_Trace:_What,_Why,_and_How
http://weblogs.sqlteam.com/tarad/archive/2008/08/06/SQL-Profiler-best-practices.aspx
http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx
http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1345745_mem1,00.html
http://msdn.microsoft.com/en-us/library/ms190221.aspx
http://technet.microsoft.com/ru-ru/library/ms190176.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109800


http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://www.mssqltips.com/tip.asp?tip=1035
http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx
http://support.microsoft.com/kb/298475
http://support.microsoft.com/kb/224587



http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=88900&enterthread=y
http://www.mssqltips.com/tip.asp?tip=1035

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/16/performance-impact-of-enabling-page-checksum-and-default-trace.aspx

http://scarydba.wordpress.com/2008/12/18/profiler-research/