Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
01-31-2020 10:21 AM
I'm trying to find documentation that states how we setup the controller for Database monitoring when dealing with a SQL Server instance (myserver\myinstance). Does myserver\myinstance go into the hostname?
Thanks
02-03-2020 09:44 AM
Hi Shane,
Does this AppD Docs page help?
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
02-03-2020 09:47 AM
No. I've seen that link and it never talks about normal database instances. There are sub collectors but I don't want to monitor multiple instances. Just one named instance on a server that has others. I can create a JDBC connection string if needed but this seems like such a basic scenario that I shouldn't have to?
02-04-2020 01:11 PM
Hi Shane,
Thanks for letting me know. I'll see if I can find other documentation/posts. Would you expect to see that sort of information on that link I sent you or in a subsequent sub page?
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
02-06-2020 10:55 AM
If I understand your question correctly then what you'll want to do is install a Database Agent on your Controller (or some other place where your DB server can reach). You can find a diagram of how it works here: https://docs.appdynamics.com/display/PRO45/Overview+of+Database+Visibility
From there you can setup individual "collectors" inside the Controller GUI which essentially makes monitoring individual DBs agentless from a db server perspective. The notes on how to install the agent are here: https://docs.appdynamics.com/display/PRO45/Install+the+Database+Agent
and once you have it up and correct sa permissions you setup the collectors for each individual db here: https://docs.appdynamics.com/display/PRO45/Add+Database+Collectors
02-06-2020 01:42 PM
I've already completed all of the steps except the last one and I have read that documentation.
The problem is when you do your final step to setup the collector it wants a host name. If you have instances in SQL Server (for example myserver\myNamedInstance) then the host name ONLY gets you to the server. You still need to tell it what your named instance is and I don't see anything in the documentation that says how to do THAT.
11-11-2021 07:51 PM
Hi Team ,
Is this sorted ? Even in our environment we have a similar case and need to know how to provide Instance name for SQL server. Can you please help .
Thanks
11-15-2021 10:26 AM
Hi @Vishnu.Priya,
Others mentioned they were getting stuck even with the documentation. Can you help me point out what exact Doc is leaving this question unanswered? I'll share it with the Docs team to get it updated.
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
11-16-2021 12:53 AM - last edited on 11-16-2021 10:08 AM by Ryan.Paredez
Hi @Ryan.Paredez,
In Controller configuration, we have the option to enter Hostname or IP of DB server. I would like to know if we have an option to mention the instance name of the DB server which needs to be monitored.
For Example (MSSQLSERVER@Host1, SQLP01@Host1, SQLP02@Host1 ) when there are multiple instances can that be included too.
Thanks.
11-16-2021 10:12 AM
I unfortunately don't know the answer, but if you help me with what documentation is missing that information, I can get the process started to get it updated.
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form