Skip to content

dbaTDPMon - v2018.11
Compare
Choose a tag to compare
@rentadba rentadba released this 01 Nov 15:02
· 150 commits to master since this release
2018.11
05efd9f

November 2018 new features & fixes

01.11.2018

  • discontinued support for SQL Server 2000 (latest version supporting SQL Server 2000 is 2017.12)
  • health-check: fixed small bugs when running on SQL Server 2008

October 2018 new features & fixes

10.10.2018

  • allow definition of more than 32k internal jobs in jobExecutionQueue table (smallint to int change)

17.10.2018

  • reduce CPU usage for the dbo.usp_sqlAgentJobCheckStatus stored procedure

24.10.2018

  • fix a small bug while getting the host domain name

27.10.2018

  • health-check: use powershell to get the volume disk space as 1st option; use volume_stats as 2nd

30.10.2018

  • implement caching for getting SQL Server version and edition
  • health-check: add default 367 days retention for historical and log tables
  • maintenance-plan: avoid a deadlock scenario when performing system databases maintenance
  • maintenance-plan: reduce the number of calls to AlwaysOn / cluster related dvms

31.10.2018

  • implement caching for getting database properties information
  • maintenance-plan: allow index fragmentation analysis for read_only databases

September 2018 new features & fixes

17.09.2018

  • monitoring: fix defect - analyzing replication status for an offline database

22.09.2018

  • maintenance-plan: skip read-only databases from index, statistics or heap maintenance
  • maintenance-plan: skip backups on database snapshots as they are not allowed

27.09.2018

  • health-check: fix small issue on daily HTML report data layout
  • for internal jobs, save database_name in dbo.jobExecutionHistory

August 2018 new features & fixes

15.08.2018

  • maintenance-plan: fix defect when triggering full database backup after an Availability Group fail-over
  • maintenance-plan: fix error 976 when performing backups or consistency checks against a non-readable secondary database

18.08.2018

  • maintenance-plan: add active column/flag to the objectSkipList table

20.08.2018

  • health-check: enhance the Availability Group databases information collector

21.08.2018

  • maintenance-plan: improve performance for [dbo].[usp_mpCheckAvailabilityGroupLimitations] stored procedure; less calls to system dmvs

28.08.2018

  • maintenance-plan: mark Allocation Consistency Checks (DBCC CHECKCATALOG / DBCC CHECKALLOC) as heavy operation to lower the pressure when running in parallel

July 2018 new features & fixes

03.07.2018

  • health-check: save volume/disk mount point for data/log file physical location (SQL Server 2008 onwards)
  • add is_resource_intensive flag for appInternalTasks

06.07.2018

  • maintenance-plan: fix deadlock on concurrent projects defining their internal queues

09.07.2018

  • fix defect related to duplicate jobs entries in jobExecutionQueue table
  • when refreshing projects data, add only databases not allocated to other projects

10.07.2018

  • fix XML parsing error when maximum jobs limit alert is triggered

11.07.2018

  • health-check: fix disk space details table formatting in the HTML report
  • monitoring: auto-detect project code when sending alert emails

16.07.2018

  • add new option for job execution: Maximum SQL Agent jobs running on the same physical volume (0=unlimited)

June 2018 new features & fixes

05.06.2018

  • add dbo.vw_jobSchedulerDetails view with details on SQL Agent jobs scheduler definition for dbaTDPMon jobs

07.06.2018

  • maintenance-plan: fix clusterName path when running backup for a databases not in an AG but on a AlwaysOn setup
  • removed obsolete objects from install & update utility

11.06.2018

  • monitoring: add option for Transaction Status to exclude alerts based on login_name (monitoring.alertSkipRules skip_value2 column)

13.06.2018

  • health-check: fix small defects on health-check report generation for projects having multiple instances
  • maintenance-plan: add priority for internal maintenance tasks jobs

13.06.2018

  • implemented a workaround for internal jobs left in "in progress" state

20.06.2018

  • health-check: convert local time for OS events, errorlog messages and SQL Agent jobs to UTC
  • health-check: if possible, the last X hours in health-check report will be filtered on the UTC columns
  • add new option for job execution: Maximum job queue execution time (hours) (0=unlimited)

28.06.2018

  • send custom alert when the number of concurrent running internal jobs reached the limit set
  • maintenance-plan: fix deadlock on concurrent projects defining their internal queues

May 2018 new features & fixes

30.05.2018

  • replace EXEC() with EXEC sp_executesql to reduce the CPU usage for the dbaTDPMon utility

31.05.2018

  • maintenance-plan: in an AlwaysOn Availability Group environment, save the database backups in ClusterName folder
Assets 3
Loading