Configuring SQL Monitor

I got to meet with the team who creates SQL Monitor today. (Yes, I have a very cool job!) Since I’m kind of new to SQL Monitor, they wanted to know what I didn’t like about it. Well, I had a hard time coming up with anything because I found it so easy to use. Once I had watched a couple of videos, I was able to find my way around easily. The tool seems very complete as well. Everything that I could think of that I wanted to monitor was either there by default or a script to add it as a custom metric was available.

Finally, I thought of something. I wanted to create an exception list for the ‘Database Unavailable’ alerts. When I went to the to the configuration page, I was hoping to see a way to add a database name that was set offline on purpose. This is what I saw:

SQLMon2-1

I didn’t see any way to set up an exception list. It would get annoying really fast to be alerted about an offline database that was purposely offline.

I knew that it could be set across the organization, group, and instance. I didn’t realize, however, that it could also be set at the database level. Just by drilling down, I could turn this alert off for an individual database!

SQLMon2-2

 

By default, settings are inherited from the organizational level. Below that, you can customize at the SQL Monitor group, server, instance and database level. For example, there are probably some metrics that are important for production servers that you don’t care about for development servers.

I’m back trying to think of something I don’t like about SQL Monitor. I’ll keep you posted about that. If you want to play with SQL Monitor, check out this live demo.  It’s actually monitoring Redgate’s live SQL Server instances. Enjoy!

About Kathi Kellenberger

I am the editor of the online journal Simple Talk. I love talking about SQL Server to anyone who will listen, just ask my five year old granddaughter. I love to write and teach. I am so humbled and honored to say I am a Data Platform MVP, a volunteer with LaunchCode and co-leader of PASS Women in Technology Virtual Group.
This entry was posted in Database Administration. 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 )

Google+ photo

You are commenting using your Google+ 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