Correlation of resource usage in a database tier to software instructions executing in other tiers of a multi tier application
First Claim
1. A method of correlating usage of a plurality of resources in a database tier to specific blocks of instructions executed in a multi tier application causing usage of said plurality of resources, wherein said database tier is contained in a plurality of tiers of said multi tier application and said database tier being implemented using a database server, said method comprising:
- receiving a request requiring a database operation to be performed in said database tier;
executing a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks contained in said specific blocks of instructions;
forming a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks,wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list;
executing said database operation on said database server in said database tier;
measuring resources used within said database server for said executing; and
storing said tag list associated with said measured resources to thereby correlate the usage of resources within said database server to specific ones of said sequence of blocks.
1 Assignment
0 Petitions
Accused Products
Abstract
Correlating resource usage in a database tier to software instructions executing in other tiers of a multi tier application. In an embodiment, each block of instructions of interest (executing in different tiers) is designed to add a corresponding tag associated with a request (requiring a database operation to be performed). The resources required for performance of the database operation may be measured and the tags may be stored along with the measured resources, thereby facilitating correlation of desired software instruction blocks with the usage of resources in database tier.
23 Citations
18 Claims
-
1. A method of correlating usage of a plurality of resources in a database tier to specific blocks of instructions executed in a multi tier application causing usage of said plurality of resources, wherein said database tier is contained in a plurality of tiers of said multi tier application and said database tier being implemented using a database server, said method comprising:
-
receiving a request requiring a database operation to be performed in said database tier; executing a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks contained in said specific blocks of instructions; forming a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks, wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list; executing said database operation on said database server in said database tier; measuring resources used within said database server for said executing; and storing said tag list associated with said measured resources to thereby correlate the usage of resources within said database server to specific ones of said sequence of blocks. - View Dependent Claims (2, 3, 4)
-
-
5. A computer readable storage medium carrying one or more sequences of instructions for causing correlation of usage of a plurality of resources in a database tier to specific blocks of instructions executed in a multi tier application causing usage of said plurality of resources, wherein said database tier is contained in a plurality of tiers of said multi tier application and said database tier being implemented using a database server, wherein execution of said one or more sequences of instructions by one or more processors causes said one or more processors to perform the actions of:
-
receiving a request requiring a database operation to be performed in said database tier; executing a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks contained in said specific blocks of instructions; forming a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks, wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list; executing said database operation on said database server in said database tier; measuring resources used within said database server for said executing; and storing said tag list associated with said measured resources to thereby correlate the usage of resources within said database server to specific ones of said sequence of blocks. - View Dependent Claims (6, 7, 8)
-
-
9. An apparatus correlating usage of a plurality of resources in a database tier to specific blocks of instructions executed in a multi tier application causing usage of said plurality of resources, wherein said database tier is contained in a plurality of tiers of said multi tier application and said database tier being implemented using a database server, said apparatus comprising:
-
means for receiving a request requiring a database operation to be performed in said database tier; means for executing a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks contained in said specific blocks of instructions; means for forming a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks, wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list; means for executing said database operation on said database server in said database tier; means for measuring resources used within said database server for said executing; and means for storing said tag list associated with said measured resources to thereby correlate the usage of resources within said database server to specific ones of said sequence of blocks. - View Dependent Claims (10, 11)
-
-
12. A computing system comprising:
-
an application server to execute a multi tier application comprising a plurality of tiers including a database tier, said multi tier application being configured to; receive a request requiring a database operation to be performed in said database tier; execute a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks of interest; form a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks, wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list; and send said database operation to said database tier for execution, wherein said tag list is also sent with said database operation; a database server to implement said database tier and to store data in the form of tables, said database server being configured to; receive said database operation and said tag list; execute said database operation on said tables, wherein execution of said database operation causes a plurality of resources to be used within said database server; measure each of said plurality of resources used within said database server for executing said database operation; and store said measured resources associated with said tag list, whereby a user is enabled to correlate said measured resources used within said database server to specific ones of said sequence of blocks of interest executed in said multi tier application. - View Dependent Claims (13, 14, 15, 16, 17)
-
-
18. A method of correlating usage of a plurality of resources to specific blocks of instructions executed in a multi tier application causing usage of said plurality of resources, said method comprising:
-
receiving a request requiring processing in a plurality of tiers of said multi tier application; executing a plurality of blocks of instructions in said plurality of tiers to process said request, said plurality of blocks including a sequence of blocks contained in said specific blocks of instructions; forming a tag list containing a sequence of tags, wherein each of said sequence of blocks receives a partial tag list from a previous block in said sequence of blocks, adds a corresponding tag to the partial tag list to generate a modified tag list and provides the modified tag list as the partial tag list for the next block in said sequence of blocks, whereby said tag list is generated by the last one of said sequence of blocks, wherein each tag in said tag list identifies the corresponding block which has added the tag to said tag list; measuring resources for processing said request in said plurality of tiers; and storing said tag list associated with said measured resources to thereby correlate the usage of resources to specific ones of said sequence of blocks.
-
Specification