Profiler  
Author Message
Rath





PostPosted: Tue Oct 07 09:11:07 CDT 2003 Top

SQL Server >> Profiler

How big is the performance penalty for running profiler?

SQL Server97  
 
 
Kevin





PostPosted: Tue Oct 07 09:11:07 CDT 2003 Top

SQL Server >> Profiler The best phrase I've heard is "you pay as you go".

In other words, if you have one row and lots of columns in profiler for
every page-lock event, then the hit will be significant. On the other hand,
if you only trace infrequent events, and capture few columns, like say,
login/logout, then the penalty will be negligable.

--
Kevin Connell, MCDBA
--------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------


> How big is the performance penalty for running profiler?