Hi All, As the title suggests, my installation of NPM is complaining that it is over 80% full.. I saw some older documentations on how to fix this, I ran the truncate commands on my database tables but that doesn't appear to have done much, and I think the steps changed with new versions I.E. someone mentioned to right click my database and "compact" it however I saw no such options. If someone could please walk me through getting my DB cleared up, perhaps also help changing the retention periods so they don't pile up again that would be super awesome. I tried reading the documentations for this and they mentioned Orion System Manager but didn't state how to find it. Software Version Windows Server 2008 R2 OS Version 6.1.7601.65536 Service Pack Service Pack 1 Database Server (local)\SQLEXPRESS Catalog SolarWindsOrion Database Engine Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) SQL Version Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) ; Product level : SP2 Security Model Username / Password User Name SolarWindsOrionDatabaseUser Connection Timeout 20 Network Elements 7175 Nodes 4167 Interfaces 2362 Volumes 646 Alerts 10590 Events 129874 Pollers 20059 Polling Engines 1 Last Database Archive 01-Jul-2015 02:17 AM Next Scheduled Database Archive 02-Jul-2015 02:15 AM Database Archive Time 02:15 AM Retain Detail Stats 7 Days Retain Hourly Stats 30 Days Retain Daily Stats 365 Days Retain Events 30 Days Thanks, B

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Solarwinds Database over 80% full

FormerMember over 8 years ago

Hi All,

As the title suggests, my installation of NPM is complaining that it is over 80% full.. I saw some older documentations on how to fix this, I ran the truncate commands on my database tables but that doesn't appear to have done much, and I think the steps changed with new versions I.E. someone mentioned to right click my database and "compact" it however I saw no such options.

If someone could please walk me through getting my DB cleared up, perhaps also help changing the retention periods so they don't pile up again that would be super awesome. I tried reading the documentations for this and they mentioned Orion System Manager but didn't state how to find it.

Software Version	Windows Server 2008 R2
OS Version	6.1.7601.65536
Service Pack	Service Pack 1

Database Server	(local)\SQLEXPRESS
Catalog	SolarWindsOrion
Database Engine	Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
SQL Version	Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) ; Product level : SP2
Security Model	Username / Password
User Name	SolarWindsOrionDatabaseUser
Connection Timeout	20

Network Elements	7175
Nodes	4167
Interfaces	2362
Volumes	646

Alerts	10590
Events	129874
Pollers	20059
Polling Engines	1

Last Database Archive	01-Jul-2015 02:17 AM
Next Scheduled Database Archive	02-Jul-2015 02:15 AM
Database Archive Time	02:15 AM

Retain Detail Stats	7 Days
Retain Hourly Stats	30 Days
Retain Daily Stats	365 Days
Retain Events	30 Days

Thanks,

Top Replies

HolyGuacamole over 8 years ago in reply to FormerMember +1

If you choose the 'Express' install option as opposed to 'Advanced', the installer will install a local instance of SQL Express with a 10GB limit. If you installed a full version of SQL elsewhere or on…

0 HolyGuacamole over 8 years ago

Remote desktop to the SolarWinds server. Launch the Database Manager, and click on 'Add Default Server'. Once you see the database, you can right click to see properties and sort on the size. You will need to see what tables these are before you can truncate so as to not cause data integrity issues. To compact the database, you will need to install SQL Management Studio.
Cancel
Vote Up 0 Vote Down

Cancel
0 tomas.vymetal over 8 years ago

Please keep in mind that SQLEXPRESS has limited maximum DB size.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 8 years ago in reply to HolyGuacamole

Thanks HolyGuac, I was able to clear out the error before the weekend. Unfortunately, now it's extra angry and over 90% full. I will need to get off sqlexpress. If I wanted to keep the DB on the same server as the NPM would it be possible to create another database and import the old db into the new? Or backup, delete, and restore into correct database? Any tips you have here would be most appreciated.
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 8 years ago in reply to tomas.vymetal

Thank you for that most helpful tip.
Unfortunately, that information was not displayed where it would have been most helpful and that is during the installation process. I followed the directions/prerequisites and installed SQL 2008 Database, the Solarwinds installer did the rest and created the SQLEXPRESS database. Why it defaulted to that database, I don't know.
Cancel
Vote Up 0 Vote Down

Cancel
0 HolyGuacamole over 8 years ago in reply to FormerMember

If you choose the 'Express' install option as opposed to 'Advanced', the installer will install a local instance of SQL Express with a 10GB limit. If you installed a full version of SQL elsewhere or on the same machine, you might want to look for Microsoft instructions to backup and restore a database. After you restore the DB, you can start using the new DB instance. Alternatively, if you don't care about historical data, simply re-run the Configuration Wizard and you can choose the new DB instance.
Did you open the Database Manager as advised earlier to check which tables are taking up the most space?
Cancel
Vote Up +1 Vote Down

Cancel