Hi Meera,

AES is just a monitoring tool.Monitored node will send messages to AES node through SOAP call.It doesn't impact application performance.

Still as per my experience with different AES SRs ,please let me know

1.Are you using ssl enabled url to connect to AES?If yes then check ssl logs.Is there any issue with certificate.

2.Execute below query and share result with me.

select Expired."Table", Expired."Over Expire Date Count","Total Table"."Total Count" from (select 'Alerts' as "Table",count(*) as "Over Expire Date Count" 
from AESDATA.pegaam_alert where GeneratedDateTime < (SYSDATE - 15 ) union
select 'Exceptions',count(*) from AESDATA.pegaam_exception where GeneratedDateTime < (SYSDATE - 15 )union
select 'LogUsage',count(*) from AESDATA.pegaam_perf_stats where pxSnapshotTime < (SYSDATE - (30 + 1))union
select 'NodeStats',count(*) from AESDATA.pegaam_node_stats where SnapshotTime < (SYSDATE - (14 + 1))union
select 'IndicatorChange',count(*) from AESDATA.pegaam_ind_change where pxCreateDateTime < (SYSDATE - (14 + 1))union
select 'CriticalEvent',count(*) from AESDATA.pegaam_crit_event where EventDateTime < (SYSDATE - (14 + 1))union
select 'NodeHealth',count(*) from AESDATA.pegaam_node_health where pxCreateDateTime < (SYSDATE - (1 + 1))union
select 'Indicator',count(*) from AESDATA.pegaam_indicator where pxCreateDateTime < (SYSDATE - (1 + 1))union
select 'TopOffenders',count(*) from AESDATA.pegaam_topoffenders where pxCreateDateTime < (SYSDATE - (30 + 1))union
select 'Exception Work Items',count(*) from AESDATA.pegaam_exception_work where LastEvent < (SYSDATE - (31 + 1)) and pyStatusWork='Resolved-Not-Seen'union
select 'Action Work Items (Alerts)',count(*) from AESDATA.pegaam_action_work where LastEvent < (SYSDATE - (95 + 1)) and pyStatusWork='Resolved-Not-Seen'union
select 'DailyMetrics',count(*) from AESDATA.pegaam_dailymetrics where pxCreateDateTime < (SYSDATE - (30 + 1)) ) 
Expired 
inner Join 
(Select TC."Table", TC."Total Count"  from (select 'Alerts' as "Table",count(*) as "Total Count" from AESDATA.pegaam_alert union
select 'Exceptions',count(*) from AESDATA.pegaam_exception union
select 'LogUsage',count(*) from AESDATA.pegaam_perf_stats union
select 'NodeStats',count(*) from AESDATA.pegaam_node_stats union
select 'IndicatorChange',count(*) from AESDATA.pegaam_ind_change union
select 'CriticalEvent',count(*) from AESDATA.pegaam_crit_event union
select 'NodeHealth',count(*) from AESDATA.pegaam_node_health union
select 'Indicator',count(*) from AESDATA.pegaam_indicator union
select 'TopOffenders',count(*) from AESDATA.pegaam_topoffenders union
select 'Exception Work Items',count(*) from AESDATA.pegaam_exception_work union
select 'Action Work Items (Alerts)',count(*) from AESDATA.pegaam_action_work union
select 'DailyMetrics',count(*) from AESDATA.pegaam_dailymetrics ) TC ) "Total Table"
on
Expired."Table" = "Total Table"."Table" 
order by 1

If it doesn't run then Replace AESDATA with your schema name.

Thanks,

Abhinav