Skip to content

dbaTDPMon - v2019.12

Compare
Choose a tag to compare
@rentadba rentadba released this 10 Dec 17:44
· 59 commits to master since this release

December 2019 new features & fixes

03.12.2019

  • project removal when removing the last instance assigned
  • health-check: collect also internal job execution history from "monitored" instances (dbo.jobExecutionHistory)

05.12.2019

  • add check for SQL Agent service before starting executing jobs in parallel mode

10.12.2019

  • add code for detecting databases not managed by dbaTDPMon utility

November 2019 new features & fixes

03.11.2019

  • monitoring: fix small bug when detecting active/running sessions
  • maintenance-plan: fix small bugs when displaying messages during maintenance run time
  • health-check: add option to run the daily report for a single instance
  • health-check: add database(s) growth information for the last X days to the daily report

05.11.2019

  • health-check: add database(s) backup size information for the last X days to the daily report

14.11.2019

  • fix small performance issue on saving internal job execution statistics

29.11.2019

  • maintenance-plan: do not create jobs for databases on an AlwaysOn Availability Group Non-Readable Secondary Replica setup if denied by dbo.appConfigurations

October 2019 new features & fixes

07.10.2019

  • improved performance for internal log messaging by running some heavy queries only if an email must be sent
  • maintenance-plan: fix issue when calling maintenance code for objects having . (dot) in their name (reported by George Talaba)

13.10.2019

  • monitoring: improved performance for transaction status; include the actual SQL code in the collected data / alerts sent
  • option to add/remove databases from a project using name filters

22.10.2019

  • health-check: incremental read for errorlog files (read only new events)

September 2019 new features & fixes

07.09.2019

  • add support for Azure SQL Managed Instances
  • clean update scripts: allow only update from v2019.7 onwards

19.09.2019

  • maintenance-plan: fix small bugs when running backup against Azure MI

29.09.2019

  • maintenance-plan: add code for data copy between database / tables (dbo.usp_mpTableDataSynchronizeInsert). Add support for on-premise to Azure data copy

August 2019 new features & fixes

20.08.2019

  • health-check: fix issue when computing growth for databases in AG and switching nodes

July 2019 new features & fixes

27.09.2019

  • monitoring: enhance performance for failed jobs detection (dbo.usp_monGetSQLAgentFailedJobs)