cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SolarWinds NetFlow Traffic Analyzer Database

SolarWinds NetFlow Traffic Analyzer Database

This template reports database statistics gathered about the Orion database by SolarWinds NetFlow Traffic Analyzer (NTA). To learn about using NTA, see the NTA Administrator Guide.

In SAM 2019.4, this template was updated as follows:

  • The Number of Details Table component was removed because it is now obsolete.
  • Internal code was updated to support template localization in future releases.
  • The query for the "Number of CBQoS Interfaces not Receiving Data" component was updated due to database changes.

Here is the original query:

Declare @threshold int;

Declare @CBQoSint int;

Set @threshold = 2; --minutes

select @CBQoSint = value

from NetFlowGlobalSettings

where KeyName='CBQoSPollingInterval';

select count(*) as "Receiving CBQoS interfaces"

from NetFlowSources

where cbQoSEnabled=1 and datediff(minute, cbQoSLastTime, dateadd(second, -@CBQoSint, getdate())) > @threshold

Here is the updated query:

Declare @threshold int;

Declare @CBQoSint int;

Set @threshold = 2; --minutes
SELECT @CBQoSint = CurrentValue

from Settings

where SettingID='CBQoS_Polling_Interval';

select count(*) as "Receiving CBQoS interfaces"

from Netflow_AllNetFlowSources

where cbQoSEnabled=1 and datediff(minute, cbQoSLastTime, dateadd(second, -@CBQoSint, getdate())) > @threshold

Click here to learn about prerequisites and individual component monitors in this template, as included in the SAM Template Reference. To learn about importing this updated template into a pre-2019.4 SAM installation, see Import and export SAM templates.

Prerequisites: SolarWinds NTA is installed and licensed in your environment.

Credentials: SQL Server user name and password.

Monitored Components

Status of NetFlow maintenance

This monitor checks to make sure maintenance is running properly. If the NetFlow Traffic Analyzer maintenance is functioning properly, this component will return a value of zero. If the returned value is greater than zero, NTA Maintenance is not performing properly which can lead to performance issues. If this is the case, run NTA Database Maintenance manually. (This application can be found in the SolarWinds directory). If the value returned is still greater than zero, contact SolarWinds support.

Number of NetFlow Interfaces Receiving Data

This monitor returns the number of NetFlow interfaces that have received data within two minutes. If this counter is consistently zero, problems with receiving this information exists.
Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Number of CBQoS Interfaces Receiving Data

This monitor returns the number of CBQoS interfaces that received data within two minutes. If this counter is consistently zero, problems with receiving this information exists.
Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Number of NetFlow Interfaces not Receiving Data

This monitor returns the number of NetFlow interfaces which should, but have not yet, received data within two minutes. The value returned should be as low as possible. If the returned value is greater than zero, the flow is not received even though the interfaces are configured to receive this type of flow. This could be an indication of an improperly configured switch. If this is the case, ensure that the switch exports a flow for that interface or disable the interface in NetFlow Sources.

Number of CBQoS Interfaces not Receiving Data

This monitor returns the number of CBQoS interfaces which should, but have not yet, received data within two minutes. The returned value should be as low as possible. If the returned value is greater than zero, a flow is not received even though the interfaces are configured to receive this type of flow. This could be an indication of an improperly configured switch. If this is the case, ensure that switch exports a flow for that interface or disable the interface in NetFlow Sources.

NetFlow Service Status

This monitor returns the running state of the NetFlow service by comparing the current time with the KeepAlive timestamp. If the difference is greater than 15 minutes, a zero value will be returned, indicating a problem with the service status; otherwise, a value of one is returned. If this is the case, verify the NTA service is running properly on the server. If there are persistent problems with this service, contact SolarWinds support.
Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

High Priority Queue Addresses that are not Processed

This monitor returns the number of addresses in the high priority queue that are not processed but should be processed. The returned value should be near or at zero. If the value fails to drop to zero, this means DNS server is not able to process all of the incoming IP addresses. If this is the case, adjust your DNS server to process more requests per second, or switch DNS resolving to On Demand. For more information, refer to the APM Administrator Guide. This counter will function only when the DNS resolution is set to "persistent."

Low Priority Queue Addresses that are not Processed

This monitor returns the number of addresses in the low priority queue that are not processed but should be processed. The returned value should be near or at zero. This queue contains IP addresses which were not resolved and should be resolved and is processed when the first queue is empty. If the returned value continues to grow, it can be an indication of an improperly configured DNS which is not able to resolve IP addresses. This counter will function only when the DNS resolution is set to "persistent."

Number of records in NTA Summary table 1

This monitor returns the number of records in NetFlowSummary1 table. This value should be around the same value for each summary table. Compare this monitor with Number of records in NTA Summary table 2 and Number of records in NTA Summary table 3 monitors. If the value is growing daily, this is an indication that the NTA Database Maintenance is not working properly. If this is the case, run NTA Database Maintenance manually. (This application can be found in the SolarWinds directory). If the value returned is still greater than zero, contact SolarWinds support.

Note: This query uses a great deal of resources and should be executed just once per day. By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Number of records in NTA Summary table 2

This monitor returns the number of records in NetFlowSummary1 table. This value should be around the same value for each summary table. Compare this monitor with Number of records in NTA Summary table 1 and Number of records in NTA Summary table 3 monitors. If the value is growing daily, this is an indication that the NTA Database Maintenance is not working properly. If this is the case, run NTA Database Maintenance manually. (This application can be found in the SolarWinds directory). If the value returned is still greater than zero, contact SolarWinds support.

Note: This query uses a great deal of resources and should be executed just once per day. By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Number of records in NTA Summary table 3

This monitor returns the number of records in NetFlowSummary1 table. This value should be around the same value for each summary table. Compare this monitor with Number of records in NTA Summary table 1 and Number of records in NTA Summary table 2 monitors. If the value is growing daily, this is an indication that the NTA Database Maintenance is not working properly. If this is the case, run NTA Database Maintenance manually. (This application can be found in the SolarWinds directory). If the value returned is still greater than zero, contact SolarWinds support.

Note: This query uses a great deal of resources and should be executed just once per day. By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Number of polling Huawei devices

This monitor returns the number of Huawei devices with interface mapping that are enabled and working properly. If you do not have any Huawei devices, the value returned should be zero. If you have devices with interface mapping enabled and the returned value is zero, interface mapping may not be working properly.
Note: By default, this component monitor is disabled and should only be enabled for troubleshooting purposes.

Updated on 11/18/19 to remove (1) from template filename.

Labels (1)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎11-15-2011 12:00 AM