Analytics - Database server analysis

ScaleArc provides pie charts to show the type and percentage of query traffic handled by each database server for the selected time period.

Follow these steps to view analytics reports for database server traffic:

  1. Click on the ANALYTICS tab then Select the time period.
  2. Select the cluster and the hour.
  3. Click on a selected hour (do not click the + sign). 

    Analytics-DBTrafficDetail.png
     
  4. The first pie chart shows the total number of queries processed by each of the database servers in that cluster for the selected hour. The other pie chart shows the time taken by the server(s) to process the queries for the selected hour. The chart also lists the number of database servers assigned to the cluster. The table below the charts breaks down the total queries, cache hit, server time, cache time, time saved (by ScaleArc), and Read:Write ratio for each server.

    Analytics-UniqueQuertydetail.png

  5. Hover on a database server to see the breakdown of its query traffic (lower panel). The chart shows a breakdown of which physical servers handled what volume of traffic.  The chart on the right provides the type of traffic handled by one of the servers (reads, writes, errors). A summary of traffic showing queries serviced by the server and those serviced by cache appears on the right. 
  6. Hover over another database server to see its break down of traffic. This chart shows errors.

    Analytics-FourQDBError.png
     
  7. Next, see Query pattern analysis.

Comments

0 comments

Please sign in to leave a comment.