Home Forums SQL Server 2012 SQL 2012 - General Extended Event vs Profiler Trace RE: Extended Event vs Profiler Trace

  • June 22, 2016 at 9:38 am

    #1886320

    GilaMonster (6/22/2016)

    MadAdmin (6/22/2016)

    Cos the plan cache is there, juicy enough to eat, with all the info you need in one crispy query.

    His event is for actual execution plans (plans with the run-time data in them), which can't be got from the plan cache. Plans retrieved from cache only have estimated values.

    Ah.

    Lesson learnt.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]