If the database is the engine of your application, then Clarity's Database Management section is its instrument panel. Go here to spot issues early and help ensure smooth processing.
Database Management Summary
A quick look at Clarity's Database Management Summary reveals how many queries are running against the database and if any are blocked. While blocked queries are a normal and unavoidable part of any relational database, its good to make sure they clear.
Currently Running
Blocked queries can be monitored in the Currently Running table. You can see what login ID is running the query and which program initiated it as well as database and execution details.
- Click Refresh to view all active queries or search for a specific one.
- Click on any query in the list to see the full-text details.
- Review IO Read/Writes and other information needed to find and stop blocked queries.
Analysis
Wait times are normal, but you can fine-tune your database by addressing the most common types of wait times. Find the information you need in the Analysis section.
- Wait Type Distribution — Hover over the pie chart to see why your queries are waiting to run. This includes User I/O, System I/O, Commit, and Network.
- Most Expensive Queries — Get insight on the processes that are reading/writing to the database most frequently. These may provide opportunities for table indexing. You can click on an entry to see greater detail.
- CPU Pressure — Check the CPU gauge to make sure the database server isn't overtaxed. High CPU pressure often means database performance is slow.