AppDynamics for Databases

2.9.x Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Appd tocbox

On this page:

Table of Contents
maxLevel2
minLevel2

Watch the video:

iFrame
srchttps://player.vimeo.com/video/109609208?badge=0&title=0&byline=0
width300
urlhttps://vimeo.com/109259328
height
168

 

...

175

 

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 Add a Collector 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:

Table of Contents

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

...

  • 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.

...

  • 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 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. 

...

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.

...