Methods and apparatus for obtaining database performance snapshots

• US 9,213,727 B1
• Filed: 09/28/2012
• Issued: 12/15/2015
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: EMC Corporation (Dell Technologies Inc.)
• Inventors: Esposito, Jeffrey Daniel
• Primary Examiner(s): Bowen, Richard
• Application Number:
  US13/630,242
• Time in Patent Office: 1,173 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Methods and apparatus are provided for obtaining database performance snapshots. Performance data for one or more databases on a host is obtained by obtaining a host burden rating based on one or more of processing, network and input/out statistics of the host; determining a spawn limit based on the host burden rating; and spawning one or more scripts within the spawn limit, wherein each of the scripts collect performance data for a given database and is selected based on a database type of the given database. The host burden rating is a quantitative measure based on a sum of the processing, network and input/out statistics of the host. The collected performance data can be presented to a user in a graphical user interface and/or stored in a repository. The presented collected performance data for a given database comprises, for example, a score and/or a health assessment indicator based on predefined thresholds.

Claims

1. A method for obtaining performance data for one or more databases on a host, comprising:

obtaining a host burden rating calculated from a comparison of one or more of processing, network and input/out statistics of said host to one or more predetermined limits;

determining a spawn limit as a function of said host burden rating, wherein said spawn limit is a limit on a number of scripts that may be executed by said host substantially simultaneously; and

spawning one or more scripts to execute on said host within said spawn limit, wherein each of said scripts executes on said host and collects performance data for a given database and is assembled and obtained from a script library based on a database type of said given database.

2. The method of claim 1, further comprising the step of storing said collected performance data in a repository.

3. The method of claim 1, further comprising the step of presenting said collected performance data to a user in a graphical user interface.

4. The method of claim 3, wherein said presented collected performance data for said given database can be promoted or demoted within said graphical user interface.

5. The method of claim 3, wherein said presented collected performance data for said given database comprises one or more of a score and a health assessment indicator based on predefined thresholds.

6. The method of claim 1, further comprising the step of wrapping said collected performance data for a direct path to a staging area of a repository.

7. The method of claim 1, wherein said host burden rating is a quantitative measure based on a sum of said processing, network and input/out statistics of said host.

8. The method of claim 1, further comprising the step of scrubbing said collected performance data prior to storage in a repository.

9. The method of claim 1, further comprising the step of terminating a given script if a predefined time threshold is exceeded.

10. The method of claim 1, wherein said assembling and obtaining of each of said scripts from a script library is further based on an operating system of said host.

11. A tangible machine-readable recordable storage medium for obtaining performance data for one or more databases on a host, wherein one or more software programs when executed by one or more processing devices implement the steps of the method of claim 1.

12. A system for obtaining performance data for one or more databases on a host, the apparatus comprising:

a memory; and

at least one hardware device, coupled to the memory, operative to implement the following steps;

obtain a host burden rating calculated from a comparison of one or more of processing, network and input/out statistics of said host to one or more predetermined limits;

determine a spawn limit as a function of said host burden rating, wherein said spawn limit is a limit on a number of scripts that may be executed by said host substantially simultaneously; and

spawn one or more scripts to execute on said host within said spawn limit, wherein each of said scripts executes on said host and collects performance data for a given database and is assembled and obtained from a script library based on a database type of said given database.

13. The system of claim 12, wherein said at least one hardware device is further configured to store said collected performance data in a repository.

14. The system of claim 12, wherein said at least one hardware device is further configured to present said collected performance data to a user in a graphical user interface.

15. The system of claim 14, wherein said presented collected performance data for said given database can be promoted or demoted within said graphical user interface.

16. The system of claim 14, wherein said presented collected performance data for said given database comprises one or more of a score and a health assessment indicator based on predefined thresholds.

17. The system of claim 12, wherein said at least one hardware device is further configured to wrap said collected performance data for a direct path to a staging area of a repository.

18. The system of claim 12, wherein said host burden rating is a quantitative measure based on a sum of said processing, network and input/out statistics of said host.

19. The system of claim 12, wherein said at least one hardware device is further configured to scrub said collected performance data prior to storage in a repository.

20. The system of claim 12, wherein said at least one hardware device is further configured to terminate a given script if a predefined time threshold is exceeded.