Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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: 774 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