In DPA you can create custom alerts and even custom metrics. In Thwack page for DPA, search for “custom alert” and you can see a lot of examples.
Some quick thoughts:
As far as newly created databases, you could base it on a query like:
select as database_name,create_date
where(convert(date,create_date) = convert(date,GETDATE()))
order by name
For dropped databases, a little bit more complicated – might look at this SQL Authority Blog: https://blog.sqlauthority.com/2015/09/12/sql-server-who-dropped-table-or-database/ I suspect you can also retrieve the time the table was dropped and do a similar comparison for the alert like the create above.
If not or as an alternative, you could go with a variant of this custom alert https://thwack.solarwinds.com/docs/DOC-172886 article and store yesterday’s list of DBs in a table, and store today’s list in a second – then query to identify any rows in yesterday’s that don’t exist in today’s.
Chuck Priddy | Senior Product Manager – Systems Management
Database Performance Analyzer (DPA)
image001.png 2.3 KB