RANKING ANALYSIS RESULTS BASED ON USER PERCEIVED PROBLEMS IN A DATABASE SYSTEM

• US 20130060762A1
• Filed: 09/02/2011
• Published: 03/07/2013
• Est. Priority Date: 09/02/2011
• Status: Active Grant

• Current Assignee: Idera, Inc.
• Original Assignee: BBS Technologies Incorporated (Idera, Inc.)
• Inventors: Bailey, George E. Jr., Goolsbee, Kurt V., Miskelly, Everett T.
• Granted Patent: US 9,858,551 B2
• Time in Patent Office: Days
• US Class Current: 707/723
• CPC Class Codes: G06F 11/079 Root cause analysis, i.e. error or fault diagnosis in a hardware test environment G06F11/22; in a software test environment G06F11/36
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

Methods and systems for ranking analysis results based on user perceived problems of a database system are described. During operation, an embodiment may receive a designation of a perceived database system performance problem from a user, wherein the problem is associated with one or more database system metrics. Next, the embodiment may determine a set of recommendations for alleviating the perceived database system performance problem. The embodiment may then analyze the set of recommendations to determine, for each recommendation in the set of recommendations, an impact the recommendation is expected to have on the one or more database system metrics. Finally, the embodiment may rank the set of recommendations according to the impact each recommendation is expected to have on the perceived database performance problem.

Claims

1. A computer-implemented method for ranking analysis results based on user perceived problems of a database system, the method comprising:

receiving a designation of a perceived database system performance problem from a user, wherein the designation is associated with one or more database system metrics;

determining, by computer, a set of recommendations for alleviating the perceived database system performance problem;

analyzing the set of recommendations to determine, for each recommendation, an impact the recommendation is expected to have on the perceived database system performance problem based on an impact the recommendation is expected to have on the one or more database system metrics; and

ranking the set of recommendations according to the impact each recommendation is expected to have on the perceived database system performance problem.

2. The computer-implemented method of claim 1, further comprising performing a recommendation from the set of recommendations.

3. The computer-implemented method of claim 2, wherein performing the recommendation from the set of recommendations involves performing the recommendation with the highest ranking

4. The computer-implemented method of claim 1, further comprising providing the ranking of the set of recommendations to the user.

5. The computer-implemented method of claim 1, wherein the database system metrics can include:

a memory utilization;

a CPU utilization;

a network bandwidth;

a network latency;

an I/O throughput;

an I/O latency; and

a query execution time.

6. The computer-implemented method of claim 1, wherein receiving the designation of the perceived database system performance problem from the user further involves receiving a target designation of one of:

an application;

a database server instance;

or

a computer system that is executing the database server instance.

7. The computer-implemented method of claim 6, wherein ranking the set of recommendations for alleviating the perceived database system performance problem involves weighting the recommendations according to the target designation.

8. A non-transitory computer-readable storage medium storing instructions that, when executed by a computer, cause the computer to perform a method for ranking analysis results based on user perceived problems of a database system, the method comprising:

receiving a designation of a perceived database system performance problem from a user, wherein the designation is associated with one or more database system metrics;

determining a set of recommendations for alleviating the perceived database system performance problem;

analyzing the set of recommendations to determine, for each recommendation, an impact the recommendation is expected to have on the perceived database system performance problem based on an impact the recommendation is expected to have on the one or more database system metrics; and

ranking the set of recommendations according to the impact each recommendation is expected to have on the perceived database system performance problem.

9. The non-transitory computer-readable storage medium of claim 8, wherein the method further comprises performing a recommendation from the set of recommendations.

10. The non-transitory computer-readable storage medium of claim 9, wherein performing the recommendation from the set of recommendations involves performing the recommendation with the highest ranking.

11. The non-transitory computer-readable storage medium of claim 8, wherein the method further comprises providing the ranking of the set of recommendations to the user.

12. The non-transitory computer-readable storage medium of claim 8, wherein the database system metrics can include:

a memory utilization;

a CPU utilization;

a network bandwidth;

a network latency;

an I/O throughput;

an I/O latency; and

a query execution time.

13. The non-transitory computer-readable storage medium of claim 8, wherein receiving the designation of the perceived database system performance problem from the user further involves receiving a target designation of one of:

an application;

a database server instance;

or

a computer system that is executing the database server instance.

14. The non-transitory computer-readable storage medium of claim 13, wherein ranking the set of recommendations for alleviating the perceived database system performance problem involves weighting the recommendations according to the target designation.

15. An apparatus configured for ranking analysis results based on user perceived problems of a database system, comprising:

a memory;

a processor;

a receiving mechanism configured to receive a designation of a perceived database system performance problem from a user, wherein the designation is associated with one or more database system metrics;

a determination mechanism configured to determine a set of recommendations for alleviating the perceived database system performance problem;

an analysis mechanism configured to analyze the set of recommendations to determine, for each recommendation, an impact the recommendation is expected to have on the perceived database system performance problem based on an impact the recommendation is expected to have on the one or more database system metrics; and

a ranking mechanism configured to rank the set of recommendations according to the impact each recommendation is expected to have on the perceived database system performance problem.

16. The apparatus of claim 15, further comprising a tuning mechanism configured to perform a recommendation from the set of recommendations.

17. The apparatus of claim 16, wherein the tuning mechanism is further configured to perform the recommendation with the highest ranking.

18. The apparatus of claim 15, further comprising a reporting mechanism configured to provide the ranking of the set of recommendations to the user.

19. The apparatus of claim 15, wherein the receiving mechanism is further configured to receive a target designation of one of:

an application;

a database server instance;

or

a computer system that is executing the database server instance.

20. The apparatus of claim 19, wherein the ranking mechanism is further configured to rank the set of recommendations for alleviating the perceived database system performance problem by weighting the recommendations according to the target designation.