Knowledge Base FAQ Item #7780100
Q7780100: Is it recommended to migrate the Statistical Database to MS SQL or MySQL?
There are three modules that make use of the statistical database:
- Report module
- History View module (accessible from the Manager's context menu)
- Graph module (accessible from the Manager's context menu)
All of the above modules use complex SQL queries to retrieve the information from the database. By default, an MS SQL Server Compact database is used (it is installed with the product).
It is strongly recommended to migrate the SQL Server Compact 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.(viewed: 1812)