contact@activexperts.com +31748507807

ActiveXperts Knowledge Base Article 7740100

Our mission at ActiveXperts Software is to deliver high quality Network Monitoring solutions and Windows Development components. Our goal is to supplement these solutions with timely support resources that can help at many different levels.
The first thing you want to do is try to find the answer to your problem in the Knowledge Base. If you cannot find an answer to your question in our Knowledge Base, or if you need additional information or assistance, please use our Contact Support form.

Q7740100 - Is it recommended to migrate the Statistical Database to Microsoft SQL Server or MySQL?

ActiveXperts uses an MS Server Compact Database (.sdf) by default:
C:\ProgramData\ActiveXperts\Network Monitor\Stats\Stats.sdf

There are four modules that make use of the statistical database:

All of the above modules use complex SQL queries to retrieve the information from the database. It is strongly recommended to migrate the MS SQL Compact (.sdf) statistical database to MS SQL Server (or MS SQL Server Express Edition) or MySQL, using the database migration wizards included with ActiveXperts. This is because Network Monitor uses complex queries to generate reports and graphs. With SQL Server Compact and even a small configuration (less than 100 checks), generating reports and graphs can take minutes already after a few weeks, whereas with MS SQL it will take only a few seconds or even less.

There's also a limit on the number of records that can be stored in the MS SQL Compact (.sdf) database. See FAQ #7740170 and FAQ #7740174.

To migrate the MS SQl Compact Stats.sdf database file to MS SQL Server or MySQL:

If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using our Contact Support Form

M