Live Reports

Active Databases report provides a brief about the activities across multiple databases which are monitored by the sqlShark engine. At any given point last 24 hours data is aggregated. Currently information about active connections, server utilization time, data transferred, and data sent is available as part of this report. This information can be used for selecting appropriate filters for detailed analysis.

Alerts report lists the alerts that are generated in last 24 hours across all database instances that are monitored.

Login Activity report provides an insight into all users that have connected to the database in last 24 hours.

Performance Report provides a live representation of performance across all database instances that are monitored.

Audit Trail reports list the live transactions that are executed against the databases monitored by various engines.

Audit Trail report lists all the transactions for a given instance of a database. This report can be used for detailed analysis of user patterns, unauthorized access, and identifying any exceptional behavior. Audit trail report can be filtered based on various permutation and combination of source host, transaction, timeline, and query type.

Failed transaction report is an activity report which lists down all the transactions that are not executed successfully on the database server. This report will contain failed activities.

Data Send report provides a snapshot of the data sent as a part of a request from various clients. This report can be used to detect bottlenecks in database performance when a large amount of data is pushed onto the database server on an irregular basis. The large number of updates can also be a potential threat where the end user makes changes across the entire database.

Data Response report provides details of the data send by the server as part of the response to various queries. Exceptional cases can also be identified as threats since the entire system is exposed to end users.

Data Transfer report is a super set of the Data Send report and the Data Received report. A filter can be applied on various parameters viz client host, ip, query type, and time.

Execution Time report lists the time required for executing a query on the database server. The execution time does not include the network latency or any other parameters. This report along with the other performance reports can be used to effectively identify parameters that impact the performance.

Executions report lists the frequency of the execution of queries filtered by various parameters.

Top Data Send report lists the top queries that send a large amount of data as part of the request. Standard filters can be applied for fine tuning.

Top Data Response report lists down the top queries based on the response size of the queries.

Top Data Transfer report list the top queries where maximum data transfer is done between the server and the client.

Top Execution Time report lists the queries based on their execution time on the database server. In this case the network latency is not considered.

Top Executions report lists the Queries which are executed at a higher frequency from a particular host and user.

Custom Reports are for advanced users. It is a simple alternative to open the interface, implement the required queries to extract data from the system, and build reports. You can also use the Custom Reports to analyze the entire audit trail.

Custom Reports are for advanced users. It is a simple alternative to open the interface, implement the required queries to extract data from the system, and build reports. You can also use the Custom Reports to analyze the entire audit trail.

User has the capability to save the result of custom reports in PDF or CSV format.