Standard operating procedure automation in database administration

• US 7,529,827 B2
• Filed: 12/10/2007
• Issued: 05/05/2009
• Est. Priority Date: 06/29/2006
• Status: Expired due to Fees

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: Stratavia Corp. (HP Inc.)
• Inventors: Devraj, Venkat S., Luistro, Rainier L.
• Primary Examiner(s): Pwu; Jeffrey
• Assistant Examiner(s): Bruckart; Benjamin R
• Application Number:
  US11/953,563
• Publication Number:
  US 20080091738A1
• Time in Patent Office: 512 Days
• Field of Search: 709/223
• US Class Current: 709/223
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

A plurality of modules and/or engines to manage the operation and health of a plurality of data center assets through the use of standard operating procedures (SOPs). Modules of the present invention are configured to assist IT Administrators to create, and thereafter store in an accessible memory resource, a plurality of SOPs. These SOPs define procedures to address various data center asset informational states. An asset'"'"'s state information is monitored, collected and analyzed to determine, based either on a predetermined rule set or on manual input from an authorized IT Administrator, whether one or more SOPs will be applied to a particular data center asset. These SOPs can be combined and/or executed on the asset either automatically or manually.

Claims

1. A computer system for managing data center an asset, the computer system comprising:

a machine capable of executing instructions embodied as software; and

a plurality of software portions, including

one of said software portions configured to create a plurality of standard operating procedures (“

SOPs”

) wherein each SOP defines one or more procedures to address a specific state of the data center asset or perform a requested task on the data center asset and is associated with a data center asset type and each data center asset type associated SOP is further associated with, and compatible with, data center asset policies and wherein each data center asset type associated SOP is compatible with each other SOP associated with that data center asset;

one of said software portions configured to create a plurality of task recipes wherein each task recipe includes a tasking request identifying at least one SOP;

one of said software portions configured to store in a memory the plurality of SOPs and the plurality of task recipes;

one of said software portions configured to monitor state information about the asset including information to enable real-time modification of each of the plurality of SOPs;

one of said software portions configured to determine whether said monitored state information matches a predefined rule set and responsive to said monitored state information matching said rule set automatically initiating a responsive tasking request;

one of said software portions configured to receive an external tasking request based on a task recipe;

one of said software portions configured to prioritize each tasking request based on data center asset policies;

one of said software portions configured to identify a subset of the plurality of SOPs associated with each tasking request;

one of said software portions configured to retrieve the subset of the plurality of SOPs from the memory for each tasking request;

one of said software portions configured to prioritize each SOP in each subset of the plurality of SOPs and responsive to a conflict existing between two or more prioritized SOPs and/or tasking requests, resolving the conflict based on pre-established criteria;

one of said software portions configured to execute the subset of the plurality of SOPs on the data center asset as prioritized; and

one of said software portions to determine whether execution of the subset of the plurality of SOPs on the data center asset has addressed the associated tasking request.

2. The computer system of claim 1 wherein SOP creation includes the creation of a corresponding task recipe in human readable format.

3. The computer system of claim 1 further comprising one of said software portions configured to execute said tasking request based on a specific time interval.

4. The computer system of claim 1 wherein each rule set determines which parameters of monitored state information about the data center asset, or deltas in such information, trigger a SOP response of the tasking request.

5. The computer system of claim 1 wherein one or more of said SOPs of said subset of the plurality of SOPs identified with said tasking request receives one or more real time metadata injections regarding the data center asset prior to and during SOP execution.

6. The computer system of claim 1 further comprising a software portion configured to collect and store at a central repository a result-set of data from said execution of said subset of SOPs.

7. The computer system of claim 1 wherein SOP creation and modification is limited to designated senior Information Technology Administrators.

8. The computer system of claim 1 wherein at least one of the plurality of SOPs is a task-based SOP.

9. The computer system of claim 8 wherein task-based SOPs are configured to perform data center administration tasks selected from a list consisting of operating system installation, operating system update, software application installation, software application update, operating system health checks, software application health checks, operating system performance parameters management, software application performance parameters management, software application-specific data backup and restoration, operating system problem root cause analysis, software application specific problem root cause analysis, database backup, database refreshes, database cloning, database health-checks, database memory resource space management, database coalescing, rebuilding fragmented database segments, database optimizer statistics analysis, database root cause analysis, database patching, database upgrades, database migrations, and database server migrations.

10. The computer system of claim 1 further comprising a software portion configured to analyze the monitored state information to determine the data center asset'"'"'s capability to conduct tasked operations.

11. The computer system of claim 10 wherein at least one of the plurality of SOPs is a healing SOP to correct the data center asset'"'"'s failure to conduct tasked operations.

12. The computer system of claim 11 wherein the healing SOPs are triggered by altered data center asset state information.

13. The computer system of claim 1 wherein SOPs are stored separate from the data center asset.

14. The computer system of claim 1 wherein monitoring identifies a data center asset failure and creates an alert based on a pre-defined rule set.

15. The computer system of claim 1 wherein state information about the data center asset is periodically collected for future analysis.

16. The computer system of claim 15 wherein analysis of data center asset'"'"'s state information uses a plurality of mathematical models including linear regression, queuing theory, simulation, and fuzzy logic to predict future data center asset state and performance.

17. The computer system of claim 1 further comprising a software potion configured to link a first subset of SOPs to a second set of SOPs to accomplish the requested task.

18. The computer system of claim 17 wherein subsets of SOPs include SOPs associated according to a particular data center asset task.

19. The computer system of claim 1 wherein designated SOPs are executed at the data center asset automatically based on pre-determined state information of the database.

20. The computer system of claim 1 wherein an Information Technology Administrator can monitor execution of SOPs at the data center asset real-time and provide manual intervention.

21. The computer system of claim 1 further comprising a software portion configured to generate an audit trail of monitored data center asset state information and SOP execution on the data center asset.

22. A computer implemented method for managing an asset, the method comprising:

monitoring state information about the asset;

collecting state information about the asset;

determining whether said collected state information matches a predefined rule set and responsive to said collected state information

matching said rule set automatically forming a collected state information based tasking request;

receiving at least one of said collected state information based tasking request or from an external source, an external source based tasking request;

retrieving from a storage medium at least one of a plurality of standard operating procedures (“

SOPs”

) based on each received request wherein each associated SOP defines procedures to address a specific state of the asset or perform a requested task on the asset and is associated with an asset type and each asset type associated SOP is further associated with, and compatible with, asset environment policies;

prioritizing each SOP of the plurality of SOPs and responsive to a conflict existing between two or more prioritized SOPs and/or tasking requests, resolving the conflict based on pre-established criteria;

at the asset, executing the at least one SOP as prioritized; and

determining whether execution of the at least one of the plurality of SOPs on the asset has addressed the associated tasking request.

23. The computer implemented method of claim 22, wherein retrieving from said storage medium includes at least one task recipe corresponding to the at least one of the plurality of SOPs.

24. The computer implemented method of claim 22, wherein the tasking request is automatically generated during runtime based on an analysis of collected state information.

25. The computer implemented method of claim 22, wherein the at least one of the plurality of SOPs based on said tasking request receives one or more real time metadata injections regarding the asset prior to and during SOP execution.

26. The computer implemented method of claim 22, wherein the at least one SOP is linked with at least another SOP based on the tasking request.

27. The computer implemented method of claim 22, wherein SOP creation and modification is limited to authorized Information Technology Administrators.

28. The computer implemented method of claim 22, wherein the at least one SOP performs an Information Technology administration task selected from a list consisting of installation of operating system software on server machines, installation of application software on server machines, software updates (patches), application updating ticketing, task-tracking system, updating an operating system, performance parameter adjustment on application software, asset data backup and restoration, storage configuration adjustment, asset memory resource management, and data migrations.

29. The computer implemented method of claim 22, further comprising analyzing collected state information to determine the asset'"'"'s inability to conduct tasked operations based on a pre-defined rule set.

30. The computer implemented method of claim 29, wherein the least one SOP is a healing SOP to correct the asset'"'"'s inability to conduct tasked operations.

31. The computer implemented method of claim 29, wherein responsive to determining the asset'"'"'s inability to conduct tasked operations, creating an alert.

32. The computer implemented method of claim 29, wherein the analyzing of collected state information employs mathematical models including fuzzy logic, linear regression, ratio modeling or queuing theory.

33. The computer implemented method of claim 22 further comprising linking a first subset of SOPs to a second set of SOPs to accomplish the requested task.

34. The computer implemented method of claim 22, wherein the at least one SOP is executed at the data center asset automatically based on pre-determined state information about the asset.

35. The computer implemented method of claim 22, wherein an Information Technology Administrator can monitor execution of the at least one SOP at the data center asset real-time and, when necessary, manually intervene in the SOP'"'"'s execution.

36. The computer implemented method of claim 22, further comprising generating an audit trail of monitored data center asset state information and SOP execution at the asset.

37. A computer-readable storage medium tangibly embodying a program of instructions executable by a machine wherein said program of instructions comprises a plurality of program codes for managing a data center asset, said program of instructions comprising:

program code for creating a plurality of standard operating procedures (“

SOPs”

) wherein each SOP defines one or more procedures to address a specific state of the data center asset or perform a requested task on the data center asset and is associated with a data center asset type and each data center asset type associated SOP is further associated with, and compatible with, data center asset policies and wherein each data center asset type associated SOP is compatible with each other SOP associated with that data center asset;

program code for creating a plurality of task recipes wherein each task recipe includes a tasking request identifying at least one SOP;

program code for storing in a memory the plurality of SOPs and the plurality of task recipes;

program code for collecting state information about the data center asset including information to enable real-time modification of each of the plurality of SOPs;

program code for determining whether said monitored state information matches a predefined rule set and responsive to said monitored state information matching said rule set automatically forming and initiating a responsive tasking request;

program code for receiving an external tasking request based on a task recipe;

program code for prioritizing each tasking request based on data center asset policies;

program code for identifying a subset of the plurality of SOPs for each tasking request;

program code for retrieving the subset of SOPs from the memory;

program code for prioritizing each SOP and responsive to a conflict existing between two or more prioritized SOPs and/or tasking requests, resolving the conflict based on pre-established criteria; and

program code for automatically executing the subset of SOPs on the data center asset as prioritized.

38. The computer-readable storage medium of claim 37 wherein the program code for creating includes creating data center asset task recipes in human readable format corresponding to each SOP.

39. The computer-readable storage medium of claim 37 wherein said tasking request is generated automatically during runtime based on collected state information about the data center asset.

40. The computer-readable storage medium of claim 37 wherein each rule set determines which parameters of collected state information about the data center asset, or deltas in such information, trigger a SOP response associated with said tasking request.

41. The computer-readable storage medium of claim 40 wherein one or more of said SOPs of said subset of the plurality of SOPs identified with said tasking request receives one or more real time injections regarding the data center asset prior to and during SOP execution.