Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Costly update trigger -70,000,000 logical reads for 30,000 rows updated! RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

  • February 2, 2009 at 4:24 am

    #936331

    GilaMonster (2/1/2009)

    RBarryYoung (2/1/2009)

    But Marios should be able to get the Actual from Profiler or tracing, right?

    Yes, absolutely. Providing he traces the correct event. I seem to recall there are about 6 events relating to the exec plan and I can't recall offhand which produces what. BoL should say.

    Looks like running a trace will get me what I'm looking for, ie. the actual exec plan.

    I will do so and post my findings.

    Thanks guys!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]