Controller (SaaS, On Premise)

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Instance Configuration

Highlighted

SQL Server Instance Configuration

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

SQL Server Instance Configuration
5 REPLIES 5
Highlighted
Community Manager

Re: SQL Server Instance Configuration

Hi Shane,

 

Does this AppD Docs page help? 


Thanks,
Ryan, 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.
Highlighted

Re: SQL Server Instance Configuration

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?

Highlighted
Community Manager

Re: SQL Server Instance Configuration

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, 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.
Highlighted
Architect

Re: SQL Server Instance Configuration

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

 





Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Highlighted

Re: SQL Server Instance Configuration

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.