Feature request - alert new/deleted databases

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Feature request - alert new/deleted databases

Postby oderks » Thu Mar 17, 2011 9:55 am

With applications like MOSS and such we currently have some instances with application users in db_creator role

I'd really like to be alerted/notified when a new database is created. In my case not so much for 'knowing someone added a new database', but more for the planning of necessary follow-up actions like adjusting reserved space, check if backup plans are sufficient and such.
Posts: 46
Joined: Wed Jul 30, 2008 8:57 am

Postby priyasinha » Thu Mar 17, 2011 10:07 am


Thanks for your feedback. We are tracking it as SRP-1268.

Posts: 549
Joined: Wed Jan 03, 2007 4:02 pm

Postby fionag » Wed Apr 18, 2012 12:08 pm

I appreciate this is an old forum post, but I came across it whilst reviewing open bug reports.

I don't know if you are still using SQL Monitor and if so are aware of the new Custom Metrics feature? It's purpose is exactly for this type of alert.

I had a quick play and came up with the following T-SQL that you can use in a custom metric which would then force an alert if a new DB was created.

WHEN create_date >= DATEADD(d, -1, GETDATE()) THEN 1
FROM sys.databases
WHERE database_id = DB_ID()

If you create the custom metric and run it against "All User Databases" and then set up an alert if the value goes past "0" then this will alert for new databases created in the last day.

I appreciate this may not make sense if you haven't used the custom metrics feature, in which case I encourage you to check out the information on this feature in our support center.

http://www.red-gate.com/supportcenter/C ... 469829.htm

Hope that's of some help.
Posts: 41
Joined: Thu Jan 05, 2012 4:40 pm
Location: Red Gate

Postby oderks » Fri Apr 20, 2012 7:37 am

Thanks. I've seen the feature in SQL Monitor 3 and will plan an update soon as we are running 2.3
Will also check if it's possible to alert on deleted databases.
Posts: 46
Joined: Wed Jul 30, 2008 8:57 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests