JP4708838B2 - Terminal device and diagnostic program - Google Patents

Description

  The present invention relates to a technique for diagnosing a database in consideration of a load state of a server during SQL execution.

  Conventionally, a script for diagnosing a database has been executed irrespective of the load status at the time of script execution in the server having the database (for example, Patent Document 1 or 2). In other words, once executed, all SQL (Structured Query Language) in the script is executed, and the server load status by other programs during the script execution period is not considered. The execution of SQL consumes server system resources such as a CPU and memory, so there is no problem if the server system resources are sufficient, but if there is no room, there is a considerable load on the server.

  For this reason, the diagnosis script is usually executed aiming at a time zone when the load on the server by another program is low. However, since the execution time of the diagnostic script varies from several minutes to several tens of minutes depending on the database status such as the amount of data, the server load status by other programs often changes during the execution period of the diagnostic script. It was. When the load on the server due to the diagnostic script and other programs becomes extremely large, problems such as excess or interruption of the execution time of each program and freezing of the server occur.

  Note that Non-Patent Document 1 is given as a conventional technique related to database diagnosis, monitoring, and management.

JP-A-8-233503 JP-A-9-282210 "Oracle Enterprise Manager Overview 10g Release 1 (10.1)" Oracle Japan Part Number: B13503-02

  The present invention has been made in view of the above points. By weighting each SQL element of a script to be executed, whether or not to execute a predetermined SQL based on the load status of the server having the database is determined. It is an object to provide a diagnostic program for determination.

  One aspect of the present invention is a terminal device communicably connected to a diagnosis target server having a database for diagnosis, and a plurality of SQLs executed in the diagnosis target server and additional information set in each SQL An SQL list creating means for creating an SQL list, which is an array composed of the SQL and the additional information, based on a diagnostic script comprising: an array composed of the SQL and the additional information from the SQL list Based on the additional information read by the reading means, a determination value acquisition means for acquiring a determination value representing an operational load from the diagnosis target server, the determination value acquired by the determination value acquisition means, and Based on the additional information read by the reading means, the SQL read by the reading means is changed to the diagnosis target server. An execution determination unit that determines whether or not to execute, an SQL transmission unit that transmits the SQL read by the reading unit to the diagnosis target server when the execution determination unit determines to execute, and the SQL transmission unit Execution result receiving means for acquiring the execution result of the SQL transmitted from the server to be diagnosed.

  The terminal device configured as described above is a personal computer or PDA (Personal Digital Assistants) that can exchange data with a diagnosis target server via a network. First, the terminal device reads a diagnostic script, which is an external file, to create a SQL list including one or more arrays each including SQL and additional information. That is, the SQL and additional information described in the diagnostic script are all stored in the SQL list as an array in the initial stage. And a terminal device reads the arrangement | sequence comprised from SQL and additional information from a SQL list | wrist. Further, the terminal device acquires a determination value representing the operational load from the diagnosis target server based on the read additional information. Then, the terminal device determines whether or not to execute the read SQL in the diagnosis target server based on the acquired determination value and the additional information. That is, it is determined whether to execute each SQL according to the load status of the diagnosis target server. Further, since it is possible to arbitrarily set additional information for each SQL, it is possible to make a determination according to each SQL. And only when it is determined that the SQL is to be executed, the terminal device transmits the SQL to the diagnosis target server and receives the execution result. According to this, while confirming the load status of the diagnosis target server, only the SQL that can be issued at that time is executed, and the load during the diagnosis script execution period can always be kept low. Therefore, the problem of freezing due to an extreme increase in the load on the diagnosis target server can be solved as in the past.

  In one aspect of the terminal device, the additional information includes a determination function and a threshold value for calculating the determination value, and the determination value acquisition unit is included in the additional information read by the reading unit. A result of a determination function is acquired as the determination value, and the terminal device compares the determination value acquired by the determination value acquisition unit and a threshold value included in the additional information read by the reading unit. A determination value comparing means for determining whether or not the SQL read by the reading means is to be executed in the diagnosis target server based on a result of the determination value comparing means.

  In the terminal device configured as described above, the additional information set in each SQL includes a determination value and a threshold value. That is, it is possible to arbitrarily set a unique determination value and threshold value for each SQL. Here, the determination value is a result of the determination function, and is a value representing the operation load of the diagnosis target server at the time of SQL execution determination. On the other hand, the threshold value is a constant value that serves as a reference for the operation load of the diagnosis target server, which is a comparison target of the determination value in order to determine execution of SQL. The terminal device determines whether or not to execute SQL based on the comparison result between the determination value and the threshold value. In other words, the terminal apparatus determines to execute SQL only when the load represented by the determination value is smaller than the load represented by the threshold value, which is a guideline arbitrarily defined in advance. Note that the process of executing the determination function and acquiring the determination value is hardly a load on the diagnosis target server. According to this, the operation load of the diagnosis target server at the SQL execution determination time can be clearly acquired as a numerical value by the determination value. In addition, since the threshold value, which is a guideline arbitrarily defined in advance, is compared with the determination value, the SQL execution determination can be performed by clearly reflecting the operation load of the diagnosis target server.

  In another aspect of the terminal device, the terminal device has an executed SQL list that is an array composed of SQL executed in the diagnosis target server and additional information set in the SQL, It further includes an executed SQL list moving means for moving an array composed of the SQL transmitted by the SQL transmitting means and the additional information set in the SQL from the SQL list to the executed SQL list. According to this, an array composed of already executed SQL and additional information does not exist in the SQL list. Therefore, it can be prevented that the SQL execution determination unit determines whether or not to execute the SQL already executed.

  In another aspect of the terminal device, the additional information includes a movement function indicating a position to move in the SQL list, and the reading unit reads when the execution determining unit determines not to execute the additional information. SQL list moving means for moving an array composed of the SQL and additional information set in the SQL in the SQL list based on a transfer function included in the additional information is further provided. According to this, even if the SQL is determined not to be executed once by the SQL execution determination means, it is moved again into the SQL list. Therefore, after the load status of the diagnostic processing server is reduced, it is possible to perform the SQL execution determination again and execute the SQL.

  In another aspect of the terminal device, the SQL list moving unit moves the array to the end of the SQL list based on the transfer function. According to this, the SQL determined that the SQL execution determination unit does not execute once moves to the last position in the SQL list. Therefore, when the load status of the diagnostic processing server is reduced while execution determination is performed on another SQL existing in the SQL list, the SQL can be executed by re-execution of SQL execution.

  In another aspect of the terminal device, the SQL list moving means moves the array to the beginning of the SQL list based on the transfer function. According to this, the SQL determined that the SQL execution determination unit does not execute once moves to the position at the beginning of the SQL list. Therefore, even when the order of SQL is significant, it is possible to execute SQL in the order described in the diagnostic script in advance.

  In another aspect of the terminal device, the SQL list moving unit moves the array to an arbitrary position set in advance in the SQL list based on the transfer function. According to this, it is possible to move the SQL that is determined not to be executed once by the SQL execution determination unit to an arbitrary position in the SQL list.

  In another aspect of the terminal device, the additional information includes a determination execution number indicating the number of times determined by the execution determination unit, and a maximum determination execution number indicating the maximum number of determinations. Addition means for adding the number of determination executions included in the additional information read by the reading means when the determination by the execution determination means is performed, and the number of determination executions and the maximum determination included in the additional information read by the reading means An execution number comparison means for comparing the number of executions, wherein the execution determination means executes the SQL read by the reading means in the diagnosis target server based on the result of the execution number comparison means and the determination value It is determined whether or not to do.

  In the terminal device configured as described above, the additional information includes a determination execution number and a determination maximum execution number. The terminal device determines whether or not to execute SQL in consideration of a comparison result between the determination execution number and the maximum determination execution number included in the additional information. In this way, by using the maximum number of determination executions and considering the comparison result between the number of determination executions and the maximum number of determination executions, it is possible to avoid a permanent loop of diagnosis processing and forcibly terminate the diagnosis processing Become.

  In another aspect of the terminal device, the terminal device has an unexecuted SQL list that is an array composed of SQL that is not executed in the diagnosis target server and additional information set in the SQL, The execution determination unit determines whether or not to execute the SQL in the diagnosis target server only when the execution number comparison unit determines that the determination execution number is smaller than the maximum determination execution number as a comparison result. When the execution number comparison unit determines that the determination execution number is equal to the maximum determination execution number as a comparison result, an array composed of the SQL and additional information read by the reading unit, The system further comprises an unexecuted SQL list moving means for moving from the SQL list to the unexecuted SQL list. According to this, an array composed of SQL and additional information determined not to be executed does not exist in the SQL list. Therefore, it can be prevented that the SQL execution determination unit determines whether or not to execute the SQL that has already been determined not to be executed.

  In another aspect of the terminal device, a plurality of combinations of the determination functions are set as the additional information for one SQL. According to this, based on the results of a plurality of determination functions, that is, a plurality of determination values, it is possible to recognize the load status of the diagnosis target server from a plurality of angles.

  In another aspect of the terminal device, the threshold value is a predetermined CPU usage rate of the diagnostic target server, and the determination function obtains the CPU usage rate of the diagnostic target server as a result. The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is smaller than the threshold value as a result. According to this, the load status of the diagnosis target server can be recognized from the CPU usage rate. If the CPU usage rate is small, the load on the diagnosis target server is small, and if it is large, the load on the diagnosis target server is large. Therefore, if the CPU usage rate acquired as the determination value is smaller than the predetermined CPU usage rate defined in advance as a threshold value, the terminal device determines that the load on the diagnosis target server is small and executes SQL. On the other hand, if the CPU usage rate acquired as the determination value is larger than the fixed CPU usage rate defined as the threshold value, it is determined that SQL is not executed because the load on the diagnosis target server is large.

  In another aspect of the terminal device, the threshold value is a predetermined free memory capacity of the diagnosis target server, and the determination function is a function for acquiring the free memory capacity of the diagnosis target server. The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is larger than the threshold value as a result. According to this, the load status of the diagnosis target server can be recognized from the free memory capacity. If the free memory capacity is large, the load on the diagnosis target server is small, and if it is small, the load on the diagnosis target server is large. Therefore, if the free memory capacity acquired as the determination value is larger than the predetermined free memory capacity defined in advance as the threshold value, the terminal device determines that the load on the diagnosis target server is small and executes SQL. On the other hand, if the free memory capacity acquired as the determination value is smaller than the fixed free memory capacity defined as the threshold value, it is determined that SQL is not executed because the load on the diagnosis target server is large.

  In another aspect of the terminal device, the threshold value is a predetermined time period, the determination function is a function for acquiring a current time, and the execution determination unit includes When the determination value comparison means determines that the determination value is included in the threshold value as a result, it determines that the SQL is to be executed in the diagnosis target server. According to this, a time zone in which the load on the diagnosis target server is small is defined in advance as a threshold value. Therefore, the terminal device determines to execute SQL if the current time acquired as the determination value is included in a time zone in which the load previously defined as the threshold value is small. On the other hand, if the current time acquired as the determination value is not included in the time zone in which the load defined as the threshold value is small, it is determined that SQL is not executed. Note that a time period during which the load is large is defined as a threshold value in advance, and it may be determined that SQL is executed only when the determination value is not included in the threshold value.

  In still another aspect of the terminal device, the determination function is a function for obtaining a constant value, and the execution determination means is the result of the determination value comparison means regardless of the threshold value. When it is determined that the constant is acquired as a determination value, it is determined that the SQL is executed in the diagnosis target server. According to this, it is possible to determine that SQL is executed regardless of the threshold value. Therefore, such a determination function is particularly effective for SQL that must be executed regardless of the load status of the diagnostic processing server.

  In another aspect of the present invention, there is provided a diagnostic program that is executed by a computer that is communicably connected to a diagnosis target server having a database for diagnosis, and each of the plurality of SQLs and each SQL executed in the diagnosis target server. Based on a diagnostic script composed of the set additional information, an SQL list creating means for creating an SQL list that is an array composed of the SQL and the additional information, from the SQL list, from the SQL and the additional information Reading means for reading the configured array, determination value acquisition means for acquiring a determination value representing an operational load from the diagnosis target server based on the additional information read by the reading means, and the determination acquired by the determination value acquisition means Based on the value and additional information read by the reading means, the reading means reads An execution determination unit that determines whether or not to execute SQL in the diagnosis target server; an SQL transmission unit that transmits the SQL read by the reading unit to the diagnosis target server when the execution determination unit determines to execute; The computer is caused to function as an execution result receiving unit that acquires the execution result of the SQL transmitted by the SQL transmission unit from the diagnosis target server.

  By executing the above diagnostic program by a computer, the above-described terminal device can be realized. Moreover, each aspect of the above-described terminal device can be realized in the same manner.

  According to the present invention, it is possible to determine whether or not to execute a predetermined SQL based on the load status of the server having the database by weighting each SQL element of the script to be executed.

  Preferred embodiments of the present invention will be described below with reference to the drawings.

[Diagnostic system]
First, the diagnostic system will be described with reference to FIGS. FIG. 1 shows a schematic configuration of the diagnostic system 100. FIG. 2 is a diagram showing functions of the diagnostic program 11a in the conventional diagnostic system. FIG. 3 is a diagram showing changes in the CPU usage rate in each of the conventional diagnostic system and the diagnostic system of the present invention. FIG. 4 is a diagram showing functions of the diagnostic program 11 in the diagnostic system of the present invention.

  As shown in FIG. 1, in a diagnostic system, a client terminal 10 having a diagnostic script as an external file and a diagnostic target server 12 having a database to be diagnosed are connected via a network 2 so that they can communicate with each other. One preferred example of network 2 is the Internet. Here, the client terminal 10 is a personal computer, PDA (Personal Digital Assistants), or the like capable of transmitting / receiving data to / from the diagnosis target server 12 via the network 2, and has a diagnosis program 11 in advance. With this diagnostic program 11, the client terminal 10 holds a diagnostic script as an external file. Here, the diagnostic script is a collection of a plurality of SQLs (Structured Query Language) for diagnosing the database, and the diagnostic program 11 is a program for operating (handling) the diagnostic script. . Although details will be described later, the SQL described in the diagnostic script is executed in order from the top.

  When a problem such as the database not working properly occurs, it is necessary to diagnose the database. At this time, the client terminal 10 holds a diagnostic script by the diagnostic program 11 in advance. Then, the diagnostic program 11 of the client terminal 10 transmits the SQL described in the diagnostic script and the execution command of the SQL to the diagnostic target server 12. That is, the diagnosis program 11 instructs the diagnosis target server 12 to execute SQL in the diagnosis script. On the other hand, the diagnosis target server 12 executes the received SQL in accordance with the execution command received from the diagnosis program 11. Further, the diagnosis target server 12 transmits the execution result of the SQL to the client terminal 10. As described above, the diagnosis target server 12 executes the SQL described in the diagnosis script, and transmits the execution result to the client terminal 10 to diagnose the database.

  When SQL is executed on the diagnosis target server 12, system resources such as the CPU and memory of the diagnosis target server 12 are consumed.

  In the conventional diagnostic system, the diagnostic program 11a first reads one SQL from the diagnostic script as shown in FIG. The diagnostic program 11a operates in the client terminal 10 as in FIG. 1, but the illustration of the client terminal 10 is omitted in FIGS. 2 and 4 for convenience. Then, the diagnosis program 11a instructs the diagnosis target server 12 to execute the read SQL. The diagnosis target server 12 executes the SQL received as an instruction from the diagnosis program 11a. Further, the diagnosis target server 12 transmits the execution result of the SQL to the client terminal 10. When the client terminal 10 receives the diagnosis result, the diagnosis program 11a reads the next SQL from the diagnosis script and repeats the above-described processing. This diagnosis process is repeated until all SQLs described in the diagnosis script are completed.

  FIG. 3A is a diagram showing a change in the CPU usage rate in the conventional diagnostic system. Specifically, the vertical axis indicates “CPU usage rate of the diagnosis target server 12”, the horizontal axis indicates “time”, and the elapsed time when the diagnostic program 11a is executed, and the CPU usage rate of the diagnosis target server 12 It is a graph which shows the relationship. The solid line on the graph indicates the CPU usage rate by other programs excluding SQL execution, and the broken line indicates the CPU usage rate achieved by SQL execution.

  As described above, once the diagnosis program 11a in the conventional diagnosis system starts executing, the diagnosis processing does not end until execution of the last SQL described in the diagnosis script is completed. Therefore, as shown in FIG. 3 (a), even when the load on the diagnosis target server 12 is increased by executing another program on the diagnosis target server 12 while the diagnosis program 11a is being executed, Continue to execute diagnostic processing. For this reason, problems such as excess or interruption of the execution time of each program due to an extreme increase in the load on the diagnosis target server 12 and the freeze of the diagnosis target server 12 occur in the worst case.

  On the other hand, in the diagnostic system 100 of the present invention, as shown in FIG. 4, the diagnostic program 11 first acquires one SQL and additional information set in the SQL from the diagnostic script, that is, one set of SQL and additional information. Read. Then, the diagnostic program 11 considers the load status of the diagnosis target server 12 based on the read additional information, and determines whether or not to execute the read SQL. If it is determined that SQL is to be executed, the diagnostic program 11 instructs the diagnosis target server 12 to execute the read SQL. The diagnosis target server 12 executes the SQL received as an instruction from the diagnosis program 11. Further, the diagnosis target server 12 transmits the execution result of the SQL to the client terminal 10. When the client terminal 10 receives the diagnosis result, the diagnosis program 11 reads the next SQL from the diagnosis script and repeats the above-described processing. On the other hand, if it is determined that SQL is not to be executed, the diagnostic program 11 reads the next SQL from the diagnostic script without executing an execution command to the diagnosis target server 12, and repeats the above processing. This diagnosis process is repeated until a predetermined condition described later is completed.

  FIG. 3B is a diagram showing a change in the CPU usage rate in the diagnostic system 100 of the present invention. FIG. 4 is a graph showing the relationship between the passage of time when the diagnostic program 11 is executed and the CPU usage rate of the diagnosis target server 12 as in FIG.

  As described above, the diagnostic program 11 in the diagnostic system 100 of the present invention includes a phase for determining whether or not to execute each SQL. Specifically, although details will be described later, the diagnosis program 11 checks the load of the diagnosis target server 12 based on the additional information, and executes SQL only when the load is smaller than a predetermined threshold value. . Therefore, as illustrated in FIG. 3B, when the load on the diagnosis target server 12 is increased by executing another program on the diagnosis target server 12 while the diagnosis program 11 is being executed, a diagnosis process is performed. Interrupt. Therefore, the problem in the conventional diagnostic system can be solved.

  Note that the method (command) itself for checking the load of the diagnosis target server 12 hardly causes the load of the diagnosis target server 12. A threshold value for determining whether or not to execute SQL is set for each SQL and is included in the additional information.

[SQL]
Next, SQL will be described in detail with reference to FIG. FIG. 5 shows an example of SQL described in the diagnostic script.

  SQL is a query language for a database. By using SQL, most database operations such as table definitions, data operations, and relational operations can be described as machine-readable text. Therefore, the relation between the database itself and the database management system (hereinafter referred to as “DBMS”) can be abstracted by SQL.

  When SQL as shown in FIG. 5A is executed, a column or the like that is highly loaded for the diagnosis target server 12 can be extracted. Specifically, “SELECT” in FIG. 5 indicates that a column is specified and information that meets a specific condition is extracted. Further, “a”, “b”, and “c” in “SELECT a, b, c” in FIG. 5A represent arbitrary columns (issue time, person, SQL sentence, etc.), respectively. Also, “table A” of “FROM table A” represents the name of an arbitrary table from which information is extracted. Therefore, when the columns “a”, “b”, and “c” are high-load columns, the SQL shown in FIG. 5A extracts information on columns that are high-load from “table A”. Indicates operation.

  When SQL as shown in FIG. 5B is executed, the memory usage efficiency of the diagnosis target server 12 can be extracted. Specifically, “avg (a)” in FIG. 5B represents an average value of an arbitrary column. Therefore, when the column “a” is a column indicating the memory usage efficiency, for example, the SQL shown in FIG. 5B indicates an operation of extracting the average value of the memory usage efficiency from “table B”. Here, the memory usage efficiency is a ratio of returning information cached in the memory of the diagnosis target server 12 with respect to the entire SQL. In other words, it is a numerical value indicating how much (%) the information on the memory is returned to the request source.

  When the SQL as shown in FIG. 5C is executed, all the parameter names and setting values in the database can be extracted. Specifically, “name” in FIG. 5C represents a parameter name column, and “value” represents a set value column. Therefore, SQL shown in FIG. 5C indicates an operation of extracting all parameter names and setting values from “table C”.

  When SQL as shown in FIG. 5D is executed, it is possible to extract all table information included in the database. Specifically, “* (asterisk”) in FIG. 5D represents all columns. Therefore, SQL shown in FIG. 5D indicates an operation for extracting all information of “table D”.

  Although details will be described later, “table A” to “table D” are tables managed by the DBMS in the dictionary area. FIG. 5 illustrates the above four SQLs as an example, but the present invention is not limited to this, and any SQL can be described in a diagnostic script.

[Additional information]
Next, additional information set in each SQL will be described in detail with reference to FIGS. FIG. 6 is a diagram for explaining information included as additional information. FIG. 7 is a diagram illustrating an example of the determination function. FIG. 8 is a diagram illustrating an example of a conventional diagnosis script and an example of a diagnosis script of the present invention.

  As illustrated in FIG. 6, the additional information includes a determination function, a threshold value, a determination execution number, a maximum determination execution number, and an unexecuted movement function (hereinafter referred to as “movement function”).

  The determination function shown in FIG. 6 is a function for deriving a determination value for comparison with a threshold value. That is, the determination value is a result of the determination function acquired from the diagnosis target server, and is a value indicating the load on the diagnosis target server 12 when SQL is to be executed. Note that the determination function is arbitrarily set for each SQL, and is different for each SQL. A plurality of determination functions may be set in one SQL.

  Here, the determination function will be described in detail with reference to FIG. According to the determination function as shown in FIG. 7A, an OS command can be executed and the CPU usage rate of the diagnosis target server 12 can be acquired as a determination value. If the CPU usage rate is small, the load on the diagnosis target server 12 is also reduced. Conversely, if the CPU usage rate is high, the load on the diagnosis target server 12 is also increased. In this case, the threshold value described later is also the CPU usage rate, and SQL is executed only when the determination value is smaller than the threshold value.

  The variable notation indicating the determination function is “f”. Also, the variable “t” shown in FIG. 7 is time information at the time of performing SQL execution determination, and when the determination function “f (t)” is executed, the result of the determination function “f” at the time of SQL execution determination Can be obtained. FIG. 7 shows a command example of each determination function, but the present invention is not limited to this, and any command can be used according to the OS.

  According to the determination function as shown in FIG. 7B, the free memory capacity of the diagnosis target server 12 can be acquired as the determination value. If the free memory capacity is small, the load on the diagnosis target server increases. Conversely, if the free memory capacity is large, the load on the diagnosis target server decreases. In this case, a threshold value to be described later is also an empty memory capacity, and SQL is executed only when the determination value is larger than the threshold value.

  According to the determination function as shown in FIG. 7C, time information at the time of SQL execution determination can be acquired as a determination value. In this case, a threshold value to be described later is a time zone in which execution of SQL is permitted, and SQL is executed only when the determination value is included in the threshold value. Alternatively, a threshold value to be described later is a time zone in which execution of SQL is not permitted, and SQL is executed only when the determination value is not included in the threshold value. This determination function and threshold value are effective when the time zone during which the load on the diagnosis target server 12 increases or the time zone during which the load is reduced is clear.

  According to the determination function as shown in FIG. 7D, a constant can be obtained in any case. In this case, SQL is executed when the constant is acquired regardless of a threshold value described later. This determination function is particularly effective for SQL that must be executed regardless of the load status of the diagnostic processing server 12.

  Note that FIG. 7 illustrates the above four determination functions as an example, but the present invention is not limited to this, and an arbitrary determination function can be set for each SQL. In addition, setting one determination function for one SQL is not limited, and a combination of a plurality of determination functions may be set for one SQL.

  The threshold value shown in FIG. 6 is a constant value defined in advance in order to determine whether or not to execute SQL. Specifically, the threshold value and the determination value are compared, and it is determined whether or not SQL is to be executed based on the magnitude.

  The number of determination executions shown in FIG. 6 is the number of times it has been determined whether or not to execute SQL.

  The maximum number of determination executions shown in FIG. 6 is the maximum number of times for determining whether or not to execute SQL. When the number of determination executions reaches the maximum number of determination executions and SQL is not executed, the diagnosis program 11 ends the diagnosis process without executing the SQL. Thus, by using the maximum number of determination executions, it is possible to avoid a permanent loop of the diagnostic process and forcibly terminate the diagnostic process.

  In the movement function shown in FIG. 6, when it is determined that SQL is not executed by comparing a threshold value with a determination value, SQL and additional information set in the SQL move in an SQL list described later. This is a function indicating the position.

  Specifically, the conventional diagnostic script is composed of only a plurality of SQLs as shown in FIG. On the other hand, the diagnostic script of the present invention is composed of a plurality of sets of SQL and additional information as shown in FIG. At this time, as shown in the figure, the determination function and SQL are surrounded by delimiters ({}). The delimiter ({}) can be, for example, (“”) or ($$).

[SQL list]
Next, the SQL list held by the diagnostic program 11 will be described in detail with reference to FIGS. FIG. 9 is a diagram for explaining an SQL list, an executed SQL list, and an unexecuted SQL list held by the diagnostic program 11. FIG. 10 is a diagram schematically illustrating the data structure of the SQL list, the executed SQL list, and the unexecuted SQL list. As shown in FIG. 10, the variable notations of the determination function, the threshold value, the determination execution number, the maximum determination execution number, and the movement function are “f”, “b”, “e”, “c”, and “m”, respectively. " FIG. 11 is a diagram illustrating creation of an SQL list based on a diagnostic script. FIG. 12 is a diagram illustrating an example of a transfer function. FIG. 13 is a diagram schematically illustrating a configuration of a database held by the diagnosis target server 12.

  As shown in FIG. 9, the diagnostic program 11 has an SQL list, an executed SQL list, and an unexecuted SQL list.

  As shown in FIG. 10A, the SQL list is an array composed of SQL for determining whether or not to execute and additional information set in the SQL. All the SQL and additional information described in the diagnostic script that is an external file are stored in the SQL list held by the diagnostic program 11. Specifically, the diagnostic program 11 is composed of a plurality of sets of SQL and additional information as shown in FIG. 11B, for example, by reading a diagnostic script that is an external file as shown in FIG. An SQL list that is an array is created and held as an internal file. Therefore, at the initial stage, the SQL list is composed of one or more sets of SQL and additional information described in the diagnostic script. When the list is composed of a plurality of sets, the first set in the list is the target of SQL execution determination. It becomes.

  If it is determined that SQL is not to be executed by comparing the threshold value with the determination value, the SQL and the additional information set in the SQL move in the SQL list based on the transfer function. The movement in the SQL list based on this movement function will be described with reference to FIG.

  According to the transfer function “LAST” as shown in FIG. 12A, when the diagnostic program 11 determines not to execute the SQL, one of the SQL and the additional information located at the beginning of the SQL list is included. Move the array to the end of the SQL list as shown. A method using such a transfer function is called a cyclic method.

  According to the transfer function “FIRST” as shown in FIG. 12B, when the diagnostic program 11 determines not to execute the SQL, one of the SQL and the additional information that is located at the beginning of the SQL list is included. Move the array back to the beginning of the SQL list as shown. In other words, even if it is determined that SQL is not executed, one array composed of the SQL and additional information remains at the same position. Such a method using a transfer function is called a fixed method. According to this, even if the order of SQL is significant, it is possible to execute SQL in the order described in the diagnostic script in advance.

  In such a transfer function, it is conceivable that the diagnosis program 11 determines that the SQL is not continuously executed unless the load on the diagnosis target server 12 is high for a moment. As a method for avoiding such a continuous determination, a determination function may be set so that a determination value indicating the load of the diagnosis target server 12 is acquired after waiting for a certain time.

  According to the transfer function “n” as shown in FIG. 12C, when the diagnostic program 11 determines not to execute the SQL, one of the SQL and the additional information that is located at the beginning of the SQL list is included. Move the array to any order of position. Also, according to the transfer function “min (n, LAST)” as shown in FIG. 12C, when the diagnosis program 11 determines not to execute SQL, the SQL and the additional SQL positioned at the beginning of the SQL list One array composed of information is moved to the nth in the SQL list or to the end of the SQL list when the SQL list is shorter than n. Specifically, if the transfer function indicates moving the array to the second position, the array moves as shown. However, if the transfer function indicates that the array is moved to the fifth position, the fifth position does not exist, so the array moves to the end of the SQL list. According to this, even in the case of an SQL list in which the number of arrays consisting of SQL and additional information varies, it is possible to use a transfer function that easily moves to an arbitrary position.

  As shown in FIGS. 9 and 10B, the executed SQL list is an array composed of SQL executed by the diagnosis target server 12 and additional information set in the SQL. That is, the SQL and additional information executed by the diagnosis target server 12 are moved from the SQL list to the executed SQL list. Therefore, nothing is stored in the executed SQL list in the initial stage, but the SQL executed by the diagnosis target server 12 and additional information are stored as the diagnosis process proceeds.

  As shown in FIG. 9 and FIG. 10C, the unexecuted SQL list is set to the SQL that has been determined to end the diagnostic process without being executed because the determination execution number has reached the maximum determination execution number, and the SQL concerned. It is an array composed of additional information. That is, the SQL and additional information determined to end the diagnostic process without being executed by the diagnostic program 11 are moved from the SQL list to the non-executed SQL list. Therefore, if there is no SQL and additional information determined by the diagnostic program 11 to end diagnostic processing without being executed, nothing may be stored in the non-executed SQL list. In addition, since the SQL stored in the unexecuted SQL list is not executed by the diagnostic processing server 12, if the SQL and additional information are stored in the unexecuted SQL list, the diagnostic processing is completely completed. I can't say that. Therefore, in order to completely complete the diagnostic process, the diagnostic program then performs a complementary process such as re-executing the SQL described in the diagnostic script or executing only the SQL stored in the unexecuted SQL list. There is a need.

  Here, with reference to FIG. 13, the structure of the database which the diagnostic object server 12 holds is demonstrated. As shown in the figure, the database owned by the server to be diagnosed includes a user area in which the user himself writes an employee table, a sales table, and the like, and a dictionary (“dictionary”) in which the DBMS automatically writes statistical information to manage the database. Or a “catalog”). Thus, although the database is divided into the user area and the dictionary area, the load is applied to the same diagnosis target server 12 regardless of which area is used. Therefore, like the present invention, a diagnostic process for determining whether or not to execute SQL based on the load of the diagnosis target server 12 is useful. Note that the database area that SQL reads during execution in the diagnostic process is a dictionary area surrounded by a broken line.

[Client terminal]
Next, the client terminal 10 will be described in detail with reference to FIG. FIG. 14 is a diagram showing an internal configuration of the diagnosis system 100, particularly the client terminal 10. As shown in the figure, the client terminal 10 includes a diagnostic program 11, an SQL list creation function 101, a read function 102, an SQL execution determination function 103, an SQL transmission function 104, an executed SQL list movement function 105, and an execution result reception function 106. Has been. The SQL execution determination function 103 further includes an execution number comparison function 131, an unexecuted SQL list movement function 132, a determination function execution function 133, a determination value comparison function 134, a determination execution number addition function 135, and an SQL list movement function 136. Has been. Each of these functions is realized by the diagnostic program 11 being executed by the CPU in the client terminal 10 or the like.

  The diagnosis program 11 is a program that executes database diagnosis processing after determining whether or not to execute the SQL based on the additional information set in each SQL and the load status of the diagnosis target server 12.

  The SQL list creation function 101 is a function that creates a SQL list as shown in FIG. 11B as an internal file by reading a diagnostic script that is an external file as shown in FIG.

  The reading function 102 is a function that reads one array that is located at the beginning of the SQL list created by the SQL list creation function 101 and is composed of SQL and additional information.

  The SQL execution determination function 103 is a function for determining whether or not to execute the read SQL based on the additional information read by the read function 102 and the load status of the diagnosis target server 12.

  The execution number comparison function 131 is a function that compares the determination execution number included in the additional information read by the reading function 102 with the maximum determination execution number.

  The unexecuted SQL list moving function 132 is the SQL read by the read function 102 when the execution number comparison function 131 determines that the determination execution number is equal to the maximum determination execution number or the determination execution number is greater than the maximum determination execution number. It is a function that decides not to execute. Further, the unexecuted SQL list moving function 132 converts one array composed of the SQL decided not to be executed and the additional information set in the SQL from the SQL list as shown in FIG. This is a function for moving to an unexecuted SQL list as shown in FIG. Thus, by moving to the unexecuted SQL list, it is possible to prevent the SQL execution determination function 103 from determining again the SQL that has already been determined not to be executed.

  The determination function execution function 133 is a function for executing the determination function included in the additional information read by the read function 102 when the execution number comparison function 131 determines that the determination execution number is smaller than the maximum determination execution number. The determination function execution function 133 acquires a determination value indicating the load of the diagnosis target server 12 from the diagnosis target server 12 by executing the determination function.

  The determination value comparison function 134 is a function that compares the threshold value included in the additional information read by the reading function 102 with the determination value acquired by the determination function execution function 133. The SQL execution determination function 103 determines whether or not to execute the SQL read by the reading function 102 based on the comparison result by the determination value comparison function 134.

  The determination execution number addition function 135 is a function for adding “1” to the determination execution number included in the additional information corresponding to the threshold value and the determination value compared by the determination value comparison function 134.

  When the SQL execution determination function 103 determines that the SQL read by the reading function 102 is not to be executed, the SQL list moving function 136 determines that the SQL and additional SQL are added based on the transfer function included in the additional information read by the reading function 102. This is a function for moving one array composed of information within the SQL list as shown in FIG.

  The SQL transmission function 104 is a function of transmitting the SQL and the execution instruction of the SQL to the diagnosis target server 12 when the SQL execution determination function 103 determines to execute the SQL read by the reading function 102.

  The executed SQL list moving function 105 converts one array composed of the SQL transmitted by the SQL transmission function 104 and the additional information set in the SQL from the SQL list as shown in FIG. This is a function for moving to the executed SQL list as shown in (b). In this way, by moving to the executed SQL list, it is possible to prevent the SQL execution determination function 103 from determining again the already executed SQL.

  The execution result receiving function 106 is a function for receiving the SQL execution result transmitted by the SQL transmission function 104 from the diagnosis target server 12. Based on the SQL execution result received in this way, the diagnosis program 11 can diagnose the database of the diagnosis target server 12.

[Diagnostic processing]
Next, with reference to FIG. 15, a diagnosis process executed by the client terminal 10 constituting the diagnosis system 100 will be described. FIG. 15 is a flowchart of the diagnostic process.

  As illustrated, in the diagnostic process, the diagnostic program 11 of the client terminal 10 first creates an SQL list that is an internal file based on a diagnostic script that is an external file. Further, the diagnostic program 11 reads a set of SQL and additional information from the SQL list (step S1). Then, the diagnosis program 11 compares the determination execution number included in the read additional information with the maximum determination execution number (step S2). If it is determined that the determination execution number is equal to the maximum determination execution number, the diagnostic program 11 moves one array composed of the read SQL and additional information from the SQL list to the unexecuted SQL list (step S11).

  On the other hand, when it is determined that the determination execution number is smaller than the maximum determination execution number, the diagnostic program 11 executes the determination function included in the read additional information (step S3). Thereby, the diagnostic program 11 can acquire the determination value indicating the load status from the diagnosis target server 12. When the determination value is acquired, the diagnostic program 11 compares the threshold value included in the read additional information with the acquired determination value (step S4). Specifically, when the determination value and the threshold value are the CPU usage rate, if the diagnosis program 11 determines that the determination value is larger than the threshold value, the load on the diagnosis target server 12 is large, so the read SQL is It is determined not to execute. Accordingly, the diagnostic program 11 adds “1” to the number of determination executions included in the read additional information (step S5), and one array composed of the read SQL and additional information is included in the additional information. Based on the movement function, the user moves within the SQL list (step S6).

  On the other hand, if it is determined that the determination value is equal to the threshold value or the determination value is smaller than the threshold value, the diagnosis program 11 determines that the read SQL is to be executed because the load on the diagnosis target server 12 is small. Therefore, the diagnostic program 11 adds “1” to the determination execution number included in the read additional information (step S7), and transmits the read SQL and the execution instruction of the SQL to the diagnosis target server 12 (step S8). . Further, the diagnostic program moves one array composed of the read SQL and additional information from the SQL list to the executed SQL list (step S9). Further, the diagnostic program 11 receives the SQL execution result transmitted in step S8 from the diagnosis target server 12 (step S10).

  Then, the diagnostic program 11 determines whether or not an array composed of the next SQL and additional information exists in the SQL list (step S12). If there is an array composed of the next SQL and additional information (step S12; Yes), the diagnostic program 11 repeats the processes of steps S1 to S10. On the other hand, when there is no array composed of the next SQL and additional information, that is, when the SQL list is empty (step S12; No), the diagnostic program 11 ends the diagnostic process.

  Next, diagnostic processing executed by the client terminal 10 will be described in detail with reference to FIGS.

  FIG. 16 to FIG. 20 are diagrams for explaining a change in arrangement in the diagnostic processing. FIG. 16A to FIG. 20A are diagrams particularly illustrating the movement of the array among the SQL list, the executed SQL list, and the non-executed SQL list in the diagnosis process. FIG. 16B to FIG. 20B are flowcharts specifically explaining the flow of diagnostic processing. FIGS. 16C to 20C are diagrams for specifically explaining the movement in the array in the diagnostic processing. FIG. 21 is a graph for explaining the relationship between threshold values and determination values in diagnosis processing and time, with “value” on the vertical axis and “time” on the horizontal axis.

  Note that, in the diagnostic process described later, the threshold value and the determination value are assumed to be the CPU usage rate as in the diagnostic process shown in FIG.

  The diagnosis program 11 first creates an SQL list as shown in the upper part of FIG. 16A based on the diagnosis script. Further, as shown in the flowchart of FIG. 16B, the diagnostic program 11 reads one array composed of the SQL and the additional information located at the beginning of the created SQL list (step S21). The read array is the array shown in FIG. Then, the diagnosis program 11 compares the determination execution number (e1) “0” included in the additional information of the read array with the maximum determination execution number (c1) “1” (step S22). In this case, since the determination execution number is smaller than the determination maximum execution number, the diagnostic program 11 executes the determination function (f1) (step S23). As a result of executing the determination function (f1), the diagnostic program 11 is assumed to acquire the determination value (r1) “30” as shown in FIG. On the other hand, when the determination execution number is equal to the determination maximum execution number or the determination execution number is larger than the determination maximum execution number, the diagnosis program 11 performs the process of step S11 shown in FIG.

  The diagnostic program 11 that has acquired the determination value (r1) compares the determination value (r1) “30” with the threshold value (b1) “80” included in the additional information of the read sequence (step S24). . In this case, since the determination value is smaller than the threshold value, the diagnosis program 11 determines to execute the read SQL1. On the other hand, when the determination value is larger than the threshold value, the diagnosis program 11 performs the processes of steps S5 and S6 shown in FIG.

  The diagnosis program 11 determined to execute SQL1 adds the determination execution number (e1) “0” included in the additional information of the read array to “1” (step S25). Then, the diagnosis program 11 transmits SQL1 and an execution command for the SQL1 to the diagnosis target server 12 (step S26). The diagnosis target server 12 executes the received SQL. On the other hand, the diagnostic program 11 moves one array composed of SQL1 and additional information from the SQL list to the executed SQL list as shown in the lower part of FIG. 16A (step S27). Further, the diagnostic program 11 receives the execution result of SQL1 from the diagnosis target server 12 (step S28), and determines whether or not an array including the next SQL and additional information exists in the SQL list (step S29). ). Since the following sequence exists in the SQL list shown at the bottom of FIG. 16A, the diagnostic program 11 proceeds to step S31 shown in the flowchart of FIG. On the other hand, when the next sequence does not exist, the diagnostic program 11 ends the diagnostic process.

  In step S31 shown in FIG. 17B, the diagnostic program 11 reads one array composed of the SQL and the additional information located at the beginning of the SQL list shown in the upper part of FIG. 17A (step S31). The read array is the array shown in FIG. Then, the diagnosis program 11 compares the determination execution number (e2) “0” included in the read additional information of the array with the maximum determination execution number (c2) “1” (step S32). In this case, since the determination execution number is smaller than the determination maximum execution number, the diagnostic program 11 executes the determination function (f2) (step S33). As a result of executing the determination function (f2), the diagnostic program 11 is assumed to acquire the determination value (r2) “50” as shown in FIG. On the other hand, when the determination execution number is equal to the determination maximum execution number or the determination execution number is larger than the determination maximum execution number, the diagnosis program 11 performs the process of step S11 shown in FIG.

  The diagnostic program 11 that has acquired the determination value (r2) compares the determination value (r1) “50” with the threshold value (b2) “20” included in the additional information of the read sequence (step S34). . In this case, since the determination value is larger than the threshold value, the diagnostic program 11 adds the determination execution number (e2) “0” included in the read additional information of the array to “1” (step S35). Further, the diagnostic program 11 converts one sequence composed of the read SQL2 and additional information into the last position in the SQL list based on the transfer function (LAST) as shown in the lower part of FIG. (Step S36). Then, the diagnostic program 11 proceeds to step S41 shown in the flowchart of FIG.

  In step S41 shown in FIG. 18B, the diagnostic program 11 reads one array composed of the SQL and the additional information located at the beginning of the SQL list as shown in the upper part of FIG. 18A (step S41). . The read array is the array shown in FIG. Then, the diagnosis program 11 compares the determination execution number (e3) “0” included in the additional information of the read array with the maximum determination execution number (c3) “2” (step S42). In this case, since the determination execution number is smaller than the determination maximum execution number, the diagnostic program 11 executes the determination function (f3) (step S43). As a result of executing the determination function (f3), the diagnosis program 11 is assumed to acquire the determination value (r3) “80” as shown in FIG. When the determination execution number is equal to the determination maximum execution number or the determination execution number is larger than the maximum determination execution number, the diagnosis program 11 performs the process of step S11 shown in FIG.

  The diagnostic program 11 that has acquired the determination value (r3) compares the determination value (r3) “80” with the threshold value (b3) “60” included in the additional information of the read sequence (step S44). . In this case, since the determination value is larger than the threshold value, the diagnosis program 11 adds the determination execution number (e3) “0” included in the additional information of the read array to “1” (step S45). Further, the diagnostic program 11 places one sequence composed of the read SQL3 and additional information at the last position in the SQL list based on the transfer function (LAST) as shown in the lower part of FIG. Move (step S46). Then, the diagnosis program 11 proceeds to step S51 shown in the flowchart of FIG. If the determination value is equal to the threshold value or the determination value is smaller than the threshold value in step S44, the diagnostic program 11 performs the processing from S7 to S10 shown in FIG.

  In step S51 shown in FIG. 19B, the diagnosis program 11 reads one array composed of the SQL and the additional information located at the beginning of the SQL list as shown in the upper part of FIG. 19A (step S51). . The read array is the array shown in FIG. Then, the diagnosis program 11 compares the determination execution number (e2) “1” included in the read additional information of the array with the maximum determination execution number (c2) “1” (step S52). In this case, since the number of executions for determination is equal to the maximum number of executions for determination, the diagnostic program 11 stores one array composed of the read SQL2 and additional information from the SQL list as shown in the lower part of FIG. Move to the execution SQL list (step S53). When it is determined that the determination execution number is smaller than the maximum determination execution number, the diagnosis program 11 performs the processing of steps S3 to S10 illustrated in FIG.

  Then, the diagnosis program 11 determines whether or not an array composed of the next SQL and additional information exists in the SQL list (step S54). Since the following sequence exists in the SQL list shown at the bottom of FIG. 19A, the diagnosis program 11 proceeds to step S61 shown in the flowchart of FIG. If the next sequence does not exist, the diagnostic program 11 ends the diagnostic process.

  In step S61 shown in FIG. 20B, the diagnostic program 11 reads one array composed of the SQL and the additional information located at the beginning of the SQL list as shown in the upper part of FIG. 20A (step S61). . The read array is the array shown in FIG. Then, the diagnosis program 11 compares the determination execution number (e3) “1” included in the read additional information of the array with the maximum determination execution number (c3) “2” (step S62). In this case, since the determination execution number is smaller than the determination maximum execution number, the diagnostic program 11 executes the determination function (f3) (step S63). As a result of executing the determination function (f3), the diagnosis program 11 acquires the determination value (r3) “30” as shown in FIG. When the determination execution number is equal to the determination maximum execution number or the determination execution number is larger than the maximum determination execution number, the diagnosis program 11 performs the process of step S11 shown in FIG.

  The diagnostic program 11 that has acquired the determination value (r3) compares the determination value (r3) “30” with the threshold value (b3) “60” included in the additional information of the read sequence (step S64). . In this case, since the determination value is smaller than the threshold value, the diagnosis program 11 determines to execute the read SQL3. If the determination value is larger than the threshold value, the diagnostic program 11 performs steps S5 and S6 shown in FIG.

  The diagnostic program 11 determined to execute SQL1 adds the determination execution number (e3) “1” included in the additional information of the read array to “2” (step S65). Then, the diagnostic program 11 transmits SQL3 and an execution command for the SQL3 to the diagnosis target server 12 (step S66). The diagnosis target server 12 executes the received SQL. On the other hand, the diagnostic program 11 moves one array composed of SQL3 and additional information from the SQL list to the executed SQL list as shown in the lower part of FIG. 20A (step S67). Furthermore, the diagnostic program 11 receives the execution result of SQL3 from the diagnosis target server 12 (step S68), and determines whether or not an array including the next SQL and additional information exists in the SQL list (step S69). ). Since the next array does not exist in the SQL list shown in the lower part of FIG. 20A, the diagnostic program 11 ends the diagnostic process. When the next array exists in the SQL list, the diagnosis program 11 performs the processes of steps S1 to S11 shown in FIG.

  When the diagnosis process is executed as described with reference to FIGS. 16 to 20, the relationship between the determination value, the threshold value, and the time in the diagnosis process is as shown in FIG.

  According to the present invention, in the diagnostic process, it is possible to determine whether or not to execute the SQL based on the additional information set for each SQL to be executed and the load status of the diagnostic processing server 12. That is, it is possible to execute the SQL that can be issued at that time while checking the load status of the diagnosis target server 12 and to keep the server load during the execution period of the diagnosis script always low. Therefore, in the present invention, it is possible to solve the problem such as the freeze of the diagnostic processing server that has occurred conventionally.

  The present invention can be used as a diagnostic program that can always maintain a low load on a server having a database when diagnosing the database.

It is a figure which shows schematic structure of the diagnostic system in this invention. It is a figure which shows the function of the diagnostic program in the conventional diagnostic system. It is a graph which shows the change of CPU usage rate in each of the conventional diagnostic system and the diagnostic system of the present invention. It is a figure which shows the function of the diagnostic program in the diagnostic system of this invention. The example of SQL described in the diagnostic script is shown. It is a figure explaining the information contained as additional information. It is a figure which shows the example of a determination function. It is a figure which shows the example of the conventional diagnostic script, and the example of the diagnostic script of this invention. It is a figure explaining an SQL list, an executed SQL list, and an unexecuted SQL list. It is a figure which shows typically the data structure of a SQL list, an executed SQL list, and an unexecuted SQL list. It is a figure explaining preparation of a SQL list based on a diagnostic script. It is a figure which shows the example of a transfer function. It is a figure which shows typically the structure of the database which a diagnostic target server holds. It is a functional block diagram of a client terminal. It is a flowchart of the diagnostic process in this invention. It is a figure explaining the change of the arrangement | sequence in a diagnostic process. It is a figure explaining the change of the arrangement | sequence in a diagnostic process. It is a figure explaining the change of the arrangement | sequence in a diagnostic process. It is a figure explaining the change of the arrangement | sequence in a diagnostic process. It is a figure explaining the change of the arrangement | sequence in a diagnostic process. It is a graph explaining the relationship between the threshold value and determination value in diagnosis processing, and time.

Explanation of symbols

DESCRIPTION OF SYMBOLS 2 ... Network 10 ... Client terminal 11 ... Diagnosis program 12 ... Diagnosis target server 100 ... Diagnosis system 101 ... SQL list creation function 102 ... Read function 103 ... SQL execution determination function 104 ... SQL transmission function 105 ... Executed SQL list movement function 106 ... execution result reception function

Claims (28)

A terminal device communicably connected to a diagnosis target server having a database for performing diagnosis,
An SQL list that creates an SQL list that is an array composed of the SQL and the additional information, based on a plurality of SQL executed in the diagnosis target server and a diagnostic script composed of the additional information set for each SQL. Creating means;
Reading means for reading an array composed of the SQL and the additional information from the SQL list;
Based on the additional information read by the reading means, a determination value acquisition means for acquiring a determination value representing an operational load from the diagnosis target server;
Execution determination means for determining whether or not to execute the SQL read by the reading means in the diagnosis target server based on the determination value acquired by the determination value acquisition means and the additional information read by the reading means;
SQL transmission means for transmitting the SQL read by the reading means to the diagnosis target server when the execution determining means determines to execute;
An execution result receiving unit that acquires an execution result of the SQL transmitted by the SQL transmission unit from the diagnosis target server. The additional information includes a determination function and a threshold value for calculating the determination value,
The determination value acquisition unit acquires a determination function result included in the additional information read by the reading unit as the determination value,
The terminal device
A determination value comparison unit that compares the determination value acquired by the determination value acquisition unit with a threshold value included in the additional information read by the reading unit;
The terminal according to claim 1, wherein the execution determination unit determines whether or not to execute the SQL read by the reading unit in the diagnosis target server based on a result of the determination value comparison unit. apparatus. The terminal device has an executed SQL list that is an array composed of SQL executed in the diagnosis target server and additional information set in the SQL,
The system further comprises an executed SQL list moving means for moving an array composed of the SQL transmitted by the SQL transmitting means and the additional information set in the SQL from the SQL list to the executed SQL list. The terminal device according to claim 1 or 2. The additional information includes a movement function indicating a position to move in the SQL list,
When the execution determining means determines not to execute, an array composed of the SQL read by the reading means and the additional information set in the SQL is converted into the SQL based on the transfer function included in the additional information. The terminal device according to claim 1, further comprising an SQL list moving unit that moves in the list.   The terminal apparatus according to claim 4, wherein the SQL list moving unit moves the array to the end of the SQL list based on the transfer function.   The terminal apparatus according to claim 4, wherein the SQL list moving unit moves the array to the beginning of the SQL list based on the transfer function.   The SQL list moving means moves the array to an arbitrary position set in advance in the SQL list based on the movement function. Terminal device. The additional information includes a determination execution number indicating the number of times determined by the execution determination unit, and a maximum determination execution number indicating the maximum number of determinations.
The terminal device
An addition unit for adding the number of determination executions included in the additional information read by the reading unit when the determination by the execution determination unit is performed;
An execution number comparison unit that compares the determination execution number and the maximum determination execution number included in the additional information read by the reading unit;
2. The execution determining unit determines whether or not to execute the SQL read by the reading unit in the diagnosis target server based on a result of the execution number comparing unit and the determination value. The terminal device as described in any one of thru | or 7. The terminal device has an unexecuted SQL list that is an array composed of SQL not executed in the diagnosis target server and additional information set in the SQL,
The execution determination unit determines whether or not to execute the SQL in the diagnosis target server only when the execution number comparison unit determines that the determination execution number is smaller than the maximum determination execution number as a comparison result. To do,
When the execution number comparison unit determines that the determination execution number is equal to the maximum determination execution number as a comparison result, an array composed of the SQL read by the reading unit and additional information is extracted from the SQL list. 9. The terminal device according to claim 8, further comprising an unexecuted SQL list moving means for moving to an unexecuted SQL list.   The terminal device according to claim 2, wherein a combination of a plurality of the determination functions is set as the additional information for one SQL. The threshold value is a predetermined CPU usage rate of the diagnosis target server,
The determination function is a function for obtaining the CPU usage rate of the diagnosis target server as a result,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is smaller than the threshold value as a result. The terminal device according to any one of 2 to 10. The threshold value is a predetermined free memory capacity of the diagnosis target server,
The determination function is a function for obtaining a free memory capacity of the diagnosis target server,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is larger than the threshold value as a result. The terminal device according to any one of 2 to 11. The threshold value is a predetermined time period defined in advance,
The determination function is a function for obtaining a current time,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is included in the threshold value as a result. Item 13. The terminal device according to any one of Items 2 to 12. The determination function is a function for obtaining a constant,
The execution determination unit determines to execute the SQL in the diagnosis target server when the determination value comparison unit determines that the constant is acquired as the determination value regardless of the threshold value. The terminal device according to claim 2, wherein: A diagnostic program executed by a computer communicably connected to a diagnosis target server having a database for performing diagnosis,
An SQL list that creates an SQL list that is an array composed of the SQL and the additional information, based on a plurality of SQL executed in the diagnosis target server and a diagnostic script composed of the additional information set for each SQL. Creation means,
Reading means for reading an array composed of the SQL and the additional information from the SQL list,
Determination value acquisition means for acquiring a determination value representing an operational load from the diagnosis target server based on the additional information read by the reading means;
An execution determination unit for determining whether or not to execute the SQL read by the reading unit in the diagnosis target server based on the determination value acquired by the determination value acquiring unit and the additional information read by the reading unit;
SQL transmission means for transmitting the SQL read by the reading means to the diagnosis target server when the execution determining means determines to execute,
A diagnostic program for causing the computer to function as an execution result receiving unit that acquires the execution result of the SQL transmitted by the SQL transmission unit from the diagnosis target server. The additional information includes a determination function and a threshold value for calculating the determination value,
The determination value acquisition unit acquires a determination function result included in the additional information read by the reading unit as the determination value,
The program is
Causing the computer to further function as a determination value comparison unit that compares the determination value acquired by the determination value acquisition unit with a threshold value included in the additional information read by the reading unit;
The diagnosis according to claim 15, wherein the execution determination unit determines whether or not the SQL read by the reading unit is to be executed in the diagnosis target server based on a result of the determination value comparison unit. program. The computer has an executed SQL list that is an array composed of SQL executed in the diagnosis target server and additional information set in the SQL,
Further causing the computer to function as an executed SQL list moving means for moving an array composed of the SQL transmitted by the SQL transmitting means and additional information set in the SQL from the SQL list to the executed SQL list. The diagnostic program according to claim 15 or 16, wherein: The additional information includes a movement function indicating a position to move in the SQL list,
When the execution determining means determines not to execute, an array composed of the SQL read by the reading means and the additional information set in the SQL is converted into the SQL based on the transfer function included in the additional information. The diagnostic program according to claim 15, further causing the computer to function as an SQL list moving unit that moves in a list.   The diagnostic program according to claim 18, wherein the SQL list moving means moves the array to the end of the SQL list based on the transfer function.   The diagnostic program according to claim 18, wherein the SQL list moving means moves the array to the beginning of the SQL list based on the transfer function.   21. The SQL list moving means moves the array to an arbitrary preset position in the SQL list based on the movement function. Diagnostic program. The additional information includes a determination execution number indicating the number of times determined by the execution determination unit, and a maximum determination execution number indicating the maximum number of determinations.
The program is
An adding means for adding the number of determination executions included in the additional information read by the reading means when a determination is made by the execution determining means;
The computer is further caused to function as an execution number comparison unit that compares the determination execution number and the maximum determination execution number included in the additional information read by the reading unit,
16. The execution determination unit determines whether or not to execute the SQL read by the reading unit in the diagnosis target server based on a result of the execution number comparison unit and the determination value. The diagnostic program as described in any one of thru | or 21. The computer has an unexecuted SQL list that is an array composed of SQL that is not executed in the server to be diagnosed and additional information set in the SQL,
The execution determination unit determines whether or not to execute the SQL in the diagnosis target server only when the execution number comparison unit determines that the determination execution number is smaller than the maximum determination execution number as a comparison result. To do,
When the execution number comparison means determines that the determination execution number is equal to the maximum determination execution number as a comparison result, an array composed of the SQL read by the reading means and additional information is extracted from the SQL list. 23. The diagnostic program according to claim 22, further causing the computer to function as an unexecuted SQL list moving means for moving to an unexecuted SQL list.   The diagnostic program according to any one of claims 16 to 23, wherein a combination of a plurality of the determination functions is set as the additional information for one SQL. The threshold value is a predetermined CPU usage rate of the diagnosis target server,
The determination function is a function for obtaining the CPU usage rate of the diagnosis target server as a result,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is smaller than the threshold value as a result. The diagnostic program according to any one of 16 to 24. The threshold value is a predetermined free memory capacity of the diagnosis target server,
The determination function is a function for obtaining a free memory capacity of the diagnosis target server,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is larger than the threshold value as a result. The diagnostic program according to any one of 16 to 25. The threshold value is a predetermined time period defined in advance,
The determination function is a function for obtaining a current time,
The execution determination unit determines that the SQL is to be executed in the diagnosis target server when the determination value comparison unit determines that the determination value is included in the threshold value as a result. Item 27. The diagnostic program according to any one of Items 16 to 26. The determination function is a function for obtaining a constant,
The execution determination unit determines to execute the SQL in the diagnosis target server when the determination value comparison unit determines that the constant is acquired as the determination value regardless of the threshold value. The diagnostic program according to any one of claims 16 to 27, wherein:

Images