Hi, Though we do not have any reference of DBAgent overhead , but it could be very minimal in terms of either cpu or memory. Weight %, The percentage of the total time consumed by the query for the selected time duration. The reason for currentOp() command showing top because it will be executed by the agent at every minute to get the current statistics for the running queries. It could be the case that there is not much activity on the mongo caused in showing it as top query. So, as far as I know there should not be much impact on the database for execution of this query by the agent.  You can further drill down down to the queries windows sections to see the complete details about the query execution. https://docs.appdynamics.com/display/PRO44/Database+Query+Details+Window Please do let us know if there are any further clarifications required. Regards, Anka ... View more

Hi Indrajit, Can you please share the complete db agent logs for quick review once? I hope, you might have gone through the following document on the permissions side for ms sql server monitoring. https://docs.appdynamics.com/display/PRO43/Configure+Microsoft+SQL+Server+Collectors I would suggest you use host/port configuration instead custom jdbc url on the collector configuration for ms sql. Regards, Anka ... View more

Hi John, Please comment and add the AGENT_OPTIONS sections like below.  # commenting below # AGENT_OPTIONS = "" # Adding the unique host id of the dbagent installed machine AGENT_OPTIONS="appdynamics.agent.uniqueHostId='DBAgent-Server-Name'" You can also add the properties as listed document based on the need. https://docs.appdynamics.com/display/PRO43/Database+Agent+Configuration+Properties Save and Now check the behavior. Regards, Anka ... View more