Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > CustomPollerStatistics Tables are very large

CustomPollerStatistics Tables are very large

Overview

The CustomPollerStatistcs tables are very large and this is impacting Database Query Performance or our Database Maintenance. 

 

dbo.CustomPollerStatistics_Detail

dbo.CustomPollerStatistics_Hourly

dbo.CustomPollerStatistics_Daily

Environment

  • All versions of NPM

 

Cause 

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.

 

Resolution

  1. Run the following SQL query to identify the pollers with the most data:


    select count(*) as total,  custompollerassignmentid from custompollerstatistics_detail
    group by custompollerassignmentid
    order by total desc

     

    Total CustomPollerAssignmentID
    1070045661 77AFC200-EC56-4F52-9C77-CB5EFE4BA697
    100024 54FEA200-AB56-4B52-9A53-CB5EFE4BA697
    11224 2548AB56-4B52-9A53-CB5EFE4BA697
    322 3AE542D3-2A56-8A53-CB5EFE4BA697


     

  2. Run the following query to find which nodes are assigned to that poller:

    Select * from CustomPollerAssignment
    Where CustomPollerASsignmentID={ID}

     
    CustomPollerAssignmnetID AssignmentName CustomPollerID NodeID
    9DA098CC-1BED-4DBE-9D89-08856BA6AB3B ciscoEnvMonTemperatureStatusValue on Bas-2621.lab.tex 61A9A17E-29FC-4077-9367-A3114B48E23B 59

     
  3. Disable Historical Data on that Poller or unassign that poller. 

 

 

 

Last modified

Tags

Classifications

Public