US 2019/0095272 A1Published application

Monitoring, diagnosing, and repairing a management database in a data storage management system

AssigneeCommvault Systems, Inc.

InventorsGanesh HARIDAS, Sundar NARASIMMAN, Karthik SURIYANARAYANAN, Gunassekaran A. S., Michael Frank KLOSE

Life of this patent

Estimating the term…

Loading patent…

Abstract

A lightweight always-on monitoring, collecting, diagnosing, and correcting utility operates in an enhanced storage manager that manages a data storage managements system. The always-on utility provides a comprehensive and pro-active approach, which is intended to reduce, if not altogether eliminate, the need for after-the-fact diagnostics. The always-on utility also enforces so-called best practices and other heuristics, which include pro-actively activating certain database settings that are not enabled by default; manipulating certain aspects of the database to improve performance; and reporting aspects that are outside best-practice parameters to the trouble report system so that system administrators and/or developers may intervene before a catastrophic failure occurs. In some cases, the best-practice parameters represent heuristics designed by the present inventors to improve the performance and general health of the management database.

Claims20

Dependent claims

A method comprising:

executing a storage manager on a first computing device comprising one or more processors and computer memory;
executing a database management system associated with the storage manager,
wherein the database management system comprises a database that stores information used by the storage manager to manage data storage operations in a data storage management system, and
wherein the database is stored on a first data storage device accessible by the storage manager;
by the storage manager, monitoring the database while the database management system operates;
by the storage manager, classifying one or more indexes in the database, based on how often they are invoked, as being busier compared to other indexes in the database;
by the storage manager, diagnosing a problem associated with the database;
and
by the storage manager, correcting the diagnosed problem by causing the database management system to move the one or more indexes classified as being busier from the first data storage device to a second data storage device, which is distinct from the first data storage device and is also accessible to the storage manager.

6 more elements

A system comprising:

a first computing device comprising one or more processors and computer memory, wherein a storage manager executes on the first computing device;
a database management system associated with the storage manager,
wherein the database management system comprises a database which stores information used by the storage manager to manage data storage operations in a data storage management system, and
wherein the database is stored on a first data storage device accessible by the storage manager;
wherein the storage manager is configured to:
monitor the database while the database management system operates,
receive information from the database management system indicating data corruption in the database,
if the information indicates data corruption in one or more indexes of the database, cause the database management system to perform at least one of:
(i) re-generate the one or more indexes of the database, and (ii) re-index the entire database, and
if the information indicates data loss or data corruption in other than database indexes, cause the database management system to restore the database from a backup copy.

7 more elements

Dependencies are inferred from the claim text.

Facts

Application: 16/201,885Filed 27 Nov 2018
Priority: 29 Oct 2015
Published: 28 Mar 2019
Term ends: Not estimatedThe source records don’t support an estimate.

Classification21 codes

G06F 11/0793
Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of…
G06F 11/0706
Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of…
G06F 11/073
The processing taking place on a specific hardware platform or in a specific software environment: in a memory management context, e.g. virtual…
G06F 11/0751
Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of…

Family

Application62/248,176Us provisional application · filed 29 Oct 2015
Application15/334,014Continuation · filed 25 Oct 2016
Application16/201,885Continuation
US 10,176,036 B2Related patent
US 10,853,162 B2Related patent
US 2017/0123889 A1Published application
US 2019/0095272 A1This patent

From the US filing history. Foreign family members aren’t listed.