nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Help!! My database is massive!! Need to drastically reduce it.

jackiebaron

My database is now up to 56 Gb and I only have a 70 gb hard drive. It says that 49Gb of the database is taken up by rows in the database. Also the Traps table has millions of entries (all the same trap all from the same source). this Table only seems to use up 3.6 Gb but maybe the fact that it has millions of rows could be affecting the overall size of the database. I only have about 700 network objects. I don't need all the traps in the Traps table and would like to clear them out. What is the command for this?

select top 1000 * from Traps <------- gives me the top 1000 entries in the traps table.......but how do I delete them.

I'm not very good at SQL....sorry (and thanks)

jackie

Find more posts tagged with

Accepted answers

All comments

jtimes

Jackie,

Your post presents several questions, but I will attempt to answer you main question with this post (read the entire thread)

Then search the forum for these key words: database, truncate, maintenance. there are several other very useful post that pertain to getting and keeping your DB under control.

If all else fails and you can't seem to rope-in your DB, then open a ticket with support.

jackiebaron

Thanks John,

I managed to truncate a table that was using up 43Gb.....however there has been no change to my disk being full. The database still registers as 56Gb (even though only 2 or 3 Gb is being used). so I guess I have a database that has "reserved" 56Gb of diskspace. How is it possible to shrink this? My machine is about to croak, I fear.

jackie

bleearg13

I would suggest trying to use the Solarwinds Database Manager to do a "Compact" operation on the DB. However, I am not a DB expert, so this may not be the fastest way to resolve your issue.

jtimes

okay, read this thread:

jtimes

I would suggest trying to use the Solarwinds Database Manager to do a "Compact" operation on the DB. However, I am not a DB expert, so this may not be the fastest way to resolve your issue.

If your going to do this, I would recommend doing the tables individually. Doing the entire DB at once might take a while, so for starters take the table you just truncated and perform a manual Compact/Rebuild Indexes on it. Then go back to the DB details screen to see if your data space usage has shrunk considerably or not...

Lastly, you might want to get a DBA, or SolarWinds Support to assist you with this, but it sounds as if you need to setup a SQL Maintenance Routine to shrink your db...