Profiler tool for database servers
AssigneeMicrosoft Corporation
InventorsKarim Fanous, Gabriel Ghizila
Life of this patent
Estimating the term…
Abstract
A system and method for profiling a database server comprising a parser for parsing stored procedure events data and a call stack tree for receiving stored procedure events data. The profiling of the stored procedure events data enables a user to determine a relationship between stored procedures within a stack of stored procedures, and to build views of the events data to quickly determine causes of latency within a database server.
Claims16
A system for profiling a database server, comprising:
- a parser for parsing stored procedure events data;
- and
- a call stack tree for receiving stored procedure events data, wherein the stored procedure events data comprises:
- an identity of a first stored procedure,
- an identity of a second stored procedure executed at the instigation of the first stored procedure, and
- data showing that the first stored procedure instigated the execution of the second stored procedure.
A method for profiling a database server, comprising:
- registering stored procedure events data;
- parsing the stored procedure events data;
- and
- merging the stored procedure events data, wherein the stored procedure events data comprises data showing relationships between a plurality of stored procedures within a stack of stored procedures.
A computer-readable medium having computer-executable instructions for performing steps, comprising:
- parsing stored procedure events data;
- and
- merging the stored procedure events data, wherein the stored procedure events data comprises data showing a relationship between a plurality of stored procedures within a stack of stored procedures.
A computer-readable medium having stored thereon a data structure, comprising:
- a first data field comprising data representing an identification of a first stored procedure;
- a second data field comprising data representing an identification of a second stored procedure;
- and
- a third data field comprising data representing that the first stored procedure instigated the execution of the second stored procedure.
Dependencies are inferred from the claim text.