Is your application multi-tenancy, where each tenant lives in its own database? We have such a scenario at VividCortex, and many of our customers do as well. Wouldn't it be nice to understand which tenants are causing more load than others, which are the noisy neighbors impacting others' experience, and so on? Well, now you can!
We now support per-database metrics in Top Queries. You can change the Rank menu from Queries to Databases, and you will see a breakdown of database activity in the familiar format, all in 1-second resolution.
As you can see from the Lock Waits column in the image, computed columns work as usual too, so you can quickly figure out which databases are consuming more resources such as CPU or IO in addition to the standard metrics (time, [Read more...]