Post reply

Sql Server Profiler

  • August 9, 2010 at 3:07 am

    #224394

    Hi

    I need a small clarification regarding SQL Server Profiler.

    I'll explain the scenario below.

    On Machine "A" i have started to run the profiler. the SQL server is installed on Machine "B". I am saving the trace generated into a file on the disk. this file will be saved on the Machine "B"

    Now suppose that i restart the Machine "A" will the trace be stopped or will it be running.

    Thanks in Advance.

    Azeem.

  • August 9, 2010 at 3:25 am

    #1204032

    Of Course the trace will stop, Since you are running SQL Profiler from machine A.

  • August 9, 2010 at 3:25 am

    #1204033

    If you're running the trace via the profiler GUI on Machine A then anything that shuts Profiler down will stop the trace.

    You should be aware that using the Profiler GUI is not usually recommended on busier servers as it does hinder the performance of the server. Rather go for a server-side trace on the server itself, saving to a fast local drive.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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