Metric gathering and reporting system for identifying database performance and throughput problems

• US 9,031,980 B2
• Filed: 10/05/2012
• Issued: 05/12/2015
• Est. Priority Date: 10/05/2012
• Status: Active Grant

• Current Assignee: SecureWorks Corp. (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Haber, Wayne
• Primary Examiner(s): LE, DEBBIE M
• Application Number:
  US13/646,341
• Publication Number:
  US 20140101200A1
• Time in Patent Office: 949 Days
• Field of Search: 707/774
• US Class Current: 707/774
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A database back end system includes a monitoring server operable to poll a first database for a first query running on the first database and add the first query to a query list in a second database, and a reporting server operable to normalize the first query, analyze the second database to find a second query in the query list, wherein the second query is found based upon the normalized first query, and report the second query to a user, wherein the reporting is based upon the analyzing of the second database to find the second query.

Claims

1. A database back end system comprising:

a hardware monitoring server operable to;

poll a first database for a first query running on the first database; and

add the first query to a query list in a second database; and

a hardware reporting server operable to;

normalize a variable of the first query;

analyze the second database to find a second query in the query list, wherein the second query is found based upon the normalized first query;

report the second query to a user, wherein the reporting is based upon the analyzing of the second database to find the second query; and

determine a first loading on the first database based upon a first frequency of occurrence of the second query and upon a first duration of the second query.

2. The database back end system of claim 1, wherein the monitoring server includes a first database management system that is associated with the first database.

3. The database back end system of claim 2, wherein the first database management system is separate from a second database management system that is associated with the first database, and that operates to issue the first query on the first database.

4. The database back end system of claim 1, wherein in normalizing the variable of the first query, the reporting server is further operable to:

determine that a field of the first query includes a first value; and

replace the first value with a variable.

5. The database back end system of claim 1, wherein the reporting server is further operable to:

analyze the second database to find a third query in the query list; and

report the third query to the user, wherein the reporting is based upon the analyzing of the second database to find the third query.

6. The database back end system of claim 5, wherein the reporting server is further operable to:

rank the second and third queries based upon the first loading on the first database of the first query as compared to a second loading on the first database of the second query;

wherein reporting the second and third queries are in response to the ranking.

7. The database back end system of claim 6, wherein the reporting server is further operable to:

determine the second loading based upon a second frequency of occurrence of the third query and upon a second duration of the third query;

wherein ranking the second and third queries is in response to determining the first and second loading.

8. The database back end system of claim 5, wherein the second query locks a portion of the first database and the third query is a victim of the second query.

9. A method comprising:

polling by a hardware monitoring server a first database for a first query running on the first database;

adding the first query to a query list in a second database;

normalizing by a hardware reporting server a variable of the first query;

analyzing the second database to find a second query in the query list, wherein the second query is found based upon the normalized first query;

reporting the second query to a user, wherein the reporting is based upon the analyzing of the second database to find the second query; and

determining a first loading on the first database based upon a first frequency of occurrence of the second query and upon a first duration of the second query.

10. The method of claim 9, wherein the monitoring server includes a first database management system that is associated with the first database.

11. The method of claim 10, wherein the first database management system is separate from a second database management system that is associated with the first database, and that operates to issue the first query on the first database.

12. The method of claim 9, wherein in normalizing the variable of the first query, the method further comprises:

determining that a field of the first query includes a first value; and

replacing the first value with a variable.

13. The method of claim 9, further comprising:

analyzing the second database to find a third query in the query list; and

reporting the third query to the user, wherein the reporting is based upon the analyzing of the second database to find the third query.

14. The method of claim 13, further comprising:

ranking the second and third queries based upon the first loading on the first database of the first query as compared to a second loading on the first database of the second query;

wherein reporting the second and third queries are in response to the ranking.

15. The method of claim 14, further comprising:

determining the second loading based upon a second frequency of occurrence of the third query and upon a second duration of the third query;

wherein ranking the second and third queries is in response to determining the first and second loading.

16. The method of claim 13, wherein the second query locks a portion of the first database and the third query is a victim of the second query.

17. A non-transitory computer-readable medium including code for performing a method, the method comprising:

polling by a monitoring server a first database for a first query running on the first database;

adding the first query to a query list in a second database;

normalizing by a reporting server a variable of the first query;

analyzing the second database to find a second query in the query list, wherein the second query is found based upon the normalized first query;

reporting the second query to a user, wherein the reporting is based upon the analyzing of the second database to find the second query; and

determining a first loading on the first database based upon a first frequency of occurrence of the second query and upon a first duration of the second query.

18. The computer-readable medium of claim 17, the method further comprising:

analyzing the second database to find a third query in the query list; and

reporting the third query to the user, wherein the reporting is based upon the analyzing of the second database to find the third query.

19. The computer-readable medium of claim 17, the method further comprising:

ranking the second and third queries based upon the first loading on the first database of the first query as compared to a second loading on the first database of the second query;

wherein reporting the second and third queries are in response to the ranking.

20. The computer-readable medium of claim 17, the method further comprising:

determining the second loading based upon a second frequency of occurrence of the third query and upon a second duration of the third query;

wherein ranking the second and third queries is in response to determining the first and second loading.