Method and mechanism for profiling a system

• US 6,760,684 B1
• Filed: 02/26/2003
• Issued: 07/06/2004
• Est. Priority Date: 04/30/1999
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Yang, Tao-Heng, Rist, Andrew
• Primary Examiner(s): Hoff, Marc S.
• Assistant Examiner(s): Tsai, Carol S. W.
• Application Number:
  US10/376,678
• Time in Patent Office: 496 Days
• Field of Search: 702/108, 702/113, 702/114, 702/115, 702/118-123, 702/179, 702/182-188, 709/229, 709/228, 709/225, 709/241, 709/224, 714/721, 707/1, 707/2, 707/3, 707/4
• US Class Current: 702/182
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 2201/865 Monitoring of software
• CPC Class Codes: G06F 2201/87 Monitoring of transactions

Abstract

Disclosed is a method and mechanism for sizing a hardware system for a software workload. An aspect is directed to modeling a workload into a set of generic system activities, in which the generic system activities are not directly tied to a specific hardware platform. Another aspect is directed to profiling hardware systems or hardware components into the generic system activities. Suitable hardware systems or components are selected by analyzing the workload and hardware profiles in terms of the generic system activities.

Claims

1. A method for deriving parametric data for a hardware system, comprising:

executing a first software statement, said first software statement involving a first operation of a system activity, said system activity not directly associated with a specific hardware platform;

recording a first set of performance results based upon execution of said first software statement;

executing a second software statement, said second software statement involving a second operation of said system activity;

recording a second set of performance results based upon execution of said second software statement;

comparing said first set of performance results against said second set of performance results; and

deriving parametric data for said hardware system based upon comparison of said first set of performance results against said second set of performance results.

2. The method of claim 1 in which said first software statement is executed a plurality of times.

3. The method of claim 2 in which said first set of performance results comprise an average of results for multiple executions of said first software statement.

4. The method of claim 1 further comprising:

executing a third software statement, said third software statement involving a third operation of said system activity;

recording a third set of performance results based upon execution of said third software statement;

comparing said third set of performance results against said first set of performance results; and

profiling said hardware system based upon comparison of said third set of performance results against said first set of performance results.

5. The method of claim 1 in which said first software statement involves an operation of a second system activity, said second system activity differing from said first system activity.

6. The method of claim 1 in which said first and second software statements comprise database statements.

7. The method of claim 6 in which said database statements comprise SQL statements.

8. The method of claim 1 in which numeric methods for solving simultaneous equations are used to compare said first set of performance results against said second set of performance results.

9. The method of claim 8 in which said numeric methods for solving simultaneous equations comprise linear programming.

10. The method of claim 8 in which said numeric methods for solving simultaneous equation comprise taking the difference between said first set of performance results and said second set of performance results.

11. The method of claim 1 in which said system activity comprises a set of activities used to characterize a database.

12. The method of claim 1 in which said system activity comprises an activity selected from the group consisting of logical reads, physical reads, logical writes, physical writes, log writes, log reads, sequential reads, sequential writes, random reads, random writes, and network usage.

13. A computer program product that includes a medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a process for deriving parametric data for a hardware system, said process comprising:

executing a first software statement, said first software statement involving a first operation of a system activity, said system activity not directly associated with a specific hardware platform;

recording a first set of performance results based upon execution of said first software statement;

executing a second software statement, said second software statement involving a second operation of said system activity;

recording a second set of performance results based upon execution of said second software statement;

comparing said first set of performance results against said second set of performance results; and

deriving parametric data for said hardware system based upon comparison of said first set of performance results against said second set of performance results.

14. The computer program product of claim 13 in which said first software statement is executed a plurality of times.

15. The computer program product of claim 13 further comprising:

executing a third software statement, said third software statement involving a third operation of said system activity;

recording a third set of performance results based upon execution of said third software statement;

comparing said third set of performance results against said first set of performance results; and

profiling said hardware system based upon comparison of said third set of performance results against said first set of performance results.

16. The computer program product of claim 13 in which said first software statement involves an operation of a second system activity, said second system activity differing from said first system activity.

17. The computer program product of claim 13 in which said first an second software statements comprise database statements.

18. The computer program product of claim 13 in which numeric methods for solving simultaneous equations are used to compare said first set of performance results against said second set of performance results.

19. The computer program product of claim 13 in which said system activity comprises a set of activities used to characterize a database.

20. A system for deriving parametric data for a hardware system, comprising:

means for executing a first software statement, said first software statement involving a first operation of a system activity, said system activity not directly associated with a specific hardware platform;

means for recording a first set of performance results based upon execution of said first software statement;

means for executing a second software statement, said second software statement involving a second operation of said system activity;

means for recording a second set of performance results based upon execution of said second software statement;

means for comparing said first set of performance results against said second set of performance results; and

means for deriving parametric data for said hardware system based upon comparison of said first set of performance results against said second set of performance results.

21. The system of claim 20 in which said first software statement is executed a plurality of times.

22. The system of claim 20 further comprising:

means for executing a third software statement, said third software statement involving a third operation of said system activity;

means for recording a third set of performance results based upon execution of said third software statement;

means for comparing said third set of performance results against said first set of performance results; and

means for profiling said hardware system based upon comparison of said third set of performance results against said first set of performance results.

23. The system of claim 20 in which said first software statement involves an operation of a second system activity, said second system activity differing from said first system activity.

24. The system of claim 20 in which said first an second software statements comprise database statements.

25. The system of claim 20 in which numeric methods for solving simultaneous equations are used to compare said first set of performance results against said second set of performance results.

26. The system of claim 20 in which said system activity comprises a set of activities used to characterize a database.