One DB query is bringing down your App and the users are getting edgy! Now what?

Consider a scenario: Your application has just started getting slow. Your end users are getting agitated and they have started complaining. Now you need to figure out the root cause very quickly. It is an issue of a database query taking longer than expected, but you don’t know it. You log in to your networking monitoring product. It shows all systems are up and running including the machines on which the database and the application server are hosted and bandwidth is also not an issue. Now what?

With Minder being a truly unified monitoring product, it’s very easy to figure it out. As it monitors database performance, network, system and application layers together, detecting an issue with an anomaly in the database performance is piece of cake. With a single click, it pinpoints the database instance where the problem is and lets you drill down to a table, session or even a query level to identify the culprit. Within few seconds, you’d know what and where the problem is and once corrected, voila! Your application is back up and your end users are happy!

DB details

As you can see from the image above, the application layer is in warning state right now (last bar is yellow) and clicking on it lets you view the details about the monitor facing a problem with details. Clicking on the monitor takes you to the template where you can get the complete overview of all the components including the tables, indexes, queries and much more residing on that database instance.

Minder shows the top queries in the live environment based on the below four parameters:

  • Execution time
  • CPU time
  • Memory Usage
  • Number of disk reads

 

With Minder, you can have a complete visibility on all of your database instances in terms of

  • Number of active connections
  • Connection Time
  • Top 5 tables by Row
  • Top 5 tables by size
  • Active Lock and Wait details
  • Transactions
  • Index Trend
  • Event Correlation details

 

Tables Information:

DB Tables_0

Database Template:

DB Template