How big is the performance penalty for running 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.
----
"Andrew" <a@.b.com> wrote in message
news:085901c38cdb$e56df160$a001280a@.phx.gbl...
> How big is the performance penalty for running profiler?
No comments:
Post a Comment