Database Search in SQL Monitor

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.

2022-07-12 09_20_30-Global Dashboard — Mozilla Firefox

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.

2022-07-12 09_22_07-Global Dashboard — Mozilla Firefox

If I add the weekly, then you see there is a cluster of two machines that have this database.

2022-07-12 09_22_17-Global Dashboard — Mozilla Firefox

If I pick one of these machines, I can see the databases with this name listed.

2022-07-12 09_25_56-ssc-db-n1_(local) - Server Overview — Mozilla Firefox

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.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.