Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL Server DB Agent stops reporting data to controller

MSSQL Server DB Agent stops reporting data to controller

Hi,

 

I am having an issue with the mssql dbagent, it stops reporting the data after about 10 mins of starting/restarting it. But the controller shows the dbagent is active and it only reports shows the time spent yellow line, rest all data is blank.

 

I could not find any error as well in the logs as seen below. In the task processor I see it is using about 170 mb memory only.

 

[DBAgent-1] 20 Jul 2018 11:06:04,667 INFO Agent - Agent Install Directory [C:\dbagent-4.4.3.536]
[DBAgent-1] 20 Jul 2018 11:06:04,667 INFO Agent - Using Agent Version [Database Agent v4.4.3.0 GA Build Date 2018-04-26]
[DBAgent-1] 20 Jul 2018 11:06:04,668 INFO Agent - JVM Runtime:
java.home=C:\Program Files\Java\jre1.8.0_171
java.vm.vendor=Oracle Corporation
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.runtime.version=1.8.0_171-b11
java.io.tmpdir=C:\Users\user\AppData\Local\Temp\
user.language=en
user.country=SG
user.variant=
Default locale=en_SG
[DBAgent-1] 20 Jul 2018 11:06:04,672 INFO Agent - OS Runtime:
os.name=Windows 8.1
os.arch=amd64
os.version=6.3
user.name=user
user.home=C:\Users\user
user.dir=C:\Users\user
[DBAgent-1] 20 Jul 2018 11:06:04,675 INFO Agent - JVM Args :
[DBAgent-1] 20 Jul 2018 11:06:04,675 INFO Agent - DB Collector Agent is resolving bootstrap info....
[DBAgent-1] 20 Jul 2018 11:06:04,680 INFO AgentUtil - Default Host Identifier Resolver using host name for unique host identifier [PRO4]
[DBAgent-1] 20 Jul 2018 11:06:04,713 INFO AgentUtil - Default IP Address Resolver found IP addresses [[192.0.0.11, fe80:0:0:0:301e:4bfd:fef6:93d5%wlan0, fe80:0:0:0:8be:4e30:95f6:280e%wlan1, fe80:0:0:0:a5a2:bf63:6c8c:7c2f%eth2, 2002:c000:b:0:0:0:c000:b]]
[DBAgent-1] 20 Jul 2018 11:06:04,715 INFO AgentUtil - Full Agent Registration Info Resolver found system property [appdynamics.agent.applicationName] for application name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,716 INFO AgentUtil - Full Agent Registration Info Resolver found system property [appdynamics.agent.tierName] for tier name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,717 INFO AgentUtil - Full Agent Registration Info Resolver found system property [appdynamics.agent.nodeName] for node name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,720 INFO AgentUtil - Full Agent Registration Info Resolver using selfService [false]
[DBAgent-1] 20 Jul 2018 11:06:04,724 INFO AgentUtil - Full Agent Registration Info Resolver using application name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,726 INFO AgentUtil - Full Agent Registration Info Resolver using tier name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,726 INFO AgentUtil - Full Agent Registration Info Resolver using node name [Database Monitoring]
[DBAgent-1] 20 Jul 2018 11:06:04,731 INFO AgentUtil - XML Controller Info Resolver found controller host [data201807182005127.saas.appdynamics.com]
[DBAgent-1] 20 Jul 2018 11:06:04,731 INFO AgentUtil - XML Controller Info Resolver found controller port [443]
[DBAgent-1] 20 Jul 2018 11:06:04,735 INFO AgentUtil - XML Agent Account Info Resolver using account name [data201807182005127]
[DBAgent-1] 20 Jul 2018 11:06:04,736 INFO AgentUtil - XML Agent Account Info Resolver using account access key [jcsc8090qqwl]
[DBAgent-1] 20 Jul 2018 11:06:04,737 INFO AgentUtil - Keystore file C:\dbagent-4.4.3.536\conf\cacerts.jks was not found
[DBAgent-1] 20 Jul 2018 11:06:04,751 INFO Agent - DB Collector Agent resolved bootstrap info!
[DBAgent-1] 20 Jul 2018 11:06:04,755 INFO Agent - Started [DB Collector Agent] Schedulers
[DBAgent-1] 20 Jul 2018 11:06:04,756 INFO Agent - Scheduling DB Collector Agent Registration ....
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,758 INFO RegistrationChannel - Controller host [data201807182005127.saas.appdynamics.com]; Controller port [443]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,759 INFO RegistrationChannel - setting agent hostname [XXXXXXXXXXXXXXX\sqlexpress,2222]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,760 INFO RegistrationChannel - setting agent version [Database Agent v4.4.3.0 GA Build Date 2018-04-26]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,761 INFO RegistrationChannel - setting agent properties [{dbagent-name=Default Database Agent}]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,762 INFO RegistrationChannel - setting agent install dir [C:\dbagent-4.4.3.536]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,762 INFO RegistrationChannel - setting agent type [DB_COLLECTOR]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,763 INFO RegistrationChannel - setting agent application [Database Monitoring]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,765 INFO RegistrationChannel - setting agent tier name [dbmon:631]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,766 INFO RegistrationChannel - setting agent node name [dbmon:631|host:XXXXXXXXXXXXX\sqlexpress,2222|port:2222]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:04,767 INFO RegistrationChannel - Sending Registration request
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,254 INFO RegistrationChannel - Auto agent registration attempted: Application Name [Database Monitoring] Component Name [dbmon:631] Node Name [dbmon:631|host:XXXXXXXXXXXXX\sqlexpress,2222|port:2222]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,255 INFO RegistrationChannel - Auto agent registration SUCCEEDED!
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,256 INFO AgentRegistrationTask - Registered collector agent with machine ID [6848193]
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,257 INFO Agent - Starting DB Collector Agent....
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,258 INFO Agent - Configuration manager successfully configured
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,260 INFO EventService - Event Generation Service is : enabled
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,261 INFO MetricService - Metric Service is : [enabled].
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,261 INFO MetricService - Metric Generation Service is : enabled
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,323 INFO DBAgentMonitor - DBAgentMonitor started
[<StagingDB>-Scheduler-1] 20 Jul 2018 11:06:05,323 INFO Agent - Started DB Collector Agent successfully
[Entity-Registration-Scheduler-1] 20 Jul 2018 11:06:15,309 INFO SystemAgentTransientEventChannel - Full certificate chain validation performed using default certificate file
[<StagingDB>-Monitor-Scheduler-1] 20 Jul 2018 11:06:35,725 INFO SystemAgentTransientEventChannel - Full certificate chain validation performed using default certificate file
[AD Thread-Metric Reporter1] 20 Jul 2018 11:06:55,272 INFO SystemAgentTransientEventChannel - Full certificate chain validation performed using default certificate file
[Event-Uploader-Scheduler-1] 20 Jul 2018 11:07:15,700 INFO SystemAgentTransientEventChannel - Full certificate chain validation performed using default certificate file
[DBAgent-1] 20 Jul 2018 11:26:00,457 INFO SystemAgentTransientEventChannel - Full certificate chain validation performed using default certificate file 

 

Can some one help please.

 

Thanks,

Lokesh

MSSQL Server DB Agent stops reporting data to controller