VPS

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.…

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…

SQL Notable Queries Added collection and recording of real-time SQL Server workloads, known as Notable Observations. Added drill through into Notable Observations. Performance Snapshot Added descriptions and remediation information to Wait Type chart. Added drill through into wait times of Notable Observations. Auditing Implemented nightly aggregation of audit metrics for web dashboards. Real-time SQL Activity…

SQL Notable Queries Renamed context menu selection “Performance Details” to “Performance History”. Added double-click drill-through to indexes, performance history, and query text. Added single click drill-through to indexes, plans and query execution history. Added query cost to execution history screen. Miscellaneous numeric formatting. Added nightly NQID aggregations for future added UI intelligence. Performance Snapshot Dashboard…