Post reply

SQL profiler trace result analysis

  • September 4, 2008 at 5:19 pm

    #126160

    Hello All,

    I have got performance issue in a database which is due to the Exclusive locks existing in the db and so i have run the

    the profiler.The parameters specified to identify the Excusive locks to be monotored are

    Locks: Lock Escalation

    SP : Statement starting

    TSQL: Statement starting

    I have stored the trace results in seperate 50 KB files. Let me know how can i analyse the results from these seperate trace files.Also let me know how i can corner the performance issue caused by the exclusive locks from my trace results.

    Regards,

    Eben

  • September 5, 2008 at 12:51 am

    #867590

    You can load the traces into a SQL table (profiler -> save to table or fn_trace_gettable) and then you can query them in SQL. Easier than analysing in profiler.

    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 2 posts - 1 through 1 (of 1 total)

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