topic Re: SQL Server Integration services in Splunk AppDynamics

SQL Server Integration services

Dean_Moses — Tue, 27 Mar 2018 11:28:54 GMT

Hi There! I have searched and Googled, hoping for the best 😉

Is there perhaps an extension or method to monitor SSIS in AppD? I've searched and googled but no joy.

Re: SQL Server Integration services

deepanshu_arya — Wed, 02 May 2018 06:53:18 GMT

Hi Experts,

I am also looking for same solution so please suggest if this can be done.

SSIS monitoring with Appdynamics.

Regards,

Deepanshu

Re: SQL Server Integration services

CommunityUser — Wed, 16 Oct 2019 13:22:48 GMT

Was wondeing the same!!!??? Did you get anywhere with this?

Nick

Re: SQL Server Integration services

Priya_Darsini1 — Thu, 19 Aug 2021 11:53:45 GMT

I am looking for the same. Any help on SSIS instrumentation. Can .Net agent be of help.

Re: SQL Server Integration services

iamryan — Mon, 30 Aug 2021 17:09:07 GMT

Hello,

Since there was no reply about this working. I would suggest creating an Idea Exchange post about this.

The Idea Exchange is where customers can share feature request ideas.

Please read the submission guidelinesIdea Exchange Submission Guidelines

https://community.appdynamics.com/t5/Idea-Exchange/idb-p/ideas

Note: Idea Exchange is not accessible to AppD Trial or Lite users

Re: SQL Server Integration services

Silky_Ajmera1 — Wed, 29 Mar 2023 11:23:05 GMT

Hello,

Did anyone find a solution or this ?

Re: SQL Server Integration services

Satbir_Singh — Wed, 29 Mar 2023 16:04:41 GMT

SSIS, Sql Server Integration Service is running in MsDtsSrvr.exe. This is a managed executable and .net agent can load into the process, but most of the work is done via unmanaged COM components and no useful transactional data can be captured.
What we can do is capture process level metrics and metrics exposed via windows performance counters. The best you can do for SSIS is to monitor exposed performance counters.

You can check the following link for details about exposed counters:
https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters