Last modified May, 18, 2017
Database server analysis

In a typical production environment, the pie-chart graph focuses on the flow of SQL query traffic through one or more database servers. You can download a report of the server analysis at any time.

View database server traffic

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

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

     
     
  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. Another 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.



  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 server (reads, writes, errors). A summary of traffic showing queries serviced by the server and those serviced by cache appears o the right. 
  6. Hover over another database server to see its break down of traffic. This chart shows errors.

     
     
  7. Next, see Query pattern analysis.


 

 

 

 

 

 

 

 

 

 

 

 

 

On this page



 

 

Comments

    Add new comment