I learned something new recently. I can search in SQL Monitor for a database name, not just a server or instance name.
I tested this over at monitor.red-gate.com recently after a developer mentioned this feature. If you look at the Global Dashboard, there are a lot of machines. You can see 28 instances monitored, but many more databases.
If I were looking for the DatabaseWeekly database, I would need to know which instance this was hosted on. I do know, but someone in our IT support org might not.
However, if they start typing in the search box at the, the instances shrink. This is the top left box that has “Filter by name” in light text. If I type “database”, you can see fewer instances.
If I add the weekly, then you see there is a cluster of two machines that have this database.
If I pick one of these machines, I can see the databases with this name listed.
A handy little feature I knew nothing about.
Give this a try if you have SQL Monitor and save even more time digging into performance issues. If you don’t have SQL Monitor, download an eval today and give it a try.