NETWORK DEVICE AND METHOD FOR MONITORING OF BACKEND TRANSACTIONS IN DATA CENTERS
A network device and method for learning and monitoring transactions executed by back-end systems in data servers. Specifically, it allows learning and monitoring at least standard query language (SQL) transactions sent from an application server hosting a web application to a database server and executed thereon. Monitoring of SQL transactions allows measuring performance parameters with regards to databases, databases' tables, operations and queries that are part of the transactions. Furthermore, the measurement of performance parameters with respect to HTTP requests of the respective SQL transactions is provided.
1 . A method for monitoring of back-end transactions in data centers, comprising:
identifying a backend query in a request sent to a backend system of a data center;
parsing the backend query to generate a backend skeleton;
classifying the backend skeleton to a known backend transaction; and
measuring performance parameters for a classified backend skeleton.
2 . The method of claim 1 , wherein the request is generated by at least one of: an application server and a web server.
3 . The method of claim 2 , wherein the backend transaction is at least a standard query language (SQL), and wherein the backend query is at least a SQL query.
4 . The method of claim 3 , wherein the back-end system is at least a database server, and wherein the database server is at least one of: an Oracle Database Server, a Microsoft SQL server, a DB2, and a Sybase.
5 . The method of claim 1 , wherein the backend skeleton is a logical division of the backend query and is utilized for clustering purposes.
6 . The method of claim 5 , wherein the backend skeleton is predefined.
7 . The method of claim 3 , wherein the performance parameters include at least one of: throughput, response time, hits per second, latency and number of returned errors.
8 . The method of claim 7 , wherein measures of the performance parameters are compared to predefined thresholds to determine if the backend transaction meets a service level according to a service level agreement (SLA).
9 . The method of claim 1 , further comprising:
processing unclassified SQL skeletons together with their respective requests and queries to discover transactions related data.
10 . The method of claim 9 , wherein the transactions related data comprises at least databases, tables, operations and queries that are part of transactions executed over the backend system.
11 . A computer-readable medium having stored thereon computer executable code when executed by a computer for monitoring of backend transactions in data centers, the computer executable code comprising:
identifying a backend query in a request sent to a back-end system of a data center;
parsing the backend query to generate a backend skeleton;
classifying the backend skeleton to a known backend transaction; and
measuring performance parameters for a classified backend skeleton.
12 . The computer-readable medium of claim 11 , wherein the request is generated by at least one of: an application server and a web server.
13 . The computer-readable medium of claim 11 , wherein the backend transaction is at least a standard query language (SQL), and wherein the backend query is at least a SQL query.
14 . The computer-readable medium of claim 11 , wherein the back-end system is at least a database server, and wherein the database server is at least one of: an Oracle Database Server, a Microsoft SQL server, a DB2, and a Sybase.
15 . The computer-readable medium of claim 11 , wherein the backend skeleton is a logical division of the backend query and is utilized for clustering of the backend query.
16 . The computer-readable medium of claim 15 , wherein the backend skeleton is predefined.
17 . The computer-readable medium of claim 13 , wherein the performance parameters include at least one of: throughput, response time, hits per second, latency and number of returned errors.
18 . The computer-readable medium of claim 17 , wherein measures of the performance parameters are compared to predefined thresholds to determine if the backend transaction meets a service level according to a service level agreement (SLA).
19 . The computer-readable medium of claim 11 , further comprising:
processing unclassified backend skeletons together with their respective requests and queries to discover transactions related data.
20 . The computer-readable medium of claim 17 , wherein the transactions related data comprises at least databases, tables, operations and queries that are part of transactions executed over the backend system.
21 . A network device connected in a data center and capable of learning and monitoring transactions executed by backend systems, comprises:
a traffic processor for detecting backend queries in data sent to the backend systems, and wherein the traffic processor is further capable of generating backend skeletons from backend transactions; and
a transaction learner for classifying backend skeletons to identified backend transactions; and
a transaction monitor for measuring performance parameters on backend transactions.