Post reply

SET STATISTICS equivalent

  • October 19, 2021 at 7:53 am

    #3941864

    Hello

    Is there an equivalent for monitoring things like IO, reads, writes, ... produced when running a data flow task in SSIS

    e.g. T-SQL INSERT INTO ... vs Data Flow From and To

     

    Thanks

     

     

    - Damian

  • October 19, 2021 at 1:45 pm

    #3941975

    Use Extended Events to capture the metrics. That's how I'd do it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • October 20, 2021 at 10:07 am

    #3942311

    Great, thanks Grant

    I will crack open Extended Events and see what results that brings

    - Damian

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

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