IP Library › Granted Patent US 9,031,980
Granted Patent B2
US 9,031,980 · App. 13/646,341 · Granted May 12, 2015

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

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,031,980
App. No.
13/646,341
Granted
May 12, 2015
Kind
B2
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 (62)

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.

Assignments (13)
SECURITY INTEREST Recorded May 2, 2025
From: SECUREWORKS CORP.
To: GOLDMAN SACHS BANK USA, AS COLLATERAL AGENT
Reel/Frame 071156/0529 →
RELEASE OF SECURITY INTEREST Recorded Sep 14, 2016
From: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040040/0001 →
RELEASE OF SECURITY INTEREST Recorded Sep 14, 2016
From: BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS COLLATERAL AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040065/0618 →
RELEASE OF SECURITY INTEREST Recorded Sep 13, 2016
From: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
To: DELL MARKETING L.P.; ASAP SOFTWARE EXPRESS, INC.; APPASSURE SOFTWARE, INC.; COMPELLANT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL PRODUCTS L.P.; DELL USA L.P.; DELL SOFTWARE INC.; FORCE10 NETWORKS, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
Reel/Frame 040065/0216 →
ENTITY CONVERSION WITH NAME CHANGE Recorded Dec 8, 2015
From: SECUREWORKS HOLDING CORPORATION
To: SECUREWORKS CORP.
Reel/Frame 037243/0736 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 5, 2015
From: DELL PRODUCTS L.P.
To: SECUREWORKS HOLDING CORPORATION
Reel/Frame 036262/0417 →
RELEASE OF SECURITY INTEREST Recorded Aug 5, 2015
From: THE BANK OF NEW YORK MELLON TRUST COMPANY, N.A.
To: SECUREWORKS HOLDING CORPORATION; SECUREWORKS, INC.
Reel/Frame 036262/0525 →
RELEASE OF SECURITY INTEREST Recorded Aug 5, 2015
From: BANK OF AMERICA, N.A.
To: SECUREWORKS HOLDING CORPORATION; SECUREWORKS, INC.
Reel/Frame 036262/0509 →
RELEASE OF SECURITY INTEREST Recorded Aug 5, 2015
From: BANK OF AMERICA, N.A.
To: SECUREWORKS HOLDING CORPORATION; SECUREWORKS, INC.
Reel/Frame 036262/0490 →
PATENT SECURITY AGREEMENT (NOTES) Recorded Jan 2, 2014
From: APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF NEW YORK MELLON TRUST COMPANY, N.A., AS FIRST LIEN COLLATERAL AGENT
Reel/Frame 031897/0348 →
PATENT SECURITY AGREEMENT (ABL) Recorded Jan 2, 2014
From: DELL INC.; APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF AMERICA, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 031898/0001 →
PATENT SECURITY AGREEMENT (TERM LOAN) Recorded Jan 2, 2014
From: DELL INC.; APPASSURE SOFTWARE, INC.; ASAP SOFTWARE EXPRESS, INC.; BOOMI, INC.; COMPELLENT TECHNOLOGIES, INC.; CREDANT TECHNOLOGIES, INC.; DELL MARKETING L.P.; DELL PRODUCTS L.P.; DELL SOFTWARE INC.; DELL USA L.P.; FORCE10 NETWORKS, INC.; GALE TECHNOLOGIES, INC.; PEROT SYSTEMS CORPORATION; SECUREWORKS, INC.; WYSE TECHNOLOGY L.L.C.
To: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
Reel/Frame 031899/0261 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 8, 2012
From: HABER, WAYNE
To: DELL PRODUCTS, LP
Reel/Frame 029089/0251 →