Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

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

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

Updated Decmber 7th, 2017

Overview

The Engineer's Toolset edition of 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 Performance 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 Platform edition of Network Performance Monitor which uses a Microsoft SQL Server database.

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

Environment

  • All versions of Windows
  • All versions of Engineer's Toolset Network Performance Monitor

Cause 

This error occurs due to the database nearing its 2 Gigabyte 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\Toolset\SWNetPerfMon.cfg

  5.   Once the repair has completed, close Access.

  6.  Open Network Performance Monitor.

 

 

Last modified

Tags

Classifications

Public