Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Alerting on new and dropped databases

Is there a way to monitor for databases that are either dropped or added? Using SolarWinds DPA 2019.4.1054 for SQL Server.

Find more posts tagged with

SQL Server

dropped database

new database

Alerting

Accepted answers

cpriddy

Hi Tony,

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

from sys.databases

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: blog.sqlauthority.com/.../ 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 thwack.solarwinds.com/.../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.

Thanks,

Chuck Priddy

Chuck Priddy | Senior Product Manager – Systems Management 

Database Performance Analyzer (DPA)

Success Center

image001.png

All comments