Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 1525)

1478 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
SAN end-to-end monitoring
43
• FCIP_STATS_2HOUR_INFO
• FCIP_STATS_1DAY_INFO
The following EE_MONITOR_STATS and TE_PORT_STATS view names are used to extract data
similar to the 11.3.0 database schema from the server with the version greater than or equal to
12.0.0. Refer to
Appendix I, “Database Fields” for view definitions.
How to extract performance statistics data from the database
Following are the steps used to extract any PM data from the database:
• Check PM_DATA_COLLECTOR table, to identify the collector database ID
• Check PM_COLLECTOR_TIME_SERIES_MAPPING table, to find the mapping table that contains
the required data
• Construct the select query using the mapping table
Execute the following query to extract the FCIP tunnel statistics for last 1 day
Select * from TIME_SERIES_DATA_2 where COLLECTOR_ID = 13;
Execute the following query to extract the FC port statistics for last 3 days
Select * from TIME_SERIES_DATA_1_30MIN where COLLECTOR_ID = 11;
Execute the following query to extract the TE port statistics for last 30 days
Select * from TIME_SERIES_DATA_1_2HOUR where COLLECTOR_ID = 12;
Execute the following query to extract all SAN product statistics for last 730 days
select * from TIME_SERIES_DATA_2_1DAY where COLLECTOR_ID = 15;
SAN end-to-end monitoring
Procedures in this section pertain to end-to-end monitoring using the legacy End-to-End Monitor
feature instead of using Flow Vision to create end-to-end monitors.
For systems using Fabric OS version 7.2 or later, when you select a device or device port, and then
select Monitor > Performance > End-to-End Monitors, a message displays that you can use Flow
Vision to provide End-to-End monitoring. You have these options:
• To use Flow Vision, delete existing monitors, then use the Add Flow Definition dialog box to
define an initiator and target port pair for monitoring. Refer to
Chapter 44, “Flow Vision” for
more information.
• Clicking OK, opens the legacy Set End-To-End Monitors dialog box.To use the legacy End-to-End
Monitor feature, you must deactivate existing flows defined for the switch for Flow Vision.
Refer to the following important notes when using this feature:
• For systems using Fabric OS version 7.2 or later, you can create end-to-end monitors using the
Flow Vision feature. Refer to
Chapter 44, “Flow Vision” for details.
• End-to-end monitoring requires a Fabric OS device.
• An end-to-end monitor and a Top Talker monitor cannot be configured on the same fabric or
external F_Port application-specific integrated circuit (ASIC). You must delete the Top Talker
monitor before you configure the end-to-end monitor.