AppDynamics for Databases

2.9.x Documentation

On this page:

Watch the video:

Your Rating:
Results:
PatheticBadOKGoodOutstanding!
49 rates

From the NetApp infrastructure windows you can monitor NetApp controllers and view the database activity related to those controllers. You can configure notifications for performance metrics for all NetApp systems. For information on setting up a NetApp collector, see Collectors.

You access the NetApp infrastructure window from the Main menu.

The following help you understand the presentation of the NetApp Monitored Infrastructure information collected:

View Current Performance

The Current tab displays the current activity of the NetApp controller.  It provides some basic information on the filer and minimum (Min), average (Avg), maximum (Max), standard deviation (Std Dev) values for a variety of metrics collected.  It shows both the current values and a graph of the historical values for each of these metrics. The contents of the History graph commence with the selection of the Current tab, which displays by default when you select the NetApp controller from the Main Menu. There are two reports are available here, NetApp Storage Report and NetApp Time Series Comparison Report

The metrics collected and presented here are:

  • CPU: The percentage of all CPU activity that is consumed by the NetApp controller.
  • System Avg Latency: The average time in milliseconds, required to service a request.
  • NFS: The number of I/O operations per second (IOPS) performed using the Network File System protocol (NFS).
  • CIFS: The number of IOPS performed using the Common Internet File System (CIFS) protocol.
  • FCP: The number of IOPS performed using the Fibre Channel Protocol (FCP).
  • ISCSI: The number of IOPS performed using the Internet Small Computer System Interface (ISCSI) protocol.
  • NET KB In: The number of kilobytes received.
  • NET KB Out: The number of kilobytes sent.
  • FCP Read: The number of FCP read operations serviced.
  • FCP Write: The number of FCP write operations serviced.
  • Disk KB Read: The number of kilobytes read from disk.
  • Disk KB Write: The number of kilobytes written to disk.

View Filer and Volume Performance Statistics

The Volumes tab provides information on overall filer performance, volume latency, I/O operations/sec, metrics on files and space used.

Click the volume name to see more detailed information about the volume (or disk partition). For more information, see Volume Details

Click the aggregate name (Agg) to see detailed information about the disk aggregate (or disk grouping such as in a Raid-DP or a Raid-5 implementation). For more information, see Agg Details.

The metrics collected and presented here are:

  • Name: The name of the volume.
  • Agg: The name of the disk aggregate on which the volume resides.
  • AVG Latency: The average time in milliseconds required to service a request on this volume.
  • AVG IOPS: The average number of I/O operations per second on this volume.
  • CIFS: The latency, in milliseconds, of IOPS performed using the Common Internet File System (CIFS) protocol.
  • FCP: The latency, in milliseconds, of IOPS performed using the Fibre Channel Protocol (FCP). 
  • ISCSI: The latency, in milliseconds, of IOPS performed using the Internet Small Computer System Interface (ISCSI) protocol.
  • NFS: The latency, in milliseconds, of I/O operations per second (IOPS) performed using the Network File System protocol (NFS).
  • Max Files Used: The number of files used in the inode table for the volume. Before the number of inodes is exceeded, NetApp prompts you to increase the number of inodes using the maxfiles command.
  • Used Space: The number of GB used on the volume.
  • Total Space: The total size of the volume, in GB.
  • % Space Used: The percentage of total space available that is used on the volume.

View Volume Activity and Performance Details

The Volumes details window displays graphs of metrics displayed numerically in the Current and Volumes Windows. The Activity by Protocol pane only displays protocols in use during the specified time period.

The Volumes details window links to the database activity window so you can see exactly what SQL was running at a particular point in time that consumed the NetApp resources.

Note: AppDynamics for Databases automatically discovers an Oracle database in an Oracle -> NFS -> NetApp environment, but for other environments you must map the database to the NetApp volume. For more information, see Map NetApp Volumes to Databases.

The Volumes detail window also provides correlation information to the server activity where it presents Read IOPS, Write IOPS, Network Data Received KB/sec, and Network Data Sent KB/sec. A launch in context link displays the Server Activity window of a monitored database server. 

View Aggregate (Agg) and Protocol Performance Details 

The Aggregate details window displays graphs of metrics displayed numerically in the Current and Volumes Windows. 

The Aggregate details window links to the database activity window so you can see exactly what SQL was running at a particular point in time that consumed the NetApp resources.

A launch in context link displays the Database Activity window of a monitored database. 

By clicking a server name in the Correlate Server Activity from list, the Volumes detail window also provides correlation information to the server activity where it presents Read IOPS, Write IOPS, Network Data Received KB/sec, and Network Data Sent KB/sec. A launch in context link displays the Server Activity window of a monitored database server.

View Network Interface Activity

The Network tab presents the Network Interface Activity window where graphs of Inbound Traffic (Network Data Received) and Outbound Traffic (Network Data Sent) for each interface/port are displayed. The table below the graphs lets you see at a glance which interfaces are most used and on which interface/port errors for received and sent transmissions are originating.

View Other NetApp Activity

You can access several activity windows from the NetApp Activity tab by clicking the subtabs on the Activity window:

System Activity

VFiler Activity

The Virtualized NetApp storage array (VFiler) activity tab displays: the protocol latency of the slowest volume on the array; CPU utilization; and the number of read, write, and miscellaneous I/O operations.

Aggregate Activity

The Aggregate Activity tab displays:

  • protocol latency of the slowest volume
  • total number of transfers per second serviced by the aggregate
  • number of user reads and writes per second to the aggregate
  • number of reads per second done during a Consistency Point (CP) to the aggregate. 

FlashCache Activity

Flash Cache is intelligent caching that optimizes storage performance, improves storage efficiency, and reduces the costs associated with Serial Advanced Technology Attachment (SATA) drives.
This window shows how flash cache is being used by your system.

  • No labels