Hello,
I have a problem using LogAnalyzer.
I'm using SQL2005 Express to log to using ODBC.
OS = Windows Server 2003 R2, Standard, UK version.
Dual Xeon @ 3Ghz., 2GB RAM.
HostMonitor itself + logging are working perfect.
All records are logged in SQL2005 Express correctly.
Problem 1:
When starting LogAnalyzer (from the machine where HM + SQL are running) I can correctly connect via ODBC with the SQL server.
Data is received from the DB, and displayed.
Some tests don't show information in the columns:
Period, Alive Time, Dead Time, Unknown.
The columns Average, Min and Max remain empty too.
(HM did record data in the SQL DB though, which i can view using SQL Management Studio).
Problem 2:
When starting LogAnalyzer from another machine on the network.
All tests display data in column 'period, alive time, dead time, unknown', except, there are some tests, which don't show data in column 'Average, Min, Max).
For example. Alive time = 100%, dead time = 0%, unknown time = 0%
Column Average+Min+Max should/could be filled with data because all the data is logged/stored in the SQL DB, and Alive/dead/unknown is filled here too.
Why won't the column's 'average/min/max' not be filled / calculated ?
It seems this only goes wrong with 'Performance Counter Tests'.
(again: data seems to be stored in SQL correctly)
Hope you can give me an answer.
regards,
Martin
Log Analyzer issue, not displaying all test-information
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Could you provide more information, please?
- What version of HostMonitor do you use?
- What Windows do you use? Service Pack?
- What version of LogAnalyzer do you use?
1. "Reply" value is 0 or empty for all log records for this particular test.
2. "Reply" value contains some characters, that cannot be converted to number.
Could you, please, select data from log table for the particulare test (e.g. Select * from YourTable where TestName = 'some test')? You may use "Microsoft SQL Server management Studio" to query this information.
Regards,
Max
- What version of HostMonitor do you use?
- What Windows do you use? Service Pack?
- What version of LogAnalyzer do you use?
LogAnalyzer requires at least two records in the log for particular test to calculate statistics. Also problem might be caused by different decimal separator symbol, different data format, etc. LogAnalyzer provides a special "Use fixed date&time format" options, located in "Options" -> "Interface" tab.martint wrote:Some tests don't show information in the columns:
Period, Alive Time, Dead Time, Unknown.
Average, Min and Max counters depend on "Reply" value. I see two possible causes:martint wrote:The columns Average, Min and Max remain empty too.
1. "Reply" value is 0 or empty for all log records for this particular test.
2. "Reply" value contains some characters, that cannot be converted to number.
Could you, please, select data from log table for the particulare test (e.g. Select * from YourTable where TestName = 'some test')? You may use "Microsoft SQL Server management Studio" to query this information.
Regards,
Max
SOLVED: Changed country settings to UK (123,456,789.00)
On the server where HM resides (and where LogAnalyzer works good (concerning: PerfCounterTests):
- Windows 2003 R2, SP2
- HostMonitor 7.78
- LogAnalyzer 5.48
On the workstation where the PerfCounterTests show empty 'Average/Min/Max' Columns:
- Windows XP Professional SP3
- RCC 2.78
- LogAnalyzer 5.48
WAN connection with above HM / SQL server
-> LogAnalyzer requires at least two records in the log for particular test to calculate statistics
I've selected one test in SQL. Showed up with 1601 rows, so there are more than two records
LogAnalyzer provides a special "Use fixed date&time format" options, located in "Options" -> "Interface" tab.
I tried both settings. Both don't seem to correct the problem.
SOLVED:
Changing 'Country settings' in Control panel from Dutch (123.456.789,00) to English / UK (123,456,789.00) fixed this issue
Thanks for the info Max.
- Windows 2003 R2, SP2
- HostMonitor 7.78
- LogAnalyzer 5.48
On the workstation where the PerfCounterTests show empty 'Average/Min/Max' Columns:
- Windows XP Professional SP3
- RCC 2.78
- LogAnalyzer 5.48
WAN connection with above HM / SQL server
-> LogAnalyzer requires at least two records in the log for particular test to calculate statistics
I've selected one test in SQL. Showed up with 1601 rows, so there are more than two records
LogAnalyzer provides a special "Use fixed date&time format" options, located in "Options" -> "Interface" tab.
I tried both settings. Both don't seem to correct the problem.
SOLVED:
Changing 'Country settings' in Control panel from Dutch (123.456.789,00) to English / UK (123,456,789.00) fixed this issue
Thanks for the info Max.