Correlating database and storage performance views

Patent metadata

Field	Value
Publication number	US-9483510-B2
Application number	US-201414255818-A
Country	US
Kind code	B2
Filing date	Apr 17, 2014
Priority date	Apr 17, 2014
Publication date	Nov 1, 2016
Grant date	Nov 1, 2016

Abstract

Technology is disclosed for providing access to operation performance of various storage mediums in a distributed storage system, which store and host data associated with a database (“the technology”). The technology can identify the storage mediums storing data associated with a particular database, gather data associated with performance of each of the identified storage mediums storing data associated with the particular database, and generate performance statistics associated with each of the identified storage mediums utilizing the gathered data and provide the generated statistics as a performance overview of storage associated with the particular database.

First claim

What is claimed is:

1. A computer implemented method, comprising:
identifying multiple storage volumes accessible through multiple storage nodes, the multiple storage volumes being utilized to store data associated with one or more databases and each storage node having access to one or more storage devices used for storing data for the multiple storage volumes;
identifying a subset of storage volumes of the multiple storage volumes storing data associated with a particular database, the identification of a particular storage volume of the subset of storage volumes being based on a mapping between the particular database and at least one identifier of multiple identifiers associated with a particular storage node providing access to the particular storage volume utilized to store data associated with the particular database; wherein the multiple identifiers associated with the particular storage node includes a fully qualified domain name (“FQDN”) of each of multiple interfaces associated with the particular storage node, the multiple interfaces including a data interface for managing data at the one or more storage devices and a management interface for exporting services to clients;
gathering data associated with performance of each storage volume of the subset of storage volumes storing data associated with the particular database;
generating performance statistics associated with each storage volume of the subset of storage volumes utilizing the gathered data; and
providing the generated statistics as a performance overview of storage associated with the particular database;
wherein generating the performance statistics associated with each storage volume of the subset of storage volumes utilizing the gathered data further includes:
generating a read latency of the particular storage volume at a particular time as a function of a measured delay associated with servicing a data read access request at the particular time;
generating a write latency of the particular storage volume at the particular time as a function of a measured delay associated with servicing a data write access request at the particular time; and
generating an average latency of the particular storage volume at the particular time as a function of the generated read latency and write latency at the particular time.

2. The method of claim 1 , wherein the multiple identifiers associated with a particular storage node includes an internet protocol (“IP”) address of each of multiple interfaces associated with the particular storage node, the multiple interfaces including a data interface and a management interface.

3. The method of claim 1 , wherein the particular storage volume is a logical storage entity providing a logically contiguous portion of storage within a physical storage device, wherein the physical storage device includes any of a hard disk drive and a flash drive.

4. The method of claim 1 , wherein gathering data associated with performance of each storage volume of the subset of storage volumes further comprises:
querying the particular storage node providing access to the particular storage volume for data associated with one or more parameters associated with performance of the particular storage volume, wherein the particular storage node measures and stores the data for the one or more parameters associated with performance of the particular storage volume, wherein querying the particular storage node is performed utilizing a Zephyr Application and Programming Interface (ZAPI) protocol.

5. The method of claim 4 , wherein the one or more parameters associated with performance of the particular storage volume includes any of a delay associated with servicing a data read access request, a delay associated with servicing a data write request, a delay associated with servicing a data modification request, a total number of a particular access requests performed within a particular time period, and a total number of all access requests performed within a particular time period.

6. The method of claim 1 , wherein the mapping between the particular database and at least one identifier of the multiple identifiers associated with the particular storage node is provided by a mount point definition, the mount point definition being a file system object providing access to the particular storage volume.

7. A computer implemented method, comprising:
identifying multiple databases associated with multiple storage nodes providing access to multiple storage volumes, the association of a particular database to a particular storage node being based on a storage of data associated with the particular database in a particular storage volume accessible through the particular storage node; wherein each storage node has access to one or more storage devices used for storing data for the multiple storage volumes
providing an identification information corresponding to each of the identified multiple databases;
receiving a selection of a database from the identified multiple databases, the selection being based on the provided identification information corresponding to each of the identified multiple databases;
identifying a subset of storage volumes of the multiple storage volumes storing data associated with the selected database, the identification of the particular storage volume of the subset of storage volumes being based on a mapping between the particular database and at least one identifier of multiple identifiers associated with the particular storage node providing access to the particular storage volume utilized to store data associated with the particular database; wherein the multiple identifiers associated with the particular storage node includes a fully qualified domain name (“FQDN”) of each of multiple interfaces associated with the particular storage node, the multiple interfaces including a data interface for managing data at the one or more storage devices and a management interface for exporting services to clients;
generating a performance statistics associated with each storage volume of the subset of storage volumes storing data associated with the selected database; and
providing the generated statistics as a performance overview of storage associated with the selected database;
wherein generating the performance statistics associated with performance of each storage volume of the subset of storage volumes further comprises:
querying the particular storage node providing access to the particular storage volume for data associated with one or more parameters associated with performance of the particular storage volume, wherein the particular storage node measures and stores the data for the one or more parameters associated with performance of the particular storage volume; and
generating the performance statistics associated with particular storage volume of the subset of storage volumes utilizing the queried data; wherein generating the performance statistics associated with each storage volume of the subset of storage volumes utilizing the queried data further includes:
generating a read latency of the particular storage volume at a particular time as a function of a measured delay associated with servicing a data read access request at the particular time;
generating a write latency of the particular storage volume at the particular time as a function of a measured delay associated with servicing a data write access request at the particular time; and
generating an average latency of the particular storage volume at the particular time as a function of the generated read latency and write latency at the particular time.

8. The method of claim 7 , wherein the multiple identifiers associated with the particular storage node includes an internet protocol (

Assignees

• Netapp Inc

Inventors

• Sitaram Anand
• Maheshwari Sachin

Classifications

• G06F11/3034 Primary

  where the computing system component is a storage system, e.g. DASD based or network based (digital input from or digital output to record carriers G06F3/06; digital recording or reproducing G11B20/18; for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS], H04L67/1097) · CPC title

• G06F17/30864

  Physics · mapped topic

• G06F17/302

  Physics · mapped topic

• G06F17/30312 Primary

  Physics · mapped topic

• G06F11/3419

  by assessing time · CPC title