Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
The CustomPollerStatistcs tables are very large and this is impacting Database Query Performance or our Database Maintenance.
The CustomPollerStatistics table stores historical data from Custom Pollers (Universal Device Pollers). A single tabular Poller is capable of returning 1000's of rows, this is likely the cause.
select count(*) as total, custompollerassignmentid from custompollerstatistics_detail
group by custompollerassignmentid
order by total desc
|9DA098CC-1BED-4DBE-9D89-08856BA6AB3B||ciscoEnvMonTemperatureStatusValue on Bas-2621.lab.tex||61A9A17E-29FC-4077-9367-A3114B48E23B||59|