Skip to content

Releases: datafly/SSMSInfoReports

v9.2.0

18 Mar 18:05
7fbf028
Compare
Choose a tag to compare

Bug corrections and improvements.
Also, a new Query Store report is added : run it from Database Report, or Server Performance Report (Query Store section) or directly from the database in SSMS (of course works only for Query Store enabled databases).

v8.0.0

31 Oct 17:18
d8d869f
Compare
Choose a tag to compare
v8.0.0 Pre-release
Pre-release

v8.0 : reports added (Server Security, Database Security), improvements for all reports

v7.0.0

31 Oct 17:21
d8d869f
Compare
Choose a tag to compare
v7.0.0 Pre-release
Pre-release

Reports added (AlwaysOn, Jobs planning history), improvements for all reports

v9.0.0

31 Oct 16:15
2bf8d96
Compare
Choose a tag to compare

Many improvements in this release. In addition to various display and queries improvements, here are the main ones.
Note that reports are no more compatible with SQL Server 2005.

Main Server Dashboard

  • Improved disk/volumes list: it uses xp_cmdshell and wmic rather than Ole automation procedures. Now displays volume names and mounting points.
  • Improved Errorlog's Parsing: does not treat too large log files.
  • Improved jobs display and call of subreport: display the job categories and call the subreport filtered on the category selected.

Server report

  • Display correctly SQL Server 2022 version
  • Display protocols and ports (if the version allows)
  • Display Instant File Initialization (if the version allows)
  • Display lock pages in Memory
  • Integrity: display suspect pages and Memory Dumps

All Databases Report

  • Complete redesign of the Backups list
  • New sorting options

Database Report

  • Displays the Database Scoped Configurations (if existing)
  • Display improvements

Index Report

  • Display also missing Indexes for selected tables/indexes (when there are)

Performance Report

  • Display Query Store activated databases
  • No longer include the graphics of resources by base (long to display), which are now reported to a separate report called from a button.
  • New call button for the new "Lock-Deadlocks" report (if the version allows)

New "Lock-Deadlocks" report

  • Detailed display of the latest lock waits (> 30 s) and latest deadlocks from system_health xevent session.
  • This report is not compatible with SQL Server 2008/R2.