SQL 2008 Server side Trace vs Client side trace/profiler

Is there any reason not to use server side trace and instead use client side trace?
LVL 2
itniflAsked:
Who is Participating?
 
Steve BinkCommented:
None that I know of.  The preferred method is a server-side trace due to load concerns.  Here is a very good article explaining the load a client-side trace can create:

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.