Analytics - Unique query analysis

SQL statement analysis is a detailed account for the selected SQL structure per database.  The SQL statement analysis gives us unique information relative to each query falling under the selected SQL statement structure.

ScaleArc allows you to add the unique query to the cache or as a firewall rule.

View a unique query

Each query pattern contains one or more unique queries. To view the contents of a query pattern:

1. Click on the Analytics tab. Select the time period.
2. Select the cluster and the hour.
3. Hover over a database server.
4. View the query pattern grid.
5. Click on a query pattern to open the screen for unique queries. 
   
   
   
   
6. The graph saws the total unique queries for the specified period and the time to process them on the server(s). Select a different time period at any time in this process to see the unique queries in that period. Note that the new time period may not have any queries. The queries may be broken down into several pages if the list is long.

7. You can add a unique query as a cache or firewall rule. You need to add each query, one at a time.

   

   Note: If you have not added the database referenced in the query pattern in Users & DBs, you cannot create a cache rule for the query pattern. Instead, you will receive an error notification.

    

8. Click Cache to open the popup in the grid detail to add the query as a Cache rule. 
   
   
   
   
   1. The selected query appears in the query field. 
   2. Enter an appropriate value for Time-To-Live (TTL) from the drop-down.
   3. Turn on the cache rule.
   4. Select the appropriate radio button to save the query as a query cache or as a stored procedure cache.
   5. Click Add to save it. 
       
9. Alternatively, click Firewall on the Query detail in the grid to add it as a Firewall rule.
   
   
   1. The selected query appears in the query field. 
   2. Turn on firewall status.
   3. Click Add to save it.