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

Tidying Up After Deleting Interfaces

Morning all, quick SQL/database maintenance query:

If I'm deleting interfaces from dbo.Interfaces with SQL 'delete' commands will the overnight maintenance job automatically tidy up all the other data associated with those interfaces when it sees them not being monitored any more? I'm specifically thinking of all the data in dbo.InterfaceTraffic_[Daily|Detail|Hourly], dbo.InterfaceErrors_[Daily|Detail|Hourly] and dbo.InterfaceSignalNoise_[Daily|Detail|Hourly]

(Oh, and as a quick addendum: if I delete a node will all it's interfaces (and the stuff I mentioned up there) also get cleaned up?)

Find more posts tagged with

Accepted answers

bshopp

DB Maintenance is schedule to run nightly, typically at 2am by default.

All comments

bshopp

You should either use stored procedure swsp_DeleteInterface (passing interfaceID as parameter) or insert IDs of deleted interfaces into DeletedInterfaces table.

When the IDs are in the DeletedInterfaces table, DB maintenance will handle the rest (delete historical data etc.)

GaryP

Cheers bshopp, I'll have to modify my bulk deletion scripts to take this into account as I fear I may now have rather a lot of historical data left cluttering up the database.

wwiley

This is what I did:

INSERT INTO DeletedInterfaces (InterfaceID)
SELECT InterfaceID
FROM Interfaces
WHERE CLAUSE

Then

DELETE FROM Interfaces
WHERE CLAUSE

MarieB

Hi wwiley--

Thanks for posting for the community.