GENERATING PERFORMANCE ALERTS

• US 20120023375A1
• Filed: 07/23/2010
• Published: 01/26/2012
• Est. Priority Date: 07/23/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Dutta, Arup, Collins, Jesse
• Granted Patent: US 8,738,970 B2
• Time in Patent Office: Days
• US Class Current: 714/47.2
• CPC Class Codes: G06F 11/0754 by exceeding limits
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

A method for generating performance alerts in a database system. The method includes collecting a predefined set of performance data, and comparing the performance data to one or more predefined thresholds. The method also includes determining if any of the performance data exceeds the one or more predefined thresholds, and generating an alert if any of the data exceeds one of the predefined thresholds.

Claims

1. A method for generating performance alerts in a database system, the method comprising:

collecting a predefined set of performance data;

comparing the performance data to one or more predefined thresholds;

determining if any of the performance data exceeds the one or more predefined thresholds; and

generating an alert if any of the data exceeds one of the predefined thresholds.

2. The method of claim 1, wherein the performance data is structured query language (SQL) performance data.

3. The method of claim 1, wherein the performance data comprises one or more of buffer gets, disk reads, central processing unit (CPU) time, elapsed time.

4. The method of claim 1, wherein the alert is an email alert.

5. The method of claim 1, further comprising purging collected performance data.

6. A computer-readable storage medium having one or more instructions thereon for generating performance alerts in a database system, the instructions when executed by one or more processors causing the one or more processors to:

collecting a predefined set of performance data;

comparing the performance data to one or more predefined thresholds;

determining if any of the performance data exceeds the one or more predefined thresholds; and

generating an alert if any of the data exceeds one of the predefined thresholds.

7. The computer-readable storage medium of claim 6, wherein the performance data is structured query language (SQL) performance data.

8. The computer-readable storage medium of claim 6, wherein the performance data comprises one or more of buffer gets, disk reads, central processing unit (CPU) time, elapsed time.

9. The computer-readable storage medium of claim 6, wherein the alert is an email alert.

10. The computer-readable storage medium of claim 6, wherein the instructions further cause the one or more processors to purge collected performance data.

11. An apparatus for generating performance alerts in a database system, the apparatus comprising:

a processor; and

a storage device storing one or more stored sequences of instructions which, when executed by the processor, cause the processor to;

collect a predefined set of performance data;

compare the performance data to one or more predefined thresholds;

determine if any of the performance data exceeds the one or more predefined thresholds; and

generate an alert if any of the data exceeds one of the predefined thresholds.

12. The apparatus of claim 11, wherein the performance data is structured query language (SQL) performance data.

13. The apparatus of claim 11, wherein the performance data comprises one or more of buffer gets, disk reads, central processing unit (CPU) time, elapsed time.

14. The apparatus of claim 11, wherein the alert is an email alert.

15. The apparatus of claim 11, where the one or more stored sequences of instructions further cause the processor to purge collected performance data.