VPS Changelog

General Changes for Minor Release Added advanced object tests during initial configuration.

Installer Added switches to allow skipping SQL admin checking. This is useful when no objects need to be created that require admin rights. Pass /nosqladmin to the installer executable. Added security support for installing using a UPN. Dropped multi-server scale-out installation from mainstream distribution – available upon request for larger installations. Added feature which will…

Added WMI encryption, which defaults to enabled. Replaced threading model for more efficient and secure utilization of security tokens. Added full Windows fail-over cluster awareness. Added full SQL Server fail-over cluster awareness. Added full VMWare ESXi vSphere integration Datacenters, hosts and VMWare clusters are automatically added to monitoring. VMs and Virtual Disks are automatically added…

Features Added explicit support for Windows Workgroups (non-active directory installations). Added ability to modify entity attributes via UI. Added default date to real-time query drill through. Added SQL-authentication support for meta-base database in monolithic installer. Issues Added service termination upon invalid configuration. This is to ensure that a faulty start doesn’t appear to function correctly.…

SQL Server Database Collection Added option to ignore read-only databases. Added attribute to allow for ignoring individual databases on a per instance level. SQL Server Sessions Added new plan explorer to breakdown each statement of an observed batch. Fixes Resolved issue that caused VPS to not collect some metrics when a database permission is lacking.…

Installer Reworked certificate generation methods. Physical Disk Collections Added trilevel checks for HDD health to allow alerts to reliably detect failing physical disk drives. UI Misc. Altered the way in which the last selected Server/SQL Instance maintained from one dashboard to the next. Real-Time Dashboard. Changed disk performance metrics. Now displays bytes instead of IOPS.…

Alerting Added occurrence date to the available deadlock alert fields. Added date-time formatting for all alerts. This allows VPS to use dates/times in alert identifiers and conditions. Removed SQL Server Blocks alert category, it was made redundant with this update. (All block alerting is still available). SQL Server Query Observations Added the collection of additional…

Blocked Processes Added cached collection and interpretation of SQL Server Agent job names. Notable Query Added default Query checksum for binary zero hashes. This will prevent the grouping of queries which are not alike such as ROW FETCH operations. Added advanced option [Use Actuals when Deltas Are Unavailable] which allows for collection of single run…

Alerts Reworked Alert Field Identifiers so that they are included in real-time emails (in addition to UI). Added configurable “Days to Observe Average Utilization for Alerts” to allow for custom alerting threshold. SQL Notable Queries Added “cumulative notable query” collection in addition to “per-execution notable query” collection. Added fallback to “original login name” when current…

SQL Notable Queries Added alert conditions to notify when a completed query used n-percent more of a given resource than the 7-day average Added collection of Object Name for each notable query plan. Added search by Object Name functionality. This is a LIKE operation with both a leading and trailing wildcard. Removed Host, Application and…