ActiveXperts Network Monitor KB - Reports and Graphs - Statistical Database
'Reports and Graphs - Statistical Database' Knowledge Base Articles
| 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: Full Report module Instant Report module (accessible from the Manager's context menu) Inst ... | |
| Q7740120 | Is there any performance difference between MS SQL Server and MS SQL Server Express Edition? |
| MS SQL Server is faster than MS SQL Server Express Edition and can handle more records. It is strongly recommended to migrate your statistical database to either MS SQL Server or MS SQL Server Express Edition to boost the performance of the reporting and graphing tools. MS SQL Server provides ... | |
| Q7740150 | When I create a new (Instant) Report, there is a note saying "The Statistical Database is based on an SQL Compact Edition database. This slows down the creation of a report or graph. It is strongly recommended to migrate this database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool' to boost performance". Why is it? |
| See FAQ #7740100. ... | |
| Q7740154 | When I create a new Graph, there is a note saying "The Statistical Database is based on an SQL Compact Edition database. This slows down the creation of a History View. It is strongly recommended to migrate this database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool' to boost performance". Why is it? |
| See FAQ #7740100. ... | |
| Q7740160 | When I create a new (Instant) Report, there is a warning "There's a large number of records in the ReportData table of the Statistical Database, based on SQL Server Compact. This slows down the creation of a reports. It is strongly recommended to migrate this database to MS SQL Server or MySQL". Why is it? |
| See FAQ #7740100. ... | |
| Q7740170 | When I create a new (Instant) Report, there is the error "There are too many records in the ReportData table of the Statistical Database, based on SQL Server Compact. Please migrate the database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool". What should I do next? |
| This means that there are too many ReportData records in your SQL Server Compact Statistical Database File, file: C:\ProgramData\ActiveXperts\Network Monitor\Stats\Stats.sdf You should migrate your database to MS SQL Server or MySQL. See FAQ #7740100. This limitation is not hardcoded in ... | |
| Q7740174 | When I create a new Graph, there is an error "There are too many records in the GraphData table of the Statistical Database, based on SQL Server Compact. Please migrate the database to MS SQL Server or MySQL using the 'Report and Graphs Configuration Tool". What should I do next? |
| This means that there are too many GraphData records in your SQL Server Compact Statistical Database File, file: C:\ProgramData\ActiveXperts\Network Monitor\Stats\Stats.sdf You should migrate your database to MS SQL Server or MySQL. See FAQ #7740100. This limitation is not hardcoded in ... | |
| Q7740176 | I get the following System Warning in my log file: "Too many outstanding ReportData table insert requests. Reconfigure or disable Statistics using the Statistics Configuration Tool". |
| This means that there are more insert requests on the Statistical Database Report table than the ActiveXperts Network Monitor Engine service can handle. There can be various reasons for that: The statistical database is offline The statistical database cannot be connected The network connec ... | |
| Q7740178 | I get the following System Warning in my log file: "Too many outstanding GraphData table insert requests. Reconfigure or disable Statistics using the Statistics Configuration Tool". |
| This means that there are more insert requests on the Statistical Database Graph table than the ActiveXperts Network Monitor Engine service can handle. There can be various reasons for that: The statistical database is offline The statistical database cannot be connected The network connect ... | |
| Q7740210 | My Activity View frequently shows the following messages: "SYSTEM ERROR: Query failed: [INSERT INTO GraphData( TimeSecs ) VALUES( 0 )]; Modify failed, error 0x80040E14 error #3092: One or more errors during processing of command." and also "SYSTEM ERROR: Query failed: [SELECT * FROM ReportData WHERE ID=x]; Open failed, error 0x80030070, The is insufficient disk space to complete operation." |
| The reason for this problem is, that the maximum size of the statistics database file has exceeded. Although the maximum size for SQL Compact .SDF files is 4GB, the database driver uses a default maximum of 256MB. This 256MB limit can be increased by specifying a limit in the connnection string ... | |
| Q7740220 | On generating a Graph, we get error 20005: "Unable to open database connection". How can we fix this error? |
| There can be various reasons for this. ActiveXperts provides tools to troubleshoot such problems. First of all, check the status of the connection in the Statistics Configuration Tool: In the Manager, open the 'Tools-Statisticss' from the menu bar and launch the 'Statistics Configuration ... | |
| Q7740300 | The Cleanup function of the Statistical Database doesn’t seem to be working properly. The procedure does not delete all old data. How can I investigate what the problem is? |
| The engine executes a query to delete old data. Apparently, something goes wrong with the query. To make it visible which query is being executed and what the result is, do the following: Stop the ActiveXperts Network Monitor Engine service Open the registry editor (REGEDIT.EXE) Assign a va ... | |
| Q7740330 | I want to extract monitoring data from ActiveXperts to use in my custom application. Is this possible? |
| To retrieve monitoring data from ActiveXperts Network Monitor, you can use the statistics database. The statistics database is typically an MS SQL database. However, by default, a SQL Compact Edition (SDF) database is used. But most users migrate the statistics database to MS SQL Server to stor ... |
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