Tables with more than 10 million rows in the SolarWinds Platform database

Tables inside the SolarWinds Platform database can reach more than 10 million rows. If this happens, you may encounter performance issues that in turn would affect how the SolarWinds Platform environment behaves. Tables to note for are the Syslog, Traps, and TraVarbinds tables.

In some cases, you may see a high number of rows in the %CS_cur% or %CS_details% tables.

The issue is caused by the configuration of the SolarWinds Platform (Polling Interval, Retention settings, etc).

Resolution 1

Check and if possible, reduce the polling and retain intervals on the Polling Settings page in the SolarWinds Platform Web Console:

1. Log in to the SolarWinds Platform Web Console.
2. Click Setting > All Settings.
3. Scroll down to Thresholds & Polling, and click Polling Settings.
4. Make the necessary changes in the Polling intervals section.
5. Click Re-apply Polling Intervals.
6. Click Submit.

Resolution 2

• Check the row count of the TrapVarBinds, Traps or Syslogs tables. 
• Truncate Traps and TrapVarbinds

Resolution 3

The rows in large tables cause the SQL drive to fill up. You can truncate these tables.

Note: Large numbers of rows in the database may cause several performance related problems, such as:

• Web performance issues.
• Database maintenance not running or completing.
• Server performance issues 

Consult a DBA before performing the following steps:

1. How to Start, Stop, or Restart SolarWinds Services with the SolarWinds Service Manager in the SolarWinds Platform.
   1. Click Start > All Programs > SolarWinds Platform > SolarWinds Platform Service Manager.
   2. Click Stop Everything (top-left of the Service Manager).
2. Truncate (NOT DROP) the tables that have _Detail name.
   1. Click Start > All Programs > SolarWinds Platform >  Database Manager.
   2. If it does not exist, add the database by clicking Add default server.
   3. Right-click on the database and select new query.
   4. Type the following query into the query box in the middle.

      -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.

      Truncate Table <tablename>_Detail

   5. Click Execute Query to run the query.

Resolution 3

If you see a high number of rows in some of the %CS_cur% or %CS_details% tables (for example, the VolumeUsage_CS_cur table), check the PartitionErrors table. If you notice many errors where these tables are mentioned, contact our Support representatives.