Red Gate forums :: View topic - Feature request - alert new/deleted databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Feature request - alert new/deleted databases

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
oderks



Joined: 30 Jul 2008
Posts: 46

PostPosted: Thu Mar 17, 2011 10:55 am    Post subject: Feature request - alert new/deleted databases Reply with quote

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.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Mar 17, 2011 11:07 am    Post subject: Reply with quote

Hi,

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

Regards,
Priya
Back to top
View user's profile Send private message
fionag



Joined: 05 Jan 2012
Posts: 32
Location: Red Gate

PostPosted: Wed Apr 18, 2012 1:08 pm    Post subject: Reply with quote

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.

SELECT
CASE
WHEN create_date >= DATEADD(d, -1, GETDATE()) THEN 1
ELSE 0
END
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/Content?p=SQL%20Monitor&c=SQL_Monitor/help/3.0/SM_AboutCustomMetrics.htm&toc=SQL_Monitor/help/3.0/toc1469829.htm

Hope that's of some help.
Fiona
Back to top
View user's profile Send private message
oderks



Joined: 30 Jul 2008
Posts: 46

PostPosted: Fri Apr 20, 2012 8:37 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group