Skip to content

dbaTDPMon - v2019.7
Compare
Choose a tag to compare
@rentadba rentadba released this 12 Jul 13:32
· 95 commits to master since this release
2019.7
24f6de5

July 2019 new features & fixes

12.07.2019

  • code tested and ready for Azure SQL Database

June 2019 new features & fixes

03.06.2019

  • optimize the calls to msdb system tables when running an internal job queue

07.06.2019

  • health-check: option not to display outdated backups/dbcc for database snapshot(s)

09.06.2019

  • health-check: add stored procedure for reporting database(s) and backup file(s) storage capacity

10.06.2019

  • health-check: add stored procedure for reporting database(s) growth

14.06.2019

  • health-check: enhancements to the daily health-check report: add Capacity Analysis category

17.06.2019

  • maintenance-plan: option to allow/block maintenance operations on a non-readable AlwaysOn secondary replica
  • maintenance-plan: add time limit option for the consistency tasks in maintenance plan
  • health-check: collect secondary replica readable state in [health-check].[statsDatabaseAlwaysOnDetails] table
  • add time limit for executing internal jobs (dbo.usp_jobQueueExecute)

18.06.2019

  • integrations: stored procedure for running dbcc checkdb in a time limit mode / for all databases on all servers
  • fix issue which allowed running more jobs in parallel than the @parallelJobs parameter value

19.06.2019

  • integrations: optimize the dbcc checkdb queue priority to take into account the run time, max dop and previously execution times
  • allow executing a job queue across multiple projects, not project by project

22.06.2019

  • health-check: remove unnecessary calls to sys.dm_os_volume_stats

May 2019 new features & fixes

10.05.2019

  • health-check: add option to limit the reported reclaimable data and log space; default beyond 10 GB

28.05.2019

  • health-check: improve performance for fetching AlwaysOn details data

31.05.2019

  • add SQL Agent job_id information to dbo.jobExecutionQueue table

March 2019 new features & fixes

01.03.2019

  • health-check: add more messages to be filtered out from daily HTML report, errorlog section

05.03.2019

  • health-check: add failed login attempts information on daily HTML report
  • maintenance-plan: add option to trigger a log backup and log shrink (truncate only) after index maintenance

11.03.2019

  • maintenance-plan: remove indexes no longer in use
  • maintenance-plan: add option to wait for estimated recovery time to be 0 before shrink if a database is part of AlwaysOn AG

15.03.2019

  • monitoring: fix "Arithmetic overflow error converting expression to data type int" for transaction status monitoring

18.03.2019

  • maintenance-plan: fix issue on smart differential backup triggering at transaction log backup

29.03.2019

  • health-check: enhance dbo.usp_hcCollectOSEventLogs stored procedure (add @configEventsInLastHours parameter)

February 2019 new features & fixes

12.02.2019

  • health-check: add option to the daily health check report not to filter out databases per assigned project
  • health-check: have database count listed in daily report

January 2019 new features & fixes

09.01.2019

  • maintenance-plan: implement smart differential backup; default threshold at 50% (appConfigurations and stored procedure option)
  • maintenance-plan: force update statistics when the number of changes >= sqrt(1000 * rowcount)

11.01.2019

  • maintenance-plan: do not run maintenance for indexes not used in the last X days (appConfigurations option)

29.01.2019

  • maintenance-plan: fix small bug on redo mechanism for internal foreign key changes
  • maintenance-plan: fix bug on mechanism for detecting heavy fragmented indexes

31.01.2019

  • maintenance-plan: fix small bug when generating internal jobs on systems with rotating database snapshots

December 2018 new features & fixes

10.12.2018

  • monitoring: add support for replication monitoring when distributor is on a remote instance

17.12.2018

  • enhance caching for getting SQL Server version and edition

26.12.2016

  • maintenance-plan: do not allow database backup while shrink is in progress
  • maintenance-plan: do not allow index maintenance operations while shrink is in progress
  • maintenance-plan: add option to create statistics on all table columns, not only on the indexed ones

27.12.2016

  • maintenance-plan: fix defect with internal job scheduler and update statistics task

November 2018 new features & fixes

13.11.2018

  • maintenance-plan: fix a bug when updating statistics with fullscan on SQL Server 2016 onwards
  • remove all SQL Server 2000 related code
Assets 3
Loading