Monitoring, diagnosing, and repairing a management database in a data storage management system
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-011/00
G06F-011/07
G06F-011/30
G06F-011/34
G06F-017/30
출원번호
US-0334036
(2016-10-25)
등록번호
US-10248494
(2019-04-02)
발명자
/ 주소
Haridas, Ganesh
Narasimman, Sundar
Suriyanarayanan, Karthik
A S, Gunassekaran
Klose, Michael Frank
출원인 / 주소
Commvault Systems, Inc.
대리인 / 주소
Commvault Systems, Inc.
인용정보
피인용 횟수 :
0인용 특허 :
177
초록▼
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,
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.
대표청구항▼
1. A method comprising: monitoring a database, by a storage manager, during active operation of a data storage management system, wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the storage manager executes on a computing d
1. A method comprising: monitoring a database, by a storage manager, during active operation of a data storage management system, wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the storage manager executes on a computing device comprising one or more processors and non-transitory computer-readable memory;collecting, by the storage manager, information about the database, wherein the collected information includes information about the structure of the database and information about the operation of the database;diagnosing, by the storage manager, a problem associated with the database, based on analyzing at least some of the collected information about the database; andcorrecting the problem associated with the database, at least in part, by causingat least a threshold number of temporary-database data structures to be instantiated in the database. 2. The method of claim 1 wherein the database is an SQL database. 3. The method of claim 1, wherein a database management system associated with the storage manager also executes on the computing device, and wherein the database management system comprises the database; periodically scanning database resources that are locked in query execution during active operation of the data storage management system; andidentifying one or more database resources that remain locked longer than a pre-defined threshold, wherein the pre-defined threshold is a query timeout period defined in the database management system. 4. The method of claim 3 wherein the one or more database resources that remain locked longer than the pre-defined threshold cause further queries to time out. 5. The method of claim 3 further comprising: reporting, by the storage manager, the identified one or more database resources that remain locked longer than the pre-defined threshold as a trouble report. 6. The method of claim 3 further comprising: reporting, by the storage manager, the identified one or more database resources that remain locked longer than the pre-defined threshold to a trouble report system in communication with the storage manager wherein the reporting includes one or more queries that caused the respective identified one or more database resources to lock. 7. The method of claim 1 wherein the information about the database that is collected by the storage manager comprises one or more of: (a) CPU usage by queries serviced by the database;(b) suspended queries;(c) recommendations for missing indexes;(d) deadlocked operations;(e) corruption detected in the database;(f) native database-health reports generated by a database management system that controls the database; and(g) native alarms generated by the database management system. 8. The method of claim 1, wherein the diagnosing is further based on diagnostic parameters comprising one or more of: (a) a first threshold representing a minimum number of temporary-database data structures that should be instantiated in the database;(b) a second threshold representing a maximum number of rows in any heap data structure in the database;(c) a third threshold for classification of one or more indexes in the database that are busier, according to the third threshold, than other indexes in the database;(d) a fourth threshold representing a maximum measure of fragmentation of each table in the database allowed before re-indexing the respective table;(e) a fifth threshold, lower than the fourth threshold, representing a maximum measure of fragmentation of each table in the database allowed before re-organizing the respective table;(f) a sixth threshold representing a maximum size for any temporary-database data structure in the database;(g) a seventh threshold for measuring corruption detected in database indexes;and(h) an eighth threshold for measuring corruption detected in database data. 9. A method comprising: monitoring a database, by a storage manager, during active operation of a data storage management system, wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the storage manager executes on a computing device comprising one or more processors and non-transitory computer-readable memory;collecting, by the storage manager, information about the database, wherein the collected information includes information about the structure of the database and information about the operation of the database;diagnosing, by the storage manager, a problem associated with the database, based on analyzing at least some of the collected information about the database; andcorrecting the problem associated with the database, at least in part, bystoring one or more indexes that are identified as busier relative to other indexes in the database, to a second mass storage device that is distinct from a first mass storage device storing the database. 10. A method comprising: monitoring a database, by a storage manager, during active operation of a data storage management system, wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the storage manager executes on a computing device comprising one or more processors and non-transitory computer-readable memory;collecting, by the storage manager, information about the database, wherein the collected information includes information about the structure of the database and information about the operation of the database;diagnosing, by the storage manager, a problem associated with the database, based on analyzing at least some of the collected information about the database; andcorrecting the problem associated with the database, at least in part, by causing:(1) re-indexing of a portion of the database if the portion of the database exceeds a first threshold of fragmentation, and (2) reorganizing the portion of the database if the portion of the database does not exceed the first threshold and exceeds a second and lower threshold of fragmentation. 11. The method of claim 10 wherein the correcting further causes: (3) re-indexing of an index of the database if corruption is detected in the index, and (4) initiating a restore of the database if corruption is detected in database data. 12. A method comprising: collecting, by a storage manager, during active operation of a data storage management system, information about a relational database, wherein the storage manager executes on a computing device comprising one or more processors and non-transitory computer-readable memory,wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the collected information is obtained from a relational database management system that controls the database;analyzing, by the storage manager, at least some of the collected information about the database relative to a plurality of diagnostic parameters in the storage manager; anddiagnosing, by the storage manager, one or more issues wherein one or more aspects of the database deviate from one or more of the plurality of diagnostic parameters; andcorrecting a diagnosed issue with the database by instructing the relational database management system toinstantiate more temporary-database data structures sufficient to reach a first threshold representing a minimum number of temporary-database data structures that should be instantiated in the database. 13. The method of claim 12 wherein the plurality of diagnostic parameters comprises one or more of: (a) a first threshold representing a minimum number of temporary-database data structures that should be instantiated in the database;(b) a second threshold representing a maximum number of rows in any heap data structure in the database;(c) a third threshold for classification of one or more indexes in the database that are busier, according to the third threshold, than other indexes in the database;(d) a fourth threshold representing a maximum measure of fragmentation of each table in the database allowed before re-indexing the respective table;(e) a fifth threshold, lower than the fourth threshold, representing a maximum measure of fragmentation of each table in the database allowed before re-organizing the respective table;(f) a sixth threshold representing a maximum size for any temporary-database data structure in the database;(g) a seventh threshold for measuring corruption detected in database indexes; and(h) an eighth threshold for measuring corruption detected in database data. 14. The method of claim 12 further comprising: correcting a diagnosed issue with the database wherein if the relational database management system reports that an index for a table in the database is corrupted, the storage manager instructs the relational database management system to re-index the table. 15. The method of claim 12 further comprising: correcting a diagnosed issue with the database, wherein if the relational database management system reports that an index for a table in the database is corrupted, the storage manager instructs the relational database management system to re-index the table, andwherein if the relational database management system reports that data in the database is corrupted, the storage manager initiates a database restore operation based on a secondary copy of the database maintained by the data storage management system. 16. The method of claim 12 wherein the collected information about the database is provided in response to requests submitted by the storage manager to the relational database management system; and wherein the collected information about the database comprises one or more of: (a) CPU usage by queries serviced by the database;(b) suspended queries;(c) recommendations for missing indexes;(d) deadlocked operations;(e) corruption detected in the database;(f) native database-health reports generated by the relational database management system; and(g) native alarms generated by the relational database management system. 17. The method of claim 12 further comprising: correcting a diagnosed issue with the databasewherein if the relational database management system reports that data in the database is corrupted, the storage manager initiates a database restore based on a secondary copy of the database maintained by the data storage management system. 18. The method of claim 12 further comprising: reporting, by the storage manager, the diagnosed one or more issues as trouble reports to a trouble reporting system in communication with the storage manager. 19. A method comprising: collecting, by a storage manager, during active operation of a data storage management system, information about a relational database, wherein the storage manager executes on a computing device comprising one or more processors and non-transitory computer-readable memory,wherein the database stores information used by the storage manager to manage the data storage management system, andwherein the collected information is obtained from a relational database management system that controls the database;analyzing, by the storage manager, at least some of the collected information about the database, relative to a plurality of diagnostic parameters in the storage manager; anddiagnosing, by the storage manager, one or more issues wherein one or more aspects of the database deviate from one or more of the plurality of diagnostic parameters;correcting a diagnosed issue with the database wherein: if a first table in the database exceeds a first threshold representing a maximum measure of fragmentation of each table in the database allowed before re-indexing the respective table, the storage manager instructs the relational database management system to re-index the first table, andif the first table in the database does not exceed the first threshold and exceeds a second threshold, which is lower than the first threshold, representing a maximum measure of fragmentation of each table in the database allowed before re-organizing the respective table, the storage manager instructs the relational database management system to re-organize the first table, andif the first table in the database does not exceed the first threshold and does not exceed the second threshold, the storage manager deems the first table to be in compliance with fragmentation-related diagnostic parameters.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (177)
Gilbert, Matthew M.; Boom, Douglas D., Apparatus and method for dynamic resource allocation in a network environment.
Yuval Ofek ; Zoran Cakeljic ; Philip Tamer, Apparatus and methods for copying a logical object to a primary storage device using a map of storage locations.
Yuval Ofek ; Zoran Cakeljic ; Samuel Krikler IL; Sharon Galtzur IL; Michael Hirsch IL; Dan Arnon ; Peter Kamvysselis, Apparatus and methods for copying, backing up, and restoring data using a backup segment size larger than the storage block size.
Dawson, Colin Scott; Kissel, Erick Christian; Morton, David Michael; Scheid, III, William J., Apparatus, system, and method for data access management.
Griffin David (Maynard MA) Campbell Jonathan (Acton MA) Reilly Michael (Sterling MA) Rosenbaum Richard (Pepperell MA), Arrangement with cooperating management server node and network service node.
Nakano Toshio (Odawara JPX) Nozawa Masafumi (Odawara JPX) Kurano Akira (Odawara JPX) Hisano Kiyoshi (Odawara JPX) Hoshino Masayuki (Odawara JPX), Backup control method and system in data processing system using identifiers for controlling block data transfer.
Kitajima Hiroyuki (Yokohama) Yamamoto Akira (Yokohama) Doi Takashi (Hadano) Nozawa Masafumi (Odawara JPX), Buffered peripheral system and method for backing up and retrieving data to and from backup memory device.
Cole Leo J. (Raleigh NC) Frantz Curtis J. (Durham NC) Lee Jeannette (Raleigh NC) Ordanic Zvonimir (Raleigh NC) Plank Larry K. (Rochester MN), Centralized management in a computer network.
Carpenter Kelly S. (Fremont CA) Dearing Gerard M. (San Jose CA) Nick Jeffrey M. (Fishkill NY) Strickland Jimmy P. (Saratoga CA) Swanson Michael D. (Poughkeepsie NY) Wilkinson Wendell W. (Hyde Park NY, Coherence controls for store-multiple shared data coordinated by cache directory entries in a shared electronic storage.
MacFarlane, Druce Ian Craig Rattray; Hardin, John Harvey; Donoho, David, Collecting and predicting capacity information for composite network resource formed by combining ports of an access server and/or links of wide arear network.
Senator Steven T. ; Fuller Billy J., Computer system method and apparatus providing for various versions of a file without requiring data copy or log operati.
Fecteau Jean G. (Toronto NY CAX) Gdaniec Joseph M. (Vestal NY) Hennessy James P. (Endicott NY) MacDonald John F. (Vestal NY) Osisek Damian L. (Vestal NY), Computer system which supports asynchronous commitment of data.
Koseki, Michihiko; Yokoyama, Mamoru; Sumi, Masashi; Yamaguchi, Satoru; Taniwaki, Sadayoshi; Hamanaka, Seishiro, Data processing system with mechanism for restoring file systems based on transaction logs.
Dunphy William E. (Westminster CO) Halladay Steven M. (Louisville CO) Moy Michael E. (Lafayette CO) Munro Frederick G. (Broomfield CO), Data storage and protection system.
Yanai Moshe (Framingham MA) Vishlitzky Natan (Brookline MA) Alterescu Bruno (Newton MA) Castel Daniel (Framingham MA) Shklarsky Gadi (Brookline MA), Data storage system controlled remote data mirroring with respectively maintained data indices.
Fortier Richard W. (Acton MA) Mastors Robert M. (Ayer MA) Taylor Tracy M. (Upton MA) Wallace John J. (Franklin MA), Digital data processor with improved backup storage.
Kenley Gregory (Northboro MA) Ericson George (Schrewsbury MA) Fortier Richard (Acton MA) Holland Chuck (Northboro MA) Mastors Robert (Ayer MA) Pownell James (Natick MA) Taylor Tracy (Upton MA) Wallac, Digital data storage system with improved data migration.
Norris David E. ; Hewitt Larry D. ; Blumenthal Jeffrey M., Enhanced register array accessible by both a system microprocessor and a wavetable audio synthesizer.
Xu Yikang ; Vahalia Uresh K. ; Jiang Xiaoye ; Gupta Uday ; Tzelnic Percy, File server system using file system storage, data movers, and an exchange of meta data among data movers for file locking and direct access to shared file systems.
Lagueux, Jr., Richard A.; Stave, Joel H.; Yeaman, John B.; Stevens, Brian E.; Higgins, Robert M.; Collins, James M., Graphical user interface for configuration of a storage system.
Urevig Paul D. ; Malnati James R. ; Ethen Donald J. ; Weber Herbert L., Grouping shared resources into one or more pools and automatically re-assigning shared resources from where they are not currently needed to where they are needed.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G.; May,Andreas; Schwartz,Jeremy, Hierarchical systems and methods for providing a unified view of storage information.
Barney Rock D. ; Schwols Keith ; Nelson Ellen M., Integration of a database into file management software for protecting, tracking and retrieving data.
Takagi Shiro,JPX, Large capacity storage apparatus having storage cells, an accessor, a cache memory and a disc update section to set a number of frequently accessed storage media.
Oshinsky, David Alan; Ignatius, Paul; Prahlad, Anand; May, Andreas, Logical view and access to data managed by a modular data and storage management system.
Ignatius, Paul; Theisen, Marjorie H.; Oshinsky, David Alan; Kavuri, Srinivas, Logical view and access to physical storage in modular data and storage management system.
Martin Charles W. (Richardson TX) Reid Fredrick S. (Plano TX) Forbus Gary L. (Dallas TX) Adams Steve M. (Plano TX) Shannon C. Patrick (Garland TX) Pirpich Eric A. (Garland TX), Mass data storage and retrieval system.
Kedem Nadav,ILX, Mass storage subsystem and backup arrangement for digital data processing system which permits information to be backed up while host computer(s) continue(s) operating in connection with information .
Long Robert M., Media element library with non-overlapping subset of media elements and non-overlapping subset of media element drives accessible to first host and unaccessible to second host.
Coates, Joshua L.; Bozeman, Patrick E.; Patterson, David A., Method and apparatus for accessing remote storage in a distributed storage cluster architecture.
Zalewski Stephen H. ; Mason Andrew H. ; Jordan Gregory H. ; Noel Karen L. ; Kauffman James R., Method and apparatus for migrating resources in a multi-processor computer system.
Arone,Geoffrey; Blumstein,Gregory; Chen,Edward; Mittal,Nalin, Method and apparatus for obtaining metadata from multiple information sources within an organization in real time.
Shim, Hyong; Shilane, Philip N.; Hsu, Windsor W., Method and apparatus for reducing overheads of primary storage by transferring modified data in an out-of-order manner.
Kullick Steven E. ; Spirakis Charles S. ; Titus Diane J., Method and apparatus for transferring archival data among an arbitrarily large number of computer devices in a networked.
Eastridge Lawrence E. (Tucson AZ) Kern Robert F. (Tucson AZ) Kern Ronald M. (Tucson AZ) Mikkelsen Claus W. (Morgan Hill CA) Ratliff James M. (Tucson AZ), Method and system for automated backup copy ordering in a time zero backup copy session.
Eastridge Lawrence E. (Tucson AZ) Kern Robert F. (Tucson AZ) Micka William F. (Tucson AZ) Mikkelsen Claus W. (Morgan Hill CA) Ratliff James M. (Tucson AZ), Method and system for automated termination and resumption in a time zero backup copy process.
Walter A. Hubis ; William G. Deitz, Method and system for controlling access share storage devices in a network environment by configuring host-to-volume mapping data structures in the controller memory for granting and denying access .
Jammu, Vinay Bhaskar; Bliley, Richard Gerald; Schneider, William Roy, Method and system for estimating time of occurrence of machine-disabling failures.
Ying Tat Leung ; Menachem Levanoni ; Sanjay E. Ramaswamy, Method and system for model-based clustering and signal-bearing medium for storing program of same.
Aharoni,Dan; Meiri,David; Gueorguiev,Dimitar Petkov; Goguen,Kenneth R.; Wei,Xiaoyan, Method and system for simulating performance on one or more data storage systems.
Hideto Furukawa JP; Makoto Yoshida JP; Nami Hatazoe JP, Method for determining reference phase in radio communication system which uses orthogonal M-ary modulation, and coherent detection method using the same.
Hsu,Windsor Wee Sun; Ong,Shauchi; Palmer,John Davis, Method for reducing data loss and unavailability by integrating multiple levels of a storage hierarchy.
Aoyama Yuki,JPX ; Takahashi Toru,JPX ; Wakayama Satoshi,JPX, Method of and an apparatus for displaying version information and configuration information and a computer-readable recording medium on which a version and configuration information display program i.
Holenstein, Paul J.; Hoffmann, John R.; Ziegler, Jonathan M.; Holenstein, Bruce D.; Highleyman, Wilbur H., Methods for repairing a corrupted database to a new, correct state.
van Rietschote,Hans F.; Hobbs,Craig W.; Saptarshi,Mahesh P., Migrating virtual machines among computer systems to balance load caused by virtual machines.
Crescenti,John; Kavuri,Srinivas; Oshinsky,David Alan; Prahlad,Anand, Modular backup and retrieval system used in conjunction with a storage area network.
Pisello Thomas (De Bary FL) Crossmier David (Casselberry FL) Ashton Paul (Oviedo FL), Network management system having virtual catalog overview of files distributively stored across network domain.
Raman, Suchitra; Armangau, Philippe; Bergant, Milena; Angelone, Raymond A.; Bono, Jean Pierre; Vahalia, Uresh; Gupta, Uday K., Replication of remote copy data for internet protocol (IP) transmission.
Crockett Robert N. (Tucson AZ) Kern Ronald M. (Tucson AZ) Micka William F. (Tucson AZ), Software directed microcode state save for distributed storage controller.
Mutalik Madhav ; Senie Faith M., System and method for performing file-handling operations in a digital data processing system using an operating system-independent file map.
Huai ReiJane (Old Brookville NY) Daly Robert (Ronkonkoma NY) Curti Walter (Dix Hills NY) Mohan Deepak (Huntington NY) Chueh James Kuang-Ru (Bayside NY) Louie Larry (Forest Hills NY), System and parallel streaming and data stripping to back-up a network.
Courtright ; II William V. ; Delaney William P. ; Fredin Gerald J., System controller with plurality of memory queues for prioritized scheduling of I/O requests from priority assigned clients.
Stoppani ; Jr. Peter (Woodinville WA), System for allocating storage spaces based upon required and optional service attributes having assigned piorities.
Flynn Rex A. (Belmont MA) Anick Peter G. (Marlboro MA), System for reconstructing prior versions of indexes using records indicating changes between successive versions of the.
Saether Christian D. (Seattle WA) Stoppani ; Jr. Peter (Woodinville WA), System of device independent file directories using a tag between the directories and file descriptors that migrate with.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for detecting and mitigating storage risks.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G.; May,Andreas; Schwartz,Jeremy, Systems and methods for generating a storage-related metric.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for storage modeling and costing.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for storage modeling and costing.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy, Systems and methods for storage modeling and costing.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy Alan, Systems and methods for storage modeling and costing.
Prahlad, Anand; Kavuri, Srinivas; Madeira, Andre Duque; Lunde, Norman R.; Bunte, Alan G.; May, Andreas; Schwartz, Jeremy Alan, Systems and methods for storage modeling and costing.
Prahlad,Anand; Kavuri,Srinivas; Madeira,Andre Duque; Lunde,Norman R.; Bunte,Alan G; May,Andreas; Schwartz,Jeremy, Systems and methods for storage modeling and costing.
Ryoji Ono JP, UPDATE LOG MANAGEMENT DEVICE AND AN UPDATE LOG MANAGEMENT METHOD DECREASING THE DATA AMOUNT OF TRANSMITTING AND THE UPDATE LOG AMOUNT OF HOLDING BASED ON THE RESULT OF COMPARING THE AMOUNT OF THE UPD.
Multer, David L.; Garner, Robert E.; Ridgard, Leighton A.; Stannard, Liam J.; Cash, Donald W.; Robertson, Joseph, Updating application data including adding first change log to aggreagate change log comprising summary of changes.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.