Patent 6772411 Issued on August 3, 2004. Estimated Expiration Date: December 1, 2020. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.
717/127, Monitoring program execution717/124, Testing or debugging717/125, Having interactive or visual717/130, Including instrumentation and profiling717/131, Including analysis of program execution707/2, Access augmentation or optimizing707/102, Generating database or data structure (e.g., via user interface)714/12Synchronization maintenance of processors
A system and method for monitoring resource usage in a software system such as a database system is described. The user selects an application to monitor through a user-interface. On selection, one or more first-level statement groups associated with the application are displayed and run-time data for at least one of the displayed first-level statement groups is displayed. Illustrative run-time data indicating resource usage include the amount of processor time used to execute a first-level statement group. The user may then select a first-level statement group so that at least one second-level statement group associated with the selected first-level statement group is displayed, including various run-time data. When the selected application is a database application, a user may review run-time information associated with the execution of database packages, sections and individual SQL statements, including dynamic SQL statements.
Other References
Title: Continuous profiling: where have all the cycles gone?, author: Anderson et al, ACM, 1997.*
Title: Performance, preference, and visual scan patterns on a menu□based system: implications for interface design, author: J. J. Hendrickson, ACM, 1989.*
Title: Selectively materializing data in mediators by analyzing user queries, author:Ashish, N.; Knoblock, C.A.; Shahabi, C.; IEEE, 1989.*
Title: High-Level language debugging for concurrent programs, author: Goldszmidt et al, ACM, 1990.*
Title: Reconciling System Requirement s and Runtime Behavior, author: Feather et al, ACM, Apr. 1998.*
“4.0 Chapter 4. Monitoring Your Database,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 1 page.
“4.1 Choosing Snapshot of Event Monitoring,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 1 page.
“4.2 Tuning Configuration Parameters,” Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995 2 pages.
“4.2.1 Buffer Pool Size (buffpage), ”Database System Monitor Guide and Reference, via IBM BookManager BookServer, http://publib.boulder.ibm.com, 1995, 2 pages.
“NotesBench Disclosure Report for Lotus Notes on OS/2 Warp Server,” Lotus Product Information Database, http://www.groupware.com.au/prodinfo/2736.htm, May 18, 1996, 21 pages.