- QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats.
- Performance Dashboard server report now available as a default report:
- Can connect to SQL Server 2008 and newer versions.
- Missing indexes sub-report uses scoring to assist in identifying most useful indexes.
- Historical wait stats sub-report now aggregates waits by category. Idle and sleep waits filtered out by default.
- New Historical latches sub-report.
Plus…
- General improvements around support for SQL Server on Linux:
- Database Mail node is back
- Addressed some issues related to paths
- Activity Monitor stability improvements
- Connection Properties dialog displays the correct platform
Download SSMS 17.2 now!
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Enjoy,
Hiram
