Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Running Client-side Profiler trace or Server-side trace? RE: Running Client-side Profiler trace or Server-side trace?

  • January 2, 2014 at 3:03 pm

    #1677064

    profiler is resource intensive, no matter the SQL version.

    consider this:

    there is nothing a slow, resource intensive profiler trace can do that a server side trace cannot do.

    EVERY client side trace can be replaced with a low impact server side trace; there are no exceptions to that, because whatever you build as a client side trace can be scripted to be a server side trace template.

    for me, running profiler is something i might do if i wanted to do a right now diagnostic, otherwise i'd build the template in profiler and save it as a script to create on the server.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!