Due to disk space issues I would like to relocate the Network Monitor and Network Performance Monitor databases to a local 😧 drive on my Engineers Toolset box. Is this possible? if so what are the configuration options that need changing?
Sorry for delay with answering your question. Here is what we found as possible approach.
Moving NPM DB
Connection=Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;Data Source=c:\swnetperfmon.cfg
*BUT* replace the c:\swnetperfmon.cfg with the actual path and filename to your file.
This will not work for the Network Monitor though.
What you can do to save some space is to compact the DB.
Both of the DBs (and almost all in Toolset) are nothing more than just Microsoft Access databases with different file extension (.cfg). So if you rename them to .mdb, you can open in MS Access. One of the disadvantage of that DB is that even if you remove some rows from the DB the DB file size is not reduced. So it grows and grows and grows (the limit is something less than 2GB). Fortunately there is a tool which can compact it – it doesn’t remove any data, it just “remove gaps” and file size is then dramatically reduced. You can do it using MS Access DB, or better using our internal tools which are not available in the Start menu, but just in Toolset installation directory (Network-Monitor-Maint.exe for Network Monitor).
Please let us know if it helped and whether you would need us to investigate other options.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.