topic Re: DB Agent - Monitoring all instances Vs Specific DB instances in Splunk AppDynamics

DB Agent - Monitoring all instances Vs Specific DB instances

CommunityUser — Wed, 08 Mar 2017 23:50:49 GMT

When we configure DB Agent to monitor an SQL Server, where / How we can filer only those specific instances which we are interested in monitoring ?

I guess, OOTB we will monitor all the instances in the server, right ?

Re: DB Agent - Monitoring all instances Vs Specific DB instances

CommunityUser — Mon, 13 Mar 2017 22:40:07 GMT

Hi there,

I think what you're looking to do is create a database collection -- is that correct? https://docs.appdynamics.com/display/PRO42/Configure+Database+Collectors

Cody

Re: DB Agent - Monitoring all instances Vs Specific DB instances

CommunityUser — Mon, 08 May 2017 17:14:54 GMT

That is correct, OOTB we will monitor all the instances in the server. Currently, there is no filter option for specifying the SQL Server instances to monitor.

Re: DB Agent - Monitoring all instances Vs Specific DB instances

Brayan_Rodrigue — Wed, 24 May 2017 00:32:19 GMT

There are some config for monitor only specific instances of the same database?

Re: DB Agent - Monitoring all instances Vs Specific DB instances

CommunityUser — Wed, 24 May 2017 17:47:43 GMT

Please disregard my previous comment. You can use a custom jdbc string to monitor any specific MSSQL Server instance.

jdbc:sqlserver://[serverName[\instanceName][:portNumber]]