Patent ID: 7610293
Filing Date: 2009-10-27
Classification: G06F,Y10S

Abstract:
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.