Monitoring Computer Resource Utilization during SSIS Packages execution - Please help RRS feed

  • Question

  • Hi,
         In our Production server, lot of Pakcages/Cubes are running 24/7. Now, my assignment is to find out CRU (Computer Resource Utilization) of the server, such as which package and which task of the package is running for more time, which one is taking much memory and all related details.
     I guess we can get this from Control Panel > Performace and Monitoring > Administrative Tools >
       Using this I am planning to create a batch file which will be sceduled for every 1 hour.

    I really appreciate if you guys give inputs on the appraoches for capturing those utilization and after that what can we do with those details like optimization and other stuffs?

    Thanks in advance!!!

    Thursday, September 8, 2011 5:17 AM


All replies