Fluke Computer Accessories Performance Tuning, Disk Speed, Query Size, Database Server Settings

Page 58

User’s Guide – version 3.5

NetFlow Tracker

Performance Tuning

There are several factors that influence how quickly a given report is generated:

Disk Speed

The first step in creating a report is reading the raw data from disk; increasing the speed of the disk subsystem will make reporting faster. A high-quality server RAID card running a striped pattern such as RAID 5 over fast disks is recommended; more disks will make the array faster. In addition, extra RAM can be used by the operating system for a disk cache.

Query Size

The amount of raw data that needs to be read from disk is dependent on the number of source devices selected, the data load of those devices and the amount of time selected. Indexes are not used due to the increase in database size they would cause, so any other filters have no impact on the amount of raw data read from the disk.

If possible, avoid reporting over multiple devices and over long periods of time. It is likely that a report over multiple devices will account for some traffic multiple times.

Database Server Settings

The database server used by NetFlow Tracker can be tuned to improve query speed if you have a fast disk subsystem or lots of RAM, or both. See Database Settings for details.

58

Image 58
Contents NetFlow Tracker Contents LONG-TERM Reports Appendix 2 CSV File Format Software License Agreement Grant of Licence and Payment of FeesCopyright Customer Remedies Confidential Information and Security User’s Guide version NetFlow Tracker Definitions Undertakings by You Support ServicesSupport Charges Supplier’s UndertakingsIntellectual Property Rights Limitation of Liability and indemnityTermination Confidential Information and Security MiscellaneousSupport Hours Exceptions to Support ServicesResponse Times Features and Benefits What is NetFlow?What is NetFlow Tracker? IntroductionUser’s Guide version NetFlow Tracker Minimum System Requirements InstallationPre-installation Checks Operating System SupportInstallation on Microsoft Windows Installation on Linux Post-installation Tasks Configure your routers and switches Set up Snmp community stringsSet up web front-end security Add listener portsUsing NetFlow Tracker Device traffic meters InterfacesChart legend Working with ChartsChanging the displayed chart Per-AS dataZooming View a standard chart as a pie chartView a standard chart as a tabular report Zooming outPrint the chart Alter the filter applied to a standard chartExport a chart to another application Open the chart in a new windowWorking with Pie Charts Working with Tabular ReportsSort a tabular report Examine a single rowAddress Reports Report TemplatesSession Reports QoS Reports Network ReportsTraffic Identification Reports Creating Filtered ReportsInterface Reports Other ReportsSource data Report templateSample size Start timeInterface Time zoneSource device Out interfaceDest port ProtocolSource port Src/dest portSource AS DiffServTraffic class Dest ASPer-device and Per-interface Long-term Reports Long-term ReportsDevices and Interfaces Filter EditorUser’s Guide version NetFlow Tracker Reports General Form Report URL FormatReport Format Parameters 0025 00230024 0026Number ChartPie True128 FeaturesSections 256Time Range Parameters Day MillisHour WeekTime range will extend for this number of units Calendar-based advancedApplying a time-of-day mask to the time range HHmmDay1-day2/time1-time2 100 110105 113140 115120 125Minute 285300 DailyFilter Parameters Addr1-addr2 NamePort1-port2 Port1-port2/name Port/namePort/number Port1-port2/numberPrec%20tos PrecTos CodeAddr/mask MaskSecurity Parameters PasswordUsername Secret Management Portal Access Control ParametersNull VPN Out VPN Filter Editor button, if applicable Chart scrollbarChart selection headers Refresh and Resolve All buttons, if applicableDisk Speed Performance TuningDatabase Server Settings Query SizeLicensing Configuration GuideSnmp Settings Listener PortsDevice Settings Device SettingsDevice List Sampled Data Scaling Security Settings VPNsHttp//tracker1/report.jsp?portalsecret=secret&aclif= Management Portal SettingsHttp//proxy/tracker1/report1 Http//proxy/tracker1/report.jsp?portalacl=RewriteRule /tracker1/.*$ http//1.2.3.4/$1 P,L,QSA Using Apache as a Portal ServerRewriteEngine On ProxyPassReverse /tracker1/ http//1.2.3.4General Settings Report SettingsReal-time Reports Saved Filters Scheduled ReportsLong-term Reports Executive Reports Span class=repdesctextTest/span Content Nelements=5 and chartWidth=400Sub-reports User’s Guide version NetFlow Tracker IP Application Names Hostname Resolution SettingsDiffServ Names AS Names Database SettingsSubnet Names Backup Archiving Memory SettingsPerformance Counters Ignored Flows NetFlow Data ReceivedTraffic Described Unprocessed FlowsetsAbout No In InterfaceIp cef Appendix 1 Device ConfigurationEnabling Netflow Export on an IOS Device Ip flow-export destination addressShow ip flow export Ip flow-cache timeout activeIp flow-cache timeout inactive Show ip cache flow Show ip cache verbose flowMls nde sender version Ip route-cache flow infer-fieldsMls netflow Mls aging longUser’s Guide version NetFlow Tracker Set system name name Set mls bridged-flow-statistics enable vlanlistSet mls nde enable Set mls nde addressFlow-sampler-map allflows mode random one-out-of 1 exit Enabling Flow Detail Records on a Packeteer DeviceEnabling NetFlow on an Enterasys Device Appendix 2 CSV File Format Chart CSV formatPie chart CSV format Tabular report CSV formatAppendix 3 XML Format Chart XML formatPie chart XML format Tabular report XML formatAppendix 4 Third Party Software Components JspSmartUpload Quartz