SQL Database is growing fast

Hi,

we run NPM, APM,NTA and NCM on a SQL 2008 x64 Database. This Database is growing very fast.

I did a compact database 10 days ago and we had a size of 7GB after that. Now ten days later the Database is back to 57GB and the server is very slow because swapping.

I run compact database at the moment and I just see a "not responding" and hope it will run anyway.

Is there a way to schedule a compact database on a daily base?

here some details:

Database Engine     Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Standard Edition (64-bit) on Windows NT 6.1 (Build 7600: ) (Hypervisor)

Network Elements     2417
Nodes     403
Interfaces     1606
Volumes     408
Alerts     140
Events     233263
Pollers     4277
Polling Engines     1
Retain Detail Stats     7 Days
Retain Hourly Stats     30 Days
Retain Daily Stats     365 Days
Retain Events     30 Days

thanks

Eike

Find more posts tagged with

sql_2008

database_size

sql

Database

compact

database_space

database_maintenance

Accepted answers

pacetti

exact,

The section "Creating a Database Maintenance Plan" in the SolarWinds Orion NPM Administrator Guide provides a procedure for creating a scheduled backup of your database that includes a db compact and shrink.

HTH,

All comments

pacetti

exact,

HTH,

FormerMember

Hi Pacetti,

sorry you right was a while ago as I created that.

But.. it ran for 6 days and from this point it failed. Becaue that I started a manual compact database.

Compacting still hangs at "NetFlowSummary2 table" for about an hour now (like three times before)

Eike

bshopp

Are you storing alot of Syslog and Traps? That will cause your DB to grow fast. Also how many flows per second are you sending?

This doc might be a good read as well here

netlogix

I had an issue where my sw database maintenance (Database-Maint.exe) was failing because my temp DB couldn't grow big enough to handle the shrink process.

Have you looked in "C:\Program Files (x86)\SolarWinds\Orion\swdebugMaintenance.log"?