Comparative analysis allows administrators and developers to understand changes in SQL patterns and their effect on resource utilization. Using the Compare Patterns tool you can compare any hour of ScaleArc analytics data for a given cluster and database to any other hour of available analytics data. This tool is very useful for troubleshooting performance or application behavior changes; for instance, to isolate the aberrant behavior seen during SQL injection attacks or to validate the integrity of a software upgrade.
Compare query pattern
You can compare query patterns for your selected time period as follows:
- Click on the Analytics tab. Select the time period.
- Select the cluster and the hour.
- Select a database server to view its type and percentage of query traffic.
- Click on a database server balloon to view its SQL query details.
- Click Compare Patterns to open the screen.
- Select a time period to compare the query patterns. Then, select a tab to compare the data in this time period:
- Click the SIDE BY SIDE tab to compare all query patterns within the selected time range.
- Click the UNIQUE IN TIME A or the UNIQUE IN TIME B tab to see patterns that are unique to either category in the selected time range.
- Click the UNIQUE IN BOTH tab to see the patterns that are unique in both categories in the selected time range.
- Change the time period to compare the query patterns in a different time segment.