Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Engineer's ToolSet (ETS) > Error message: "Database is nearing its maximum capacity" while you are using Network Performance Monitor

Error message: "Database is nearing its maximum capacity" while you are using Network Performance Monitor

Created by Chris Foley, last modified by MindTouch on Jun 23, 2016

Views: 66 Votes: 0 Revisions: 4

Overview

The Engineer's Edition Network Performance Monitor uses a Microsoft Access database. Access databases have an inherent file size limit of 2GB. Once your database reaches this size, the Network Perforance Monitor will no longer be able to store statistics.

If you are monitoring a large network or storing data over an extended period of time you should consider using the Orion Network Performance Monitor which uses a Microsoft SQL Server database.

To continue using the Engineer's Edition Network Performance Monitor, you will want to shrink the database periodically.

Environment

  • All versions of Windows
  • All versions of Toolset's NPM

Cause 

This error occurs due to database nearing its 2 Gigbyte size limit.

Resolution

Solution 1:

  1. Close Network Performance Monitor. 
  2. Run the following executable:

C:\Program Files (x86)\SolarWinds\Toolset\Database-Maint.exe

  3.  Select Compact and Repair"and click Run Job. 

  4.  Select Network Performance Monitor - Nightly Maintenance and click Run Job.

  5.  Open Network Performance Monitor.


Solution 2:

  1. Close Network Performance Monitor.
  2. Open Microsoft Access (2000 or later).
  3. Select Tools >Database Utilities > Compact and Repair Database.
  4. Select the following file:

C:\ProgramData\SolarWinds\ToolsetSWNetPerfMon.cfg

  5.  ​Once the repair has completed, close Access.

  6.  Open Network Performance Monitor.

 

 

Last modified
19:21, 22 Jun 2016

Tags

Classifications

Public