DB Agent - Monitoring all instances Vs Specific DB instances

[rravindran]

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 ? 

[Cody.Naumann]

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

[Christine.Chang]

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. 

[Brayan.Rodriguez]

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

[Christine.Chang · Accepted solution]

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

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