Authentication changed from AD to forms auth.
This allows for a more integrated web interface in coming releases and for
current compliance web interface.
All communication has been ported to SSL as
opposed to plain HTTP.
MSMQ is now a required server component, this is
in support of real-time monitoring with the next release.
SQL Execution Plans
Captures execution plan information regarding
the level of optimization and the outcome of the optimization phase. For
instance, it is now possible to differentiate between queries that have
over-complicated execution plans which cause optimization timeouts, trivial
queries, and even track execution plan cache hits/misses per query.
Additional captured plan attributes: Count of
batches in the plan, count of statements, plan size, compile time, compile CPU
cycles and compile memory.
File Auditing
Capture and alert on events regarding creation,
deletion and modification to file system objects (files).
Schema Auditing
Capture and alert on events regarding creation,
deletion and modification to database schema.
Active Directory Auditing
Capture an alert on any changes made to AD users
and groups.
SQL Security Auditing
Capture and alert on events regarding creation,
deletion and modification to of database users and any change in permissions on
any level.
Alerting
Added right-click copy functionality to quickly
reproduce an alert.
SQL Server Instance Performance
Added new metrics to pivot charts and
re-organized folders/groups.
Buffer Manager
Background writer pages/sec
Checkpoint pages/sec
Free list stalls/sec
Lazy writes/sec
Page lookups/sec
Page reads/sec
Page writes/sec
Readahead pages/sec
General Statistics
Connection Reset/sec
Logins/sec
Logouts/sec
Latches
Latch Waits/sec
SuperLatch Demotions/sec
SuperLatch Promotions/sec
Locks
Lock Requests/sec
Lock Timeouts (Timout>0)/sec
Lock Timeouts/sec
Lock Waits/sec
Number of Deadlocks/sec
SQL Statistics
Auto Param Attempts/sec
Batch Requests/sec
Failed Auto Params/sec
Forced Parameterizations/sec
Guided plan executions/sec
Misguided plan executions/sec
Safe Auto Params/sec
SQL Compilations/sec
SQL Re Compilations/sec
Unsafe Auto Params/sec
Disk Performance
Fields added to pivot charts and alerting.
Seconds per read, seconds per write, and seconds
per Transfer (read + writes).
Percent utilized time (total), utilized for
reads and utilized for writes.
Split IO per second (indicates large IO
operations and fragmentation).
Windows Process Monitoring
Processes can now be tagged for unconditional
collection
Not yet implemented by the GUI.
VMWare Host Monitoring
VMWare host CPU and Memory metrics are now
automatically collected.
Additional Reports
SQL Server Daily I/O Latency
Current Memory Utilization by Server
System Downtime
SQL Server User Modifications
Active Directory Account State
Active Directory Account History
SQL Server Database File Latency by Server
SQL Server Database Data File Size by Server
Disk Space Size by Server
Disk Space Used by Server
Disk Space Free by Server
SQL Server Database Average Daily IOPS by Server
SQL Server Hourly Page Life Expectancy
GUI Changes
Alert grid on computer overview now contains the
last occurrence date of the alert.
Additional disk performance metrics on Disk
Performance pivot chart.
Ability to filter notable queries on their
duration.
Notable query grids now display the average
metrics per execution.
Added additional dashboards for SQL, Disk,
Virtuals, Health and Capacity.
Misc. Changes
Moved SQL backup auditing out into its own scan
interval so that it can be scheduled independently. This is to resolve frequent
collection times for customers who retain large backup histories.
Implemented cache invalidation so that computer,
alert, user, etc. changes take effect immediately.
Added “ignore query” functionality. Still absent
from GUI.
Removed “Buffer Node” SQL metrics as they were
not being properly supported by the VPS engine.
Bug Fixes
Resolved bug which formatted dashboard values
multiple times thereby converting TB to GB.
