US20030110153A1 - Database performance monitoring method and tool - Google Patents
Database performance monitoring method and tool Download PDFInfo
- Publication number
- US20030110153A1 US20030110153A1 US10/013,410 US1341001A US2003110153A1 US 20030110153 A1 US20030110153 A1 US 20030110153A1 US 1341001 A US1341001 A US 1341001A US 2003110153 A1 US2003110153 A1 US 2003110153A1
- Authority
- US
- United States
- Prior art keywords
- sql
- database
- sql statement
- time
- session status
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99934—Query formulation, input preparation, or translation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99935—Query augmenting and refining, e.g. inexact access
Definitions
- the present invention relates to database performance monitoring. More particularly, the invention relates to a method and tool for monitoring the process performance of a database to obtain the time needed to process requests and statements without tracing the database.
- the network problems are largely caused by bottlenecks or limitations of the network bandwidth.
- the problem could exist within the application code written by the developer.
- Application code problems typically result from poorly or inefficiently drafted SQL statements.
- a poorly written SQL statement can be defined as one that consumes many buffers, consumes more disk input/output (i/o) than is necessary or one that runs for a long period of time.
- SQL statements that have long execution times are also those that consume many buffers and result in large disk i/o.
- database 10 is typically capable of performing a trace of the activities taking place on the database.
- the DBA can request the user to rerun the particular job at issue, and then activate the tracing feature of the database 10 .
- the tracing feature produces a trace log file 22 , which is stored on disk.
- the trace log 22 could be used by the DBA to determine the cause of the performance problems experienced by user 16 .
- the trace log file 22 is very large, usually on the order of hundreds of megabytes per trace. Because the file 22 is so large, it is difficult to analyze in a time efficient manner.
- the trace log is generated by the database 10 , the generation of the trace log 22 requires valuable system resources and CPU time. For all of these reasons, it is not operationally possible to utilize the tracing feature of database 10 on a continual basis.
- observation tool 24 monitors the status of the session and the SQL statement for the session. If the status is active, the invention looks to see what SQL statement is currently being processed and tracks how long, utilizing an accounting process, the SQL statement requires for processing.
Abstract
The present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems.
Description
- None.
- Not applicable.
- The present invention relates to database performance monitoring. More particularly, the invention relates to a method and tool for monitoring the process performance of a database to obtain the time needed to process requests and statements without tracing the database.
- Databases have seen an increase in use over the years. A database is a collection of data that is organized on a computing device so that its contents can easily be accessed, managed, and updated. The most prevalent type of database is a relational database. A relational database is a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. Databases contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. There are at least three key players in the use of these databases; a database administrator or DBA, one or more application developers, and the users within the user community. Typically, a DBA directs or performs all activities related to maintaining a successful database environment. The responsibilities of a DBA include designing, implementing and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance and use of the database management system (DBMS) and training employees in database management and use.
- Developers are charged with developing the application code used by the user community to access and utilize the database. The application code may be written in a variety of languages, such as JAVA, COBAL, or C++. However, the developer will embed Structured Query Language (SQL) within the application code, which is then used to communicate with the database. SQL is a standard interactive user and program interface language for communicating with the database, such as for getting information from the database or for updating the database. SQL queries take the form of a command language that lets the user select, insert, update and find the location of data, among other things.
- The final key player is the user within the user community. The user may be any of a number of individuals and may access the database for any of a number of reasons. One of the most important aspects of database use to the user is the response time experienced when a request is sent. Thus, one of the major tasks of developers and DBAs is lower the response time as much as possible. Over the last few years, databases have seen an enormous growth in size. This growth adds to the already challenging task of maintaining and increasing the performance of the databases. Developers must craft efficient application codes and DBAs must tune the databases to help meet the required or desired processing windows. Despite the best efforts of the developers and the DBAs, many users remain dissatisfied with the response times experienced in the use of the database.
- One of the challenges experienced by DBAs is determining the root cause of performance problems that lead to longer response times. In a typical scenario, a user will experience less than desirable response times, and will voice a concern to the DBA or developer. Typically, both the user and the developer initially take the position that the database is the source of the problem. The DBA then faces the challenge of demonstrating to the user and developer that the database may not be the root cause of the performance problem. There are three basic problem areas within the structure of a database system that could be responsible for the performance problem. First, the problem could exist within the database and its management. The database problems could result from unnecessary constraints and bottlenecks. Second, the problem could exist within the network connecting the user to the database. The network problems are largely caused by bottlenecks or limitations of the network bandwidth. Third, the problem could exist within the application code written by the developer. Application code problems typically result from poorly or inefficiently drafted SQL statements. A poorly written SQL statement can be defined as one that consumes many buffers, consumes more disk input/output (i/o) than is necessary or one that runs for a long period of time. Normally, SQL statements that have long execution times are also those that consume many buffers and result in large disk i/o.
- Thus, it typically falls upon the DBA to determine which of the above three problem areas is responsible for the poor performance. As noted above, by default, the user community typically assumes that the cause of the problem is the database. This reflects poorly on the DBA, especially if the problem is not caused by the database. The DBA can control the database management, but not the application code being used or the network and any problems associated with the network. To understand the source of the performance problems, a DBA needs to know what SQL statements the users are executing, how long each statement runs, and any process bottlenecks experienced. Unfortunately, databases existing on the market today, such as the widely used Oracle database family from Oracle Corporation, do not make this process intuitive or easy.
- If a user complains to the DBA that a particular job or request was slow in executing, the job is typically already done executing. To better understand the problem, the DBA can ask the user to rerun the job. The DBA can then use existing database tracing tools to trace the run time associated with the job. This tracing process is very accurate, but is burdensome to the database. In other words, the tracing process imposes an additional load on the database by requiring CPU cycles from the server. Moreover, the tracing process generates large trace files that often consume all of the available storage. The tracing process also consumes the time of the DBA in administering the trace and in analyzing the trace results. Because of the above noted problems, it is not practical or operationally possible to capture database-wide performance data on more than an ad-hoc basis. DBAs must use the tracing process sparingly, and thus have only a limited operational knowledge about the performance of the database, which can translate into poor user customer service.
- Currently, there is no available method or tool that can be used by DBAs to monitor the process performance of the database that does not impose a large amount of overhead on the database system and the resources of the DBA. It would be desirable to provide a method and tool for obtaining process performance data about the database and its use without imposing additional overhead on the database. It would also be desirable to provide process performance data in a manageable form that can be quickly analyzed to ascertain information about the run time of each SQL statement issued to the database.
- The present invention provides a method and system for use with database administration. More specifically, the present invention provides a method and system for monitoring the process performance of a database that accepts and records SQL statements and that records the status of a session of use of the database. The invention obtains the SQL address and hash value for each SQL statement, the current session status corresponding to each SQL statement and the previous session status corresponding to each SQL statement. The invention also records a time stamp at the time the session status information is obtained. The information gathering steps are repeated at a predetermined interval of time. Using the information gathered, the run time for each SQL statement is calculated. The run time for each SQL statement may then be reviewed to determine which SQL statements experience the greatest run time, which allows DBAs to locate the source of any performance problems. The invention includes generating reports containing the calculated run times that are easily reviewed by the DBA.
- Additional advantages and novel features will be set forth in the description which follows and in part may become apparent to those skilled in the art upon examination of the following, or may be learned by practice of the invention.
- The present invention is described in detail below with reference to the attached drawing figures, wherein:
- FIG. 1 is a schematic diagram of an overall system suitable for use in implementing the present invention; and
- FIG. 2 is a flow chart illustrative of one embodiment of the present invention.
- The present invention provides a system and method that provides DBAs an opportunity to monitor the process performance experienced by users of the database without imposing an unnecessary burden on the database. The invention combines information retained by the database to obtain approximate run times associated with identified SQL statements. A report is generated at a desired frequency which is easily analyzed to determine the root cause of any performance problems. Through use of the present invention, the performance of the database system can be enhanced on a proactive basis without the need to wait for users to complain about particular problem areas.
- The basic system used in connection with the present invention is shown in FIG. 1. As seen in FIG. 1, a
database 10 is provided.Database 10 contains, among other things, auser process pool 12 and astatement pool 14, further details of which are described more fully below.Database 10 may be accessed by a number ofusers 16 through one ormore applications 18.Users 16 can be any of a variety of people that access anduse database 10 for a variety of reasons. For example, an officer of a company may wish to utilizedatabase 10 to acquire financial data regarding the company over a period of time. Alternatively, a marketing representative of a company may wish to utilizedatabase 10 to acquire sales information. The uses ofdatabase 10 are virtually limitless.Users 16 communicate withdatabase 10 throughapplications 18.Applications 18 are typically provided by developers within thecompany utilizing database 10, such as an information services or IS group within the company. Theapplications 18 can be written in java, C++, COBAL or other languages. However, SQL is imbedded within the application code, which allows communication withdatabase 10.Database 10 understands the SQL statements and communicates any requested information back to theuser 16. The communication betweendatabase 10 andusers 16 takes place across anetwork 20. - As mentioned above,
database 10 is typically capable of performing a trace of the activities taking place on the database. Typically, if auser 16 complains to the DBA about a slow response time experienced in usingdatabase 10, the DBA can request the user to rerun the particular job at issue, and then activate the tracing feature of thedatabase 10. The tracing feature produces atrace log file 22, which is stored on disk. Thetrace log 22 could be used by the DBA to determine the cause of the performance problems experienced byuser 16. However, thetrace log file 22 is very large, usually on the order of hundreds of megabytes per trace. Because thefile 22 is so large, it is difficult to analyze in a time efficient manner. Finally, because the trace log is generated by thedatabase 10, the generation of thetrace log 22 requires valuable system resources and CPU time. For all of these reasons, it is not operationally possible to utilize the tracing feature ofdatabase 10 on a continual basis. - The invention provides an
observation tool 24 to address the above noted deficiencies withtrace log file 22.Observation tool 24 communicates withdatabase 10 to observe the process performance experienced byusers 16 in their interaction withdatabase 10.Observation tool 24 can be used to continually monitor thedatabase 10 and can produce a report that is more easily analyzed by a DBA than thetrace log file 22. The report generated is much smaller than thetrace log file 22 and therefore consumes far less disk space than thetrace log file 22. The methodology used byobservation tool 24 is discussed in detail with reference to FIG. 2. Prior to the discussion of FIG. 2, further details ofdatabase 10,user process pool 12 andstatement pool 14 will be described. -
Database 10 is a relational database that is in common use today. As an example, the invention is particularly suited for use with an Oracle Corporation database. The database accepts SQL statements for processing from theusers 16 throughapplications 18. Within thedatabase 10 are theuser process pool 12 and theSQL statement pool 14.User process pool 12 collects and stores a variety of information about theusers 16.User process pool 12 stores the username for theuser 16, the login time, the status of the process, the SQL hash value and SQL address, the previous SQL hash value and the previous SQL address. The status of the process is either active or inactive. An active process is one for which a SQL statement has been received by thedatabase 10 that thedatabase 10 is still working on. In other words, an active process in one that has not yet been completed. The SQL hash value and SQL address map to a corresponding SQL hash value and SQL address within theSQL statement pool 14. The SQL hash value and SQL address indicate the current SQL statement that is being processed by thedatabase 10 for theparticular user 16. The previous SQL hash value and the previous SQL address indicate the immediately preceding SQL statement that was processed by thedatabase 10 for theparticular user 16. Importantly, theuser process pool 12 does not contain any run time information regarding the SQL statements being processed. Thedatabase 10 thus tracks the SQL statements being submitted but does not track the run time associated with each SQL statement.SQL statement pool 14 contains, among other things, unique SQL hash values and SQL addresses that correspond to SQL statements. In addition, theSQL statement pool 14 may contain information regarding memory usage and disc usage. Therefore, thepools - When a
user 16 logs into thedatabase 10, the user name and login time are recorded inuser pool 12. When theuser 16 submits a statement or request to thedatabase 10, the status of the process becomes active. In addition, the SQL hash value and address are recorded. For example, suppose User1 submits Query1 to the database. User1 is recorded in the 20user pool 12 and Query1 is recorded in thestatement pool 14. As soon as the user hits enter, the status of the process is updated to active withinuser pool 12 because the SQL query is now being processed by thedatabase 10. This information is used byobservation tool 24 to generate a report for the DBA regarding the process performance experienced byusers 16. In other words,observation tool 24 tracks and records the run time experienced by each user for the particular SQL statements being submitted. - The methodology used by
observation tool 24 is best understood with reference to FIG. 2. Broadly, the invention monitors the status of the session and the SQL statement for the session. If the status is active, the invention looks to see what SQL statement is currently being processed and tracks how long, utilizing an accounting process, the SQL statement requires for processing. - The methodology begins by recording a time stamp, as shown at26 in FIG. 2. The time stamp is used as a reference so that the status of the session and the address and hash value of the SQL statements at a specific point in time are known. The process continues by obtaining the address and hash value of the SQL statements for a particular user, as shown at 28. The session status is also obtained, as shown at 30. The session status reflects whether the
database 10 is still processing the SQL statement and is active, or is done processing the SQL statement and is inactive. A number of different scenarios are accounted for in the remaining process of FIG. 2. The scenarios depend on whether the address and hash value are new or old, whether the session status is active or inactive, and whether the previous session status is active or inactive. The first step in determining which of the scenarios is taking place is to determine whether the address and hash value obtained instep 28 are new or old, as shown by 32. - If the address and hash value are new, it means that a new SQL statement is being processed by
database 10 that has not previously been processed for that particular session. If the address and hash value are new, the process continues by determining whether the status of the session is active or inactive, as shown at 34. If the status of the session is active, it means that thedatabase 10 is still processing the new SQL statement. As such, the time needed to process the SQL statement needs to be accounted for. To that end, a time charge is noted and added to the time required by this particular SQL statement, as shown at 36. - In a preferred embodiment, the process of FIG. 2 is executed on a regular incremental time basis, such as every ten minutes. The time interval can be decreased or increased depending on the accuracy needs of the DBA. For example, by reducing the time interval, the accuracy of the information obtained increases. As noted at
step 36, a partial time increment is added to the time charge for the SQL statement. In a preferred embodiment, the time charge added atstep 36 is twenty-five percent of the given time increment. In other words, if the time interval being used in the process of FIG. 2 is set to ten minutes, the scenario ending atstep 36 would result in a charge of 2.5 minutes being added to the record for the particular SQL statement being executed by aparticular user 16. - If the status is determined to be inactive at
step 34, then no charge is added to the record for the new SQL statement, as shown at 38. This scenario reflects the case where a new SQL statement is experienced by the session, but which has been processed by thedatabase 10 within the time interval that has been set. In other words, if the time interval is ten minutes, the new SQL statement is received and executed bydatabase 10 within the ten minute interval. Because the SQL statement is executed within the interval, no charge is recorded for the SQL statement. - Returning to step32, if the SQL address and hash value obtained for the user are determined to be old, the process continues at
step 40 by checking the previous session status. As shown at 42, the process determines whether the previous session status was active. This information is used along with the current session status. Therefore, if the previous session status was active, the current session status is determined, as shown at 44. If the current session status is active, a time charge is added to the record for this SQL statement and user as shown at 46. Because the previous session status was active and the current session status is active, thedatabase 10 was processing the SQL statement for the full interval. Thus, the full time interval is added to the time charge in this instance. If the time interval is ten minutes, then a ten minute time charge is added to the record for the SQL statement. Returning to step 44, if the current session status is determined to be inactive, a partial interval time charge is added to the record for the SQL statement and user, as shown at 48. The session status is also reset to inactive, as shown at 50. This scenario applies to a situation where the SQL statement was being processed by the session in the previous time interval, but processing was completed sometime during the current time interval. Thus, only a partial-interval time charge is added to the record for the SQL statement since thedatabase 10 is not processing the SQL statement for the full time interval. As an example, half of the time interval can be added to the time record for the SQL statement. If the time interval is ten minutes, a five minute time charge can be added to the time record for the SQL statement. - Returning to step42, if the previous session status is determined to be inactive, the current session status is determined at 52. If the current session status is active, a partial time charge is added to the record for the SQL statement as shown at 54. This scenario addresses the situation where the SQL statement has been seen before by the session, the previous session status was inactive, but the current session status is active. Because the
database 10 is not processing the SQL statement for the full length of the interval, only a partial time charge is added, and the session status is reset to active as shown at 56. As an example, if the time interval is ten minutes, a partial time charge of half the interval, or five minutes, can be added to the time charge for the SQL statement. If, however, the current session status is determined to be inactive instep 52, no charge is added to the time record, as shown at 58. This reflects the scenario where the SQL statement is old for the session, but the previous and current session status are inactive. In this scenario, the SQL statement is merely waiting to be aged out of the least recently used (LRU) list. - After
steps user 16 submits a query todatabase 10 throughapplication 18,observation tool 24 operates as described with reference to FIG. 2 to monitor the session. Each SQL statement in the session is tracked and a run time for the statement is recorded. The process of FIG. 2 is used to total the run time for each SQL statement. It should also be understood that certain sessions are not activated by auser 16, but are scheduled queries that run on a regular basis. These sessions may be known as batchjobs and the invention applies equally to the execution of batch jobs as well. - The invention thus gathers a time stamp, a user identification such as the username, the SQL address and hash value and the session status information. This information is used to calculate the run time for each SQL statement received by
database 10. Using this information, the DBA can demonstrate to developers and the user community the source of the performance problems. The SQL statements having long run times can be identified, and the application code associated with the SQL statements can be revised to improve the efficiency of the code. - The invention can be used to generate a report that is useful to the DBA on a regular basis. The report will preferably contain the user name, the SQL address, the SQL hash value, the SQL statement text and the execution time of the SQL statement calculated as described above with reference to FIG. 2. It can therefore be seen that the present invention can be used to extract SQL statements from the
database 10 and determine the run time associated with each SQL statement, without imposing the overhead required by tracing the database. The invention provides the user community a better level of customer service and allows the DBA to focus tuning efforts on long-running application statements. - Alternative embodiments of the present invention become apparent to those skilled in the art to which it pertains upon review of the specification, including the drawing figures. The various computer systems and components shown in FIG. 1 and described in the specification are merely exemplary of those suitable for use in connection with the present invention. Accordingly, the scope of the present invention is defined by the appended claims rather than the foregoing description.
Claims (13)
1. A method for use in a computer system for monitoring the process performance of a database, the database accepting and recording SQL statements and recording the status of a session of use of the database, the method comprising:
obtaining a SQL address and hash value for each SQL statement;
obtaining a current session status corresponding to each SQL statement;
recording a time stamp at the time the current session status is obtained;
repeating the obtaining steps and the time stamp recording step at a plurality of time intervals; and
calculating a run time for each SQL statement based upon the obtained SQL address and hash value, the time stamp and the current session status,
whereby the run time for each SQL statement may be reviewed to determine which SQL statements experience the greatest run time.
2. The method of claim 1 , wherein the calculating step further comprises:
determining whether each SQL statement is new to the database session, and if so, determining whether the current session status is active and applying an addition to the run time for the SQL statement if the current session status is active.
3. The method of claim 2 , where the addition to the run time is a portion of the time interval.
4. The method of claim 3 , where the portion is one-quarter of the time interval.
5. The method of claim 1 , wherein the calculating step further comprises:
obtaining the previous session status corresponding to each SQL statement;
determining whether each SQL statement is new to the database session, and if not, determining the previous session status for the SQL statement and the current session status for the SQL statement; and
applying a first addition to the run time for the SQL statement if the previous session status is active.
6. The method of claim 5 , further comprising applying a second addition to the run time for the SQL statement if the previous session status is inactive and the current session status is active.
7. The method of claim 6 , where the second addition to the run time if the previous session status is inactive and the current session status is active is a portion of the time interval.
8. The method of claim 5 , where the first addition to the run time if the previous session status and the current session status is active is the fall amount of the time interval.
9. The method of claim 5 , where the first addition to the run time if the previous session status is active and the current session status is inactive is a portion of the time interval.
10. The method of claim 1 , further comprising generating a report containing a listing of each SQL statement and the run time corresponding to each SQL statement.
11. The method of claim 10 , where the report contains the SQL address and hash value.
12. A computer-readable medium having computer-executable instructions for performing a method for monitoring the process performance of a database, the database accepting and recording SQL statements and recording the status of a session of use of the database, comprising:
obtaining the SQL address and hash value for each SQL statement;
obtaining the current session status corresponding to each SQL statement;
recording a time stamp at the time the session status is obtained;
repeating the obtaining steps and the time stamp recording step at a plurality of time intervals; and
calculating the run time for each SQL statement based upon the obtained SQL address and hash value, the time stamp and upon the current session status,
whereby the run time for each SQL statement may be reviewed to determine which SQL statements experience the greatest run time.
13. A computer system having a processor, a memory, and an operating environment, the computer system operable to execute a method for monitoring the process performance of a database, the database accepting and recording SQL statements and recording the status of a session of use of the database, comprising:
obtaining the SQL address and hash value for each SQL statement;
obtaining the current session status corresponding to each SQL statement;
recording a time stamp at the time the session status is obtained;
repeating the obtaining steps and the time stamp recording step at a plurality of time intervals; and
calculating the run time for each SQL statement based upon the obtained SQL address and hash value, the time stamp and upon the current session status,
whereby the run time for each SQL statement may be reviewed to determine which SQL statements experience the greatest run time.
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/013,410 US20030110153A1 (en) | 2001-12-11 | 2001-12-11 | Database performance monitoring method and tool |
US10/051,903 US6910036B1 (en) | 2001-12-11 | 2002-01-17 | Database performance monitoring method and tool |
US11/129,109 US7325016B1 (en) | 2001-12-11 | 2005-05-13 | Monitoring database performance by obtaining SQL addresses for SQL statements |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/013,410 US20030110153A1 (en) | 2001-12-11 | 2001-12-11 | Database performance monitoring method and tool |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/051,903 Continuation US6910036B1 (en) | 2001-12-11 | 2002-01-17 | Database performance monitoring method and tool |
Publications (1)
Publication Number | Publication Date |
---|---|
US20030110153A1 true US20030110153A1 (en) | 2003-06-12 |
Family
ID=21759827
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/013,410 Abandoned US20030110153A1 (en) | 2001-12-11 | 2001-12-11 | Database performance monitoring method and tool |
US10/051,903 Expired - Lifetime US6910036B1 (en) | 2001-12-11 | 2002-01-17 | Database performance monitoring method and tool |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/051,903 Expired - Lifetime US6910036B1 (en) | 2001-12-11 | 2002-01-17 | Database performance monitoring method and tool |
Country Status (1)
Country | Link |
---|---|
US (2) | US20030110153A1 (en) |
Cited By (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1519282A2 (en) * | 2003-09-25 | 2005-03-30 | Sap Ag | A method and system for gathering information regarding the operation of a computing system |
US20050097091A1 (en) * | 2003-09-06 | 2005-05-05 | Oracle International Corporation | SQL tuning base |
US20050256884A1 (en) * | 2002-04-18 | 2005-11-17 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
GB2425625A (en) * | 2005-04-28 | 2006-11-01 | Cogito Ltd | Database performance analysis |
US20060248080A1 (en) * | 2005-04-28 | 2006-11-02 | Jon Gray | Information processing system and method |
US7210073B1 (en) * | 2003-12-31 | 2007-04-24 | Precise Software Solutions Ltd. | Workflows for performance management methodology |
US7321893B1 (en) * | 2004-07-29 | 2008-01-22 | Emc Corporation | System and method for the configuration of resources in resource groups |
US20080028382A1 (en) * | 2002-05-23 | 2008-01-31 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US7430557B1 (en) * | 2003-03-19 | 2008-09-30 | Unisys Corporation | System and method for improving database reorganization time |
US7509330B2 (en) | 2004-09-03 | 2009-03-24 | Crossroads Systems, Inc. | Application-layer monitoring of communication between one or more database clients and one or more database servers |
US7529753B1 (en) * | 2004-09-03 | 2009-05-05 | Crossroads Systems, Inc. | Providing application-layer functionality between one or more database clients and one or more database servers |
US20090327854A1 (en) * | 2008-06-30 | 2009-12-31 | Yahoo!, Inc. | Analysis of Database Performance Reports for Graphical Presentation of Summary Results |
US7970776B1 (en) * | 2008-08-06 | 2011-06-28 | Precise Software Solutions Inc. | Apparatus, method and computer readable medium for identifying and quantifying database disk-sort operations |
US20140298471A1 (en) * | 2013-03-27 | 2014-10-02 | International Business Machines Corporation | Evaluating Security of Data Access Statements |
CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
CN108460079A (en) * | 2018-01-08 | 2018-08-28 | 平安科技(深圳)有限公司 | database monitoring method, device, terminal device and storage medium |
CN112115158A (en) * | 2020-09-04 | 2020-12-22 | 浪潮电子信息产业股份有限公司 | SQL statement execution time recording method, device, equipment and readable storage medium |
CN112527620A (en) * | 2020-12-24 | 2021-03-19 | 北京百度网讯科技有限公司 | Database performance analysis method and device, electronic equipment, medium and product |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050049999A1 (en) * | 2003-08-29 | 2005-03-03 | Immo-Gert Birn | Database access statement tracing |
DE102004051063A1 (en) * | 2004-10-19 | 2006-04-20 | Thyssenkrupp Elastomertechnik Gmbh | Internal mixer for kneading plastic masses |
US7756840B2 (en) * | 2004-11-03 | 2010-07-13 | DBA InfoPower Inc. | Real-time database performance and availability monitoring method and system |
US7203624B2 (en) * | 2004-11-23 | 2007-04-10 | Dba Infopower, Inc. | Real-time database performance and availability change root cause analysis method and system |
US20060200496A1 (en) * | 2005-02-22 | 2006-09-07 | Transparency Software, Inc. | Organization action incidents |
US9285856B2 (en) | 2010-12-21 | 2016-03-15 | Qualcomm Incorporated | Method and system for rapid entry into and for rapid exiting from sleep states for processors of a portable computing device |
US9104499B2 (en) | 2010-12-21 | 2015-08-11 | Qualcomm Incorporated | System for minimizing resource latency between processor application states in a portable computing device by scheduling resource state set transitions |
US8954980B2 (en) * | 2011-11-11 | 2015-02-10 | Qualcomm Incorporated | Conserving power through work load estimation for a portable computing device using scheduled resource set transitions |
US11048677B1 (en) | 2014-10-01 | 2021-06-29 | Servicenow, Inc. | Streamlined transaction and dimension data collection |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5778354A (en) * | 1995-06-07 | 1998-07-07 | Tandem Computers Incorporated | Database management system with improved indexed accessing |
-
2001
- 2001-12-11 US US10/013,410 patent/US20030110153A1/en not_active Abandoned
-
2002
- 2002-01-17 US US10/051,903 patent/US6910036B1/en not_active Expired - Lifetime
Cited By (52)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050256884A1 (en) * | 2002-04-18 | 2005-11-17 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US7617181B2 (en) | 2002-04-18 | 2009-11-10 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US20080027999A1 (en) * | 2002-04-18 | 2008-01-31 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US8639710B2 (en) * | 2002-04-18 | 2014-01-28 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US20060294080A1 (en) * | 2002-04-18 | 2006-12-28 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US9146974B2 (en) | 2002-04-18 | 2015-09-29 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US7653620B2 (en) | 2002-05-23 | 2010-01-26 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US20080034007A1 (en) * | 2002-05-23 | 2008-02-07 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US20080028382A1 (en) * | 2002-05-23 | 2008-01-31 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US7912848B2 (en) | 2002-05-23 | 2011-03-22 | International Business Machines Corporation | Dynamic optimization of prepared statements in a statement pool |
US7430557B1 (en) * | 2003-03-19 | 2008-09-30 | Unisys Corporation | System and method for improving database reorganization time |
US20050125393A1 (en) * | 2003-09-06 | 2005-06-09 | Oracle International Corporation | SQL tuning sets |
US20050125398A1 (en) * | 2003-09-06 | 2005-06-09 | Oracle International Corporation | Global hints |
US20050177557A1 (en) * | 2003-09-06 | 2005-08-11 | Oracle International Corporation | Automatic prevention of run-away query execution |
US8983934B2 (en) * | 2003-09-06 | 2015-03-17 | Oracle International Corporation | SQL tuning base |
US8825629B2 (en) | 2003-09-06 | 2014-09-02 | Oracle International Corporation | Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer |
US20050138015A1 (en) * | 2003-09-06 | 2005-06-23 | Oracle International Corporation | High load SQL driven statistics collection |
US20050125427A1 (en) * | 2003-09-06 | 2005-06-09 | Oracle International Corporation | Automatic SQL tuning advisor |
US7664730B2 (en) | 2003-09-06 | 2010-02-16 | Oracle International Corporation | Method and system for implementing a SQL profile |
US20050125452A1 (en) * | 2003-09-06 | 2005-06-09 | Oracle International Corporation | SQL profile |
US20050187917A1 (en) * | 2003-09-06 | 2005-08-25 | Oracle International Corporation | Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer |
US20050119999A1 (en) * | 2003-09-06 | 2005-06-02 | Oracle International Corporation | Automatic learning optimizer |
US20050120000A1 (en) * | 2003-09-06 | 2005-06-02 | Oracle International Corporation | Auto-tuning SQL statements |
US7805411B2 (en) | 2003-09-06 | 2010-09-28 | Oracle International Corporation | Auto-tuning SQL statements |
US7747606B2 (en) | 2003-09-06 | 2010-06-29 | Oracle International Corporation | Automatic SQL tuning advisor |
US7739263B2 (en) | 2003-09-06 | 2010-06-15 | Oracle International Corporation | Global hints |
US20050120001A1 (en) * | 2003-09-06 | 2005-06-02 | Oracle International Corporation | SQL structure analyzer |
US7634456B2 (en) | 2003-09-06 | 2009-12-15 | Oracle International Corporation | SQL structure analyzer |
US7664778B2 (en) | 2003-09-06 | 2010-02-16 | Oracle International Corporation | SQL tuning sets |
US20050097091A1 (en) * | 2003-09-06 | 2005-05-05 | Oracle International Corporation | SQL tuning base |
EP1519282A3 (en) * | 2003-09-25 | 2005-11-30 | Sap Ag | A method and system for gathering information regarding the operation of a computing system |
EP1519282A2 (en) * | 2003-09-25 | 2005-03-30 | Sap Ag | A method and system for gathering information regarding the operation of a computing system |
US7210073B1 (en) * | 2003-12-31 | 2007-04-24 | Precise Software Solutions Ltd. | Workflows for performance management methodology |
US7321893B1 (en) * | 2004-07-29 | 2008-01-22 | Emc Corporation | System and method for the configuration of resources in resource groups |
US20090138487A1 (en) * | 2004-09-03 | 2009-05-28 | Crossroads Systems, Inc. | Application-Layer Monitoring of Communication Between One or More Database Clients and One or More Database Servers |
US7529753B1 (en) * | 2004-09-03 | 2009-05-05 | Crossroads Systems, Inc. | Providing application-layer functionality between one or more database clients and one or more database servers |
US7509330B2 (en) | 2004-09-03 | 2009-03-24 | Crossroads Systems, Inc. | Application-layer monitoring of communication between one or more database clients and one or more database servers |
US7895160B2 (en) | 2004-09-03 | 2011-02-22 | Crossroads Systems, Inc. | Application-layer monitoring of communication between one or more database clients and one or more database servers |
US20060248080A1 (en) * | 2005-04-28 | 2006-11-02 | Jon Gray | Information processing system and method |
US7877378B2 (en) | 2005-04-28 | 2011-01-25 | Cogito Ltd | System and method for consolidating execution information relatin to execution of instructions by a database management system |
GB2425625A (en) * | 2005-04-28 | 2006-11-01 | Cogito Ltd | Database performance analysis |
US20090327854A1 (en) * | 2008-06-30 | 2009-12-31 | Yahoo!, Inc. | Analysis of Database Performance Reports for Graphical Presentation of Summary Results |
US8156421B2 (en) * | 2008-06-30 | 2012-04-10 | Yahoo! Inc. | Analysis of database performance reports for graphical presentation of summary results |
US7970776B1 (en) * | 2008-08-06 | 2011-06-28 | Precise Software Solutions Inc. | Apparatus, method and computer readable medium for identifying and quantifying database disk-sort operations |
US10693877B2 (en) | 2013-03-27 | 2020-06-23 | International Business Machines Corporation | Evaluating security of data access statements |
US9680830B2 (en) * | 2013-03-27 | 2017-06-13 | International Business Machines Corporation | Evaluating security of data access statements |
US20140298471A1 (en) * | 2013-03-27 | 2014-10-02 | International Business Machines Corporation | Evaluating Security of Data Access Statements |
US11228595B2 (en) | 2013-03-27 | 2022-01-18 | International Business Machines Corporation | Evaluating security of data access statements |
CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
CN108460079A (en) * | 2018-01-08 | 2018-08-28 | 平安科技(深圳)有限公司 | database monitoring method, device, terminal device and storage medium |
CN112115158A (en) * | 2020-09-04 | 2020-12-22 | 浪潮电子信息产业股份有限公司 | SQL statement execution time recording method, device, equipment and readable storage medium |
CN112527620A (en) * | 2020-12-24 | 2021-03-19 | 北京百度网讯科技有限公司 | Database performance analysis method and device, electronic equipment, medium and product |
Also Published As
Publication number | Publication date |
---|---|
US6910036B1 (en) | 2005-06-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6910036B1 (en) | Database performance monitoring method and tool | |
US6052694A (en) | Method and apparatus for logging database performance characteristics | |
US6901405B1 (en) | Method for persisting a schedule and database schema | |
US7194451B2 (en) | Database monitoring system | |
US6223171B1 (en) | What-if index analysis utility for database systems | |
US7797286B2 (en) | System and method for externally providing database optimizer statistics | |
US7107262B2 (en) | Incremental data query performance feedback model | |
US8078631B2 (en) | Research rapidity and efficiency improvement by analysis of research artifact similarity | |
US7877378B2 (en) | System and method for consolidating execution information relatin to execution of instructions by a database management system | |
US8024296B1 (en) | Method and apparatus for agent-less auditing of server | |
US20040243555A1 (en) | Methods and systems for optimizing queries through dynamic and autonomous database schema analysis | |
Heymann et al. | Turkalytics: analytics for human computation | |
US7325016B1 (en) | Monitoring database performance by obtaining SQL addresses for SQL statements | |
US8458215B2 (en) | Dynamic functional module availability | |
US20080065588A1 (en) | Selectively Logging Query Data Based On Cost | |
US6816874B1 (en) | Method, system, and program for accessing performance data | |
KR20040027270A (en) | Method for monitoring database system | |
US8086574B2 (en) | Usage-based optimization of network traffic and data warehouse size | |
CN113886205A (en) | Database performance bottleneck positioning analysis method, device and system and storage medium | |
US20090157742A1 (en) | On Demand Capture of Database Application Environmental Resources | |
US20180173805A1 (en) | Application programming interface for detection and extraction of data changes | |
Pollack et al. | Monitoring Indexes | |
Schumacher | Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts | |
Lee et al. | Optimization of DB Server and Web Server to Enhance the Performance of ECM | |
Pollack et al. | Index Analysis |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: SPRINT COMMUNICATIONS COMPANY, L.P., MISSOURI Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:SHEE, DEK J.;REEL/FRAME:012381/0175 Effective date: 20011206 |
|
STCB | Information on status: application discontinuation |
Free format text: EXPRESSLY ABANDONED -- DURING EXAMINATION |