Post reply

Profiler Server Taxation

  • October 18, 2010 at 8:15 am

    #149029

    Using a profile that just captures a created object on sql.

    Bad practice?

    High tax on performance of server?

    Thanks,

    Mark

    Catchy phrase here...

  • October 18, 2010 at 8:17 am

    #1238437

    I would say that using profiler would not be the best idea as you should be able to get this information from the default trace

  • October 18, 2010 at 10:48 pm

    #1238827

    Agree with SteveB. Running a profiler trace is an overhead on the instance, instead you may run server side traces. Since you want to capture object creation details, it is already captured by the Default Trace. This article[/url] explains how to read the default trace.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply