• GilaMonster (5/5/2016)


    I'd recommend extended events on 2012. Add in the QueryHash column and the aggregation is trivial to do in T-SQL, no need for string comparisons for ad-hoc queries any longer.

    XEs still can't touch the amazing flexibility and power of Qure though, at least not any tool I have seen (and certainly not as nicely done as Qure by using TSQL). Slice and dice and filtering and ordering in a GUI. You can see total or average work done and ALSO drill down to see the actual parameters called - still aggregated by parameter set. Oh AND you can do a comparative analysis where you fix stuff and capture another workload and it will automatically tie together before and after runs. Nothing else comes close, IMHO.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service