We’ve received a lot of feedback regarding Ruxit database analysis and we’ve optimized our approach based on your input. Ruxit database analysis is now faster, easier to use, and provides more detailed information. Each database Services page now includes an Analyze database activity button beneath the Response time chart.

Database analysis

Click the Analyze database activity button to go to a detail page that features a layout you may already be familiar with. This page layout looks a lot like the Ruxit Services details page. What’s new is that all relevant database statements executed during the last 30 minutes are listed at the bottom of the page. By default, database statements are sorted based on median response time. Alternatively, you can sort database statements based on number of executions, failure rate, total time, or slowest response time.

Database analysis

Note that this new database statement table view is similar to the new response time analysis view. Click any statement to view full details:

Database analysis

In addition to providing full details about each statement’s execution, Ruxit also shows you which services executed each selected database statement. With this approach you can filter the statements based on database-statement type. Click any database method, for example a query, to view only the query statements.

Database analysis

The real power of the new database analysis views reveal themselves when it comes to analyzing performance degradation. You can immediately see which statement is responsible for a given slowdown. In the example below, the detected slowdown was caused by a single statement (delete from Booking where id=?). The statement that caused the database slowdown was executed by the JourneyService.

Database analysis