SSIS Logging: Difference between Basic and Performace Logging

• river1

  SSC-Insane

  Points: 24309

  More actions

  January 25, 2018 at 7:57 am

  #410106

  Dear all,

  In the past I was using basic logging in my SQL Jobs that runed the SSIS packages.

  With basic log I was getting more infromation that I needed (several events not necessary).

  For me I just wanted to know the errors and the warnings. Based on that I have changed my logging level from basic to None.

  None logs the errors and the (till the task level) but does not log the error description so udnefortunately I cannot use thislogging level.

  I have now changed from None to Performace and I am able to  receive the error description till task level as I wanted.

  I believe that logging  (using the non costum methodas) is progressing as:

  None  - > Performance -> Basic - > Verbose, etc..

  So, Performance logs less infromation then Basic.

  I was trying to unöderstand what is the exact diference between basic and performance but I am not able throguh the description in :

  https://docs.microsoft.com/en-us/sql/integration-services/performance/integration-services-ssis-logging

  Can someone help me understand?

  Thank you

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  January 25, 2018 at 1:27 pm

  #1977423

  Hi,

  Check this out - https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters and http://bidshelper.codeplex.com/wikipage?title=SSIS%20Performance%20Visualization&referringTitle=Home

• subramaniam.chandrasekar

  SSCarpal Tunnel

  Points: 4223

  More actions

  January 28, 2018 at 9:57 pm

  #1977646

  river1 - Thursday, January 25, 2018 7:57 AM

  Dear all,

  In the past I was using basic logging in my SQL Jobs that runed the SSIS packages.

  With basic log I was getting more infromation that I needed (several events not necessary).

  For me I just wanted to know the errors and the warnings. Based on that I have changed my logging level from basic to None.

  None logs the errors and the (till the task level) but does not log the error description so udnefortunately I cannot use thislogging level.

  I have now changed from None to Performace and I am able to  receive the error description till task level as I wanted.

  I believe that logging  (using the non costum methodas) is progressing as:

  None  - > Performance -> Basic - > Verbose, etc..

  So, Performance logs less infromation then Basic.

  I was trying to unöderstand what is the exact diference between basic and performance but I am not able throguh the description in :

  https://docs.microsoft.com/en-us/sql/integration-services/performance/integration-services-ssis-logging

  Can someone help me understand?

  Thank you

  Still I haven't implemented a practical demonstration on this area, I'll let you know once I've done a test implementation on all types.