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 system comprising: a computing device for executing a storage manager for managing a data storage management system, wherein the computing device comprises one or more processors and non-transitory computer-readable memory for executing programming instructions from the computer-readable memory
1. A system comprising: a computing device for executing a storage manager for managing a data storage management system, wherein the computing device comprises one or more processors and non-transitory computer-readable memory for executing programming instructions from the computer-readable memory;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 the data storage management system, including to manage data storage operations in the data storage management system, andwherein the database management system comprises a plurality of native utilities for performing database management operations;wherein the storage manager is programmed to: monitor the database during active operation of the data storage management system,diagnose a problem associated with the database, based on information about the database collected in the monitor operation, andcorrect the diagnosed problem, at least in part, by instructing the database management system to perform a database management operation using one or more native utilities among the plurality of native utilities;wherein the database is stored on a first mass storage device accessible by the storage manager; andwherein the storage manager is further programmed to: classify one or more indexes in the database as being busier, based on how often they are invoked, relative to other indexes in the database, andmove the one or more indexes classified as being busier from the first mass storage device to a second mass storage device, which is distinct from the first mass storage device and is also accessible by the storage manager. 2. The system of claim 1 wherein to correct the diagnosed problem, the storage manager is programmed to instruct the database management system to instantiate a number of additional temporary-database data structures in the database. 3. The system of claim 2 wherein the instantiated number of additional temporary-database data structures improve a performance metric of the database, wherein the performance metric caused the storage manager to diagnose the problem. 4. The system of claim 2 wherein the instantiated number of additional temporary-database data structures improve a performance metric of the database, wherein the performance metric measures responsiveness of the database. 5. The system of claim 2 wherein the instantiated number of additional temporary-database data structures improve a performance metric of the database, wherein the performance metric measures responsiveness of the database to one or more of: read operations, write operations, and query processing. 6. The system of claim 1 wherein moving the one or more indexes classified as being busier to the second mass storage device from the first mass storage device improves a performance metric of the database. 7. The system of claim 1 wherein moving the one or more indexes classified as being busier to the second mass storage device from the first mass storage device improves a performance metric of the database, wherein the performance metric measures responsiveness of the database to one or more of: read operations, write operations, and query processing. 8. The system of claim 1 wherein to monitor the database, the storage manager is programmed to instruct the database management system to check for data corruption in the database; and wherein to correct the diagnosed problem, the storage manager is programmed to: (a) if the database management system reports that one or more database indexes are corrupted, instruct the database management system to perform at least one of: re-generate the one or more database indexes and re-index the database, and(b) if the database management system reports data corruption or data loss other than in the database indexes, initiate a database restore operation in the data storage management system. 9. The system of claim 1 wherein the storage manager is further programmed to: request database health reports from the database management system,identify database health issues by analyzing the database health reports, andclassify the identified database health issues based on importance of the respective database health issue to operation of the data storage management system. 10. The system of claim 1 wherein the database management system is a version of SQL server, and wherein the database is an SQL database. 11. The system of claim 1 wherein the database is a relational database that is organized according to a schema. 12. The system of claim 1 wherein the database management system executes on the computing device that hosts the storage manager. 13. The system of claim 1, wherein the storage manager is further programmed to: evaluate database resources that are locked in query execution during active operation of the data storage management system, andgenerate a trouble report that identifies one or more database resources that remain locked longer than a pre-defined threshold. 14. The system of claim 13 wherein the storage manager is further programmed to transmit the trouble report to a trouble report system in communication with the storage manager. 15. The system of claim 13 wherein the one or more database resources that remain locked longer than the pre-defined threshold prevent further queries from executing, thereby causing the further queries to fail. 16. The system of claim 13 wherein the storage manager is further programmed to identify one or more queries to the management database that cause the one or more database resources to remain locked longer than the pre-defined threshold and to include the one or more queries in the trouble report. 17. A system comprising: a computing device for executing a storage manager for managing a data storage management system, wherein the computing device comprises one or more processors and non-transitory computer-readable memory for executing programming instructions from the computer-readable memory;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 the data storage management system, including to manage data storage operations in the data storage management system, andwherein the database management system comprises a plurality of native utilities for performing database management operations; andwherein the storage manager is programmed to: monitor the database during active operation of the data storage management system,diagnose a problem associated with the database, based on information about the database collected in the monitor operation, andcorrect the diagnosed problem, at least in part, by instructing the database management system to perform a database management operation using one or more native utilities among the plurality of native utilities; andwherein to correct the diagnosed problem, the storage manager is programmed to: determine, based on fragmentation information obtained from the database management system, whether a first table in the database exceeds a first fragmentation threshold,if the first table in the database exceeds the first fragmentation threshold, instruct the database management system to re-index the first table, andif the first table in the database does not exceed the first fragmentation threshold and exceeds a second fragmentation threshold, instruct the database management system to reorganize the first table. 18. The system of claim 17 wherein at least one of the re-indexing and the reorganizing of the first table by the database management system in response to instructions from the storage manager improves a performance metric of the database. 19. A system comprising: a computing device for executing a storage manager for managing a data storage management system, wherein the computing device comprises one or more processors and non-transitory computer-readable memory for executing programming instructions from the computer-readable memory;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 the data storage management system, including to manage data storage operations in the data storage management system, andwherein the database management system comprises a plurality of native utilities for performing database management operations;wherein the storage manager is programmed to: monitor the database during active operation of the data storage management system,diagnose a problem associated with the database, based on information about the database collected in the monitor operation, andcorrect the diagnosed problem, at least in part, by instructing the database management system to perform a database management operation using one or more native utilities among the plurality of native utilities;wherein the database that stores information used by the storage manager is designated a management database; anda report server comprising one or more processors and computer-readable memory for executing programming instructions from the computer-readable memory, and wherein the report server further comprises a second database for storing historical information about the management database; andwherein the storage manager is further programmed to: extract, from the database management system, natively-generated statistics about the performance of the management database, wherein the natively-generated statistics are lost when the database management system resets the management database, andtransmit the extracted natively-generated statistics about database performance to the report server for storage to the second database, thereby overcoming loss of the natively-generated statistics on reset of the management database.
연구과제 타임라인
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는 부적절한 답변을 할 수 있습니다.