April 16, 2009 at 8:03 am
How to set SQL profile (light).Thank you
April 16, 2009 at 8:38 am
Sorry but I have no idea what you want. Could you give us more details?
[font="Verdana"]Markus Bohse[/font]
April 16, 2009 at 8:43 am
I want to set up sql profile, and I need your advise what are the negative sides you know
April 16, 2009 at 8:51 am
If you mean setting up a Profiler Trace, there is a slight performance impact but usually it's acceptable. It also depends on how you run it, do you log to a file or a table etc.
Instead of using Profiler with it's graphical interface you can also define a server-side trace which has much less impact.
There's a very good article about this here:
http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx
[font="Verdana"]Markus Bohse[/font]
April 16, 2009 at 9:12 am
Thank you, I get sort warning error under event class, what is this mean and how can I see where it is coming from
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply