1

I want to monitor the performance of each component of dataflow of SSIS packages is this possible and how to do it. I have used the SSIS pipeline counters in the monitor performance but it provides the total amount, not in detail. I am using the SSMS 2016 and Windows server 2016. I cannot install any application on the machine, I do not have access to the code of the SSIS just the SSMS.

Improve this question
2
  • 1
    Are you able to view the built-in reports in SQL Server Management Studio, such as the All Executions report or the Integration Services Dashboard?
    – Antoine Hernandez
    Commented Oct 26, 2021 at 8:47
  • @AntoineHernandez yes I can ,
    – Alloylo
    Commented Oct 26, 2021 at 8:55

1 Answer 1

Reset to default
0

By default, when you run an SSIS package that exists in the SSISDB, it will run at logging level Basic That captures information about the execution at the task level - how long, disposition, etc.

To get component level data, then you're going to need to change the logging level to Performance which will then capture details at the Component level (and Task level). As Koen's article on mssqltips notes, you will lose the summary data Component X wrote YYY rows switching to this but you will gain the statistics you are looking for.

If you're on 2016+, then you can define your own logging levels which would allow you to fine tune the specific data you want your logging level to capture.

Either way, now that you know you want to use a different logging level from the default, when you invoke your SSIS Package (either right click and run or from within a job), you'll need to specify that this package should use Performance/MyCustomLoggingLevel instead of Basic in the resulting GUI.

Reading material

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.