SolarWinds NetFlow Traffic Analyzer Database

Version 1

    SolarWinds NetFlow Traffic Analyzer Database

    This template assesses the performance of a SolarWinds NetFlow Traffic Analyzer by retrieving performance data from the SolarWinds database.

    Prerequisites: None.

    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 Detail Tables

    This monitor returns the number of Detail Tables in the database, per node. Each node has a specific number of Detail Tables which can be changed in the NetFlow Settings. The default is four.

    If the number of Detail Tables per node exceeds the allowed maximum and continually grows, this could be an indication that there is a problem with the NTA service. If this is the case, verify that all services are running properly. If needed, run NTA Database Maintenance manually. (This application can be found in the SolarWinds directory). If the problem persists, contact SolarWinds Technical Support.

    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.

    [View:/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.38.96/APM_5F00_SolarWinds_5F00_NetFlow_5F00_Traffic_5F00_Analyzer_5F00_template_5F00_pack.pdf]