SNMP Informant SQLServer ------------------------ Version 1.5 ----------- * Fixed a bug where the SNMP Service would hang while uninstalling the SNMP Informant agent or stopping the Microsoft SNMP service. * Various internal improvements (e.g., upgraded compiler, debugging enhancements, code structure improvements, etc). Version 1.4.2 ------------- * Fixed a bug that caused the agent to crash if an OID wasn’t queried within six hours. * Added support to identify the SNMP configuration through Group Policies. Modified the installer not to display warnings if installing in silent mode. Version 1.4.1 ------------- * Fixed a bug introduced in Version 1.4 where the following MIB branches would not return a value: sqlServerBrokerStatistics sqlServerBufferManager sqlServerCursorManagerTotal sqlServerGeneralStatistics sqlServerLatches sqlServerMemoryManager sqlServerSQLStatistics * Fixed a minor bug in the installer were the user could not specify the serial number on the command line in an unattended installation unless an INF file was specified. Now the user can perform an unattended installation without an INF file. Version 1.4 ----------- * Added the registry key "EventFilterMask" which allows you to filter messages going to the event log. The EventFilterMask uses the following bits to enable/disable error messages going to the event log: EVENTLOG_ERROR_TYPE 0x0001 EVENTLOG_WARNING_TYPE 0x0002 EVENTLOG_INFORMATION_TYPE 0x0004 The default value is 7, which means log all message types to the event log. Setting the registry to a value of 3 (EVENTLOG_ERROR_TYPE | EVENTLOG_WARNING_TYPE), for example, means log error and warning message types to the event log but don't log informational message types. * The "Show Version" now displays the latest version available (if there is internet connectivity) in addition to the version currently installed. * The agent will now return the same value if the exact same query is performed within 5 seconds (registry definable) for performance counters that require two or more samples. There are two reasons for this change. First, since SNMP uses unreliable UDP the response may be lost. The SNMP Manager would send the same request again resulting in a value returned of the last few seconds rather than the desired interval. Second, queries may take longer than the timeout period configured by the manager station. The manager would then retransmit the query resulting in a false value returned in this case also. The MinimumQueryRate registry key controls the minimum interval the exact same query is received before recalculating a new value. * Modified the installer to perform a proper cleanup of the registry during an uninstall. * The installer now displays an error if the user attempts to install using an outdated evaluation serial key or the serial key is more than a year older than the version he is installing on. * Added support for Windows XP, Windows 2003, and SQL Server 2005 on x64 and ia64. However SNMP Informant does not support WOW (e.g., we cannot monitor an x86 of SQL Server 2005 on Windows 2003 x64) due to cross DLLs within the same application. * The agent now supports queries where there are a large number of counters that require two or more samples. Prior, the agent would remove old queries if there are more than 300 in its cache. For example, if the user was walking across over 100 processes each with 3 types of counters that require more than one sample, a value of 0 would be returned the second time through. This limitation no longer exists. * Fixed a bug in agent to look for addition instances of SQL Server during initialization. Prior the agent would fail to initialize if the first instance was not running at the start up of the agent. * Replaced the Readme text document with a consolidated formatted PDF document. Version 1.3 ------------- * Windows Event Message reporting was added (much like the WMI agents). If an error occurs during initialization or if GENERR is returned from a query, the a message is posted to the Windows Event log describing the problem. * Added serial number to installer for license validation. * Added additional checks to the installer to make sure that the Microsoft Windows SNMP service is configured correctly. * Optimized SNMP GETNEXT/WALK retrievals so that they are much faster and use less CPU. * Added XML and XSD files containing the numeric and symbolic OIDs, the SNMP syntax, the SNMP index, and the description for each SNMP row. Thus, the user can use their favorite XML transformation application to translate this SNMP data to their favorite format. * Modified GETNEXT/WALK retrievals so that it returns valid data for performance counters that require more than one sample (e.g., % Processor usage). Now there is no difference in how data is returned between SNMP GET and SNMP GETNEXT/WALK type queries. Version 1.2.1 ------------- * Fixed a bug where the agent would not identify the SQL Server Name Instances on non-english OS. Version 1.2 ------------- * Modified code to support multiple installed name instances of SQL Server. * Modified the INFORMANT-SQLSERVER.MIB files to support multiple installed name instances. * Added new performance counters in SQL Server 2006 (express edition). Notes: You must restart the computer after installing SQL Server before the performance counters for that name instance becomes available. Version 1.1.1 ------------- * Fixed a bug where performance object instances were not being updated after the SNMP service was started. Version 1.1 ----------- * Changed the data syntax from Integer32 to Gauge32 to support 32 bit unsigned values. * Fixed a bug in SNMP GETNEXT calls for a previous counter within 5 seconds. * Informant now supports non-english operating system. Instance names are now in UTF-8 format. * Increased the size of the instance name from 32 characters to 64 characters. Version 1.0 ----------- * Initial Release