topic Re: Database Server Monitoring in Splunk AppDynamics

Database Server Monitoring

Ahmedkhalil — Sat, 15 Sep 2018 18:58:53 GMT

Dears,

I would like to know which is a better approach to have Monitor Database Server Metrics using hardware monitoring feature in Database Agent or install Server Visibility on Database Server

Re: Database Server Monitoring

Michael_Horstma — Mon, 17 Sep 2018 22:49:45 GMT

The database monitoring agent would provide much more granular details not only about server hardware usage but about that usage specific to individual databases, procedures, queries, and granular comparison data.

Server Visbility would not provide that without adding several Performance Counters and even then you would never truly know what queries were causing you the most resource usage pain without a lot of time comparing with your database analysis toolset.

Edit: This is also something to consider from the standpoint of target audience. If you have a group that is monitoring overall server health they may not care about the specific metrics by query. In the event that you wanted to monitor overall server health the Server Visibility agent is better suited to present OS-critical metrics to evaluate health by. In the event you are concerned with Root Cause regarding the execution and operation of SQL, then database monitoring is more aptly suited to your needs.

It is my opinion however, that there are specific needs for each agent so I would advise if the budget and hardware allows for you to implement both where you are able.

Re: Database Server Monitoring

Ahmedkhalil — Thu, 20 Sep 2018 19:59:34 GMT

so at the end it's license point of view if i have server visibility license it will be nice to monitor the server using server visibility module , if not then Remote hardware monitoring of database agent will provide me with basic info that i need to troubleshoot issue