v1.0.8.0
Dec 10, 2017Alerting
- 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 cursor information when they are observed to be running.
- Added credential pooled processing to more efficiently collect session information.
- Added command type to notable query collection.
- Added execution count filter to NQ search.
- Added new SQL Logic Hashing. Breaking from the built-in SQL hashing - VPs is now capable of tying all types of collected events to a unified event.
- Added parent-query collection and moved collection point to the parent. Child queries are still collected but without performance metrics.
- Notable query search now allows for direct search of both real-time and historical user sessions.
- Added user name, host name, application name, and object name to all notable query grids.
Statistics
- Added collection of SQL Server Statistics. It is now possible to track data volume changes per-table over time.
Deadlocks
- Added interpretation and collection of SQL Agent Job names.
- Added NQID and its associated alias to deadlock, waiters, owners, and added drill-through links.
Blocks
- Added blocked process lineage snapshots, allows VPS to retroactively display block the evolution of block chains.
- Removed the option to view current or historical blocks. All blocks are collected and displayed in real-time.
- Added NQID and its associated alias to blocks and added drill-through links.
- Added database name and wait-time filtering.
UI Misc.
- Added ability to specify a custom color per computer for the server explorer tabs.
- Added additional drill-through level from the performance snapshot screen, this allowing an initial lightweight drill into the distinct queries and then a drill into the sessions.
- Rearranged many grid columns and added various drill throughs for uniformity.
- Standardized date-time default values to include the remainder of the present day, this is to accommodate the various data points that are now collected in real time.
- Converted all displays of the NQID to include the query alias, allowing users to track custom query names throughout VPS.
Misc.
- Added momentary aggregation worker, this will periodically update the operational data store (ODS) for better UI performance and real-time analytics.
- Added credential pooled processing to more efficiently collect real-time session information.
- Added persistent process recycling which allows for more efficient collection over extended periods of time.
- Added auto-initialization of Admin Tool configuration at install time.
- Added SQL Logic Hash rebuild option to Admin Tool.
- Updated to the latest production version of SMO and related libraries.
- Updated to the latest production version of SQL Reporting libraries.
- Swapped out performance snapshot to use session aggregates from ODS as opposed to real-time aggregations.
Fixes
- Resolved issue with “duplicate key” and “cannot insert null value” when collecting workload observations with multiple execution plans.
- Resolved issues collecting SQL Server database metrics when configured growth rates were greater than 4GB.
- Resolved issue which caused alerts to not become triggered if they contained no conditions.
- Resolved issues which caused SQL Server Agent Job notifications to not be dispatched.
- Resolved issue which would sometimes merged unassociated block headers.
- Resolved Int32 overflow during database size calculation.
- Resolved issue with acknowledging/ignoring alerts from the computer overview screen.
- Resolved issue with manual reports not functioning on some workstations due to a missing reporting component.