Applications Systems
Unknown Applications and Unexpected Website Behavior: Over Polling SAM Component Monitors
Known over polling symptoms: Applications are unknown, Applications are stuck in initial poll in progress, Applications are not polling, Website inconsistencies, Web pages are slow to load, Web pages do not load or time out - Unexpected Website Errors, Gaps in metrics or charts, Nodes, volumes, applications, not polling at expected intervals, Inability to assign application templates to nodes, Inability to delete applications, Alerts not firing, Report data is incorrect or outdated. Unable to start polling.
First published date
Last published date
Overview
This article has a high rate of resolution to such statements:
"My system has been working for many months, why all of a sudden is there an issue?"
"My polling rate has not exceeded 100%, how could I be affected by over polling SAM components?"
Over polling SAM component monitors are a common cause of many different issues. Overloading the polling engine(s) can cause a wide variety of issues, many of the symptoms fall under the categories of unexpected website behavior and inconsistent polling for monitored objects (nodes/agents/applications/etc).
All known over polling symptoms:
- Application issues
- Applications are unknown
- Applications are not polling
- Applications are stuck in initial poll in progress
- Applications display unable to start polling
- Gaps in metrics
- Not able to assign new applications to nodes
- Not able to delete applications from nodes
- Node issues
- Nodes are not polling
- Nodes not polling at expected frequency (10min)
- Agents are failing to poll status [icmp & agent native status pollers]
- Other polled object issues
- Volumes not polling at expected frequencies
- Interfaces not polling at expected frequencies
- Website issues
- Inconsistent Website behavior
- Web pages are slow to load
- Web pages do not load or time out (receive: Unexpected Website Error)
- Report data is incorrect or outdated
- Gaps in various statistic charts
- Alerts not firing
- System issues
- SQLite collector queues filling up
Product section
Cause
Resolution
Please note the following for all scripts contained herein:
-- Scripts are not supported under any SolarWinds support program or service. -- Scripts are provided AS IS without warranty of any kind. SolarWinds further -- disclaims all warranties including, without limitation, any implied warranties -- of merchantability or of fitness for a particular purpose. The risk arising -- out of the use or performance of the scripts and documentation stays with you. -- In no event shall SolarWinds or anyone else involved in the creation, -- production, or delivery of the scripts be liable for any damages whatsoever -- (including, without limitation, damages for loss of business profits, business -- interruption, loss of business information, or other pecuniary loss) arising -- out of the use of or inability to use the scripts or documentation.
Managing Monitored Objects in the SolarWinds Platform
Ensure your system is up to the requirements of the Scalability Engine Guidelines for SolarWinds products. Over polling network elements or SolarWinds Platform agents have been known to have the same or similar effects as over polling SAM components.
Managing SAM Component Monitors
Reduce the number of components polled by each polling engine. Polling engines are designed to poll 40,000 components per polling engine. To check the monitored component count across all polling engines, open the web console and go to
With the release of SAM 2020.2, node-based licensing was introduced, allowing up to 40,000 components per polling engine. This is only supported on 2020.2 and above with node-based licensing. To determine which node-based license tier you will need, determine the number of unique servers that you currently have an application monitor assigned with the below query. The number returned by the query will be the minimum license tier you will need to convert to. Consider future expansion and plan ahead; you may need to round up when choosing the correct license tier. Check License tiers here.
SELECT COUNT(DISTINCT NodeID) FROM APM_Application
Typically, AppInsight applications are the cause of suddenly increased component counts. Specifically AppInsight for SQL - This application scales with the number of databases on the assigned SQL server instance. To ensure AppInsight is not set to assign via SolarWinds Platform Network Discoveries, follow these steps:
- Go to Settings > Network Discovery
- Select one of your discovery jobs and click edit.
- Go to the monitoring settings tab.
- If you have the option: "Automatically monitor based on my defined monitoring settings" selected then click "Define Monitoring Settings" (if you have manual discovery option selected then please disregard these steps).
- In the window that pops up go to the Applications tab.
- It is recommended to uncheck the AppInsight Applications from automatic monitoring. Otherwise it could apply unnecessary monitors across your environment.
Useful Queries
To determine which applications are consuming the largest number of monitored component count:Use this query if using Database Manager:
SELECT t.Name AS TemplateName, a.Name AS AppName, Count(ccs.ApplicationID) AS [Component Count], n.Caption AS [Node Name] FROM [dbo].[APM_CurrentComponentStatus] ccs JOIN [APM_Application] a ON ccs.ApplicationID = a.ID JOIN [Nodesdata] n ON a.NodeID = n.NodeID JOIN [APM_ApplicationTemplate] t ON a.TemplateID = t.ID GROUP BY t.Name, a.Name, n.Caption ORDER BY [Component Count] DESCUse this query if using SQL Server Management Studio:
SELECT ccs.ApplicationID, ap.Name AS [Application Name], t.Name AS [Template Name], Count(ccs.ApplicationID) AS [Component Count], node.Caption AS [Node Name], e.EngineID, e.ServerName AS [Polling Engine] FROM [dbo].[APM_CurrentComponentStatus] ccs JOIN [APM_Application] ap ON ccs.ApplicationID = ap.ID JOIN [Nodesdata] node ON ap.NodeID = node.NodeID JOIN [Engines] e ON node.EngineID = e.EngineID JOIN [APM_ApplicationTemplate] t ON t.ID = ap.TemplateID GROUP BY ap.Name, t.Name, ccs.ApplicationID, node.Caption, e.EngineID, e.ServerName ORDER BY [Component Count] DESC
How can I reduce or balance my component count per engine?
Make use of the two queries above. If you're a multi poller environment then you should use SQL Server Management Studio and run the second query which will display the assigned poller
- The nodes listed at the top of the query results are consuming the highest component count. Find a node consuming a high number of SAM components.
- Move the chosen node to a polling engine containing fewer components. Alternatively, if you find that this application monitor is not considered as useful or high priority as other applications, you may delete it through the console (Settings > All Settings > SAM Settings > manage assigned application monitors > select app > delete).
- Repeat Steps 1 and 2 until all polling engines have fewer than 48,000 components per polling engine (hint: refresh the 'Total elements per poller page' to see an updated count of SAM components per poller).
*Here are the Scalability engine guidelines listing 48,000 polling components as the recommended and supported limit per polling engine.