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

NPM Database

Dear Thwack Team,

I have updated the syslog retention time from 60 days to 30 days. Currently the database size is around 55 GB. How much time will it take for database size to be reduced.

Thanks in advance.

Find more posts tagged with

Accepted answers

shuth

You will need to check your database in SQL. Deleting data from the database will leave white space in the database. You will need to shrink the database in SQL to reduce the database file size.

E.g. (rough numbers)

Database size: 70 GB
You delete 30 GB of syslog messages
Database size: 70 GB (with 30 GB of white space)
Shrink the database
Database size: ~40 GB

Refer to @sturdyerde's post above.

All comments

shuth

The maintenance runs nightly at 2:15am by default (configurable under your Polling Settings). If you don't want to wait, you can manually run the Database Maintenance tool on the SolarWinds server.

During maintenance, any syslog data older than the retention period (30 days) will be deleted from the database. This will leave white space in the database file. You can shrink the database in SQL to reduce this file size.

haris_salim

@shuth, thanks a lot for your reply. I hope database maintenance does not involve any downtime? Since we are monitoring critical services so cannot afford any downtime. Would appreciate your update...

shuth

No, there is no downtime during maintenance. The maintenance runs every night cleaning up the database and aggregating data per your retention polices.
E.g. Detailed data older than 7 days gets summarised into hourly stats.
Hourly data older than 30 days gets summarised into daily stats.
Daily data older than 365 days gets deleted.

haris_salim

Thank you for the reply. I actually wanted to know what if i run database maintenance (orion server-> start -> database maintenance). Will there be any downtime?

and what if i shrink the database, will there be any downtime?

sturdyerde

@haris_salim, please note @shuth's comment about shrinking the DB. Reducing the actual size of any DB is a manual process. Read through https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database to gain more understanding about that process.

shuth

You will need to check your database in SQL. Deleting data from the database will leave white space in the database. You will need to shrink the database in SQL to reduce the database file size.

E.g. (rough numbers)

Database size: 70 GB
You delete 30 GB of syslog messages
Database size: 70 GB (with 30 GB of white space)
Shrink the database
Database size: ~40 GB

Refer to @sturdyerde's post above.

haris_salim

@shuth, thanks.

Let me try this and will update.

Bye