Skip to content

dbaTDPMon - v2017.6
Compare
Choose a tag to compare
@rentadba rentadba released this 31 May 06:06
· 385 commits to master since this release
2017.6
d7e7bca

/----------------------------------------------------------------------/
/* May 2017 new features & fixes
/----------------------------------------------------------------------/
/* 26.05.2017 */
- collect AlwaysOn Availability Groups details when gathering health-check databases info (includes data loss in seconds)
- fix health-check false reporting of outdated backups in AlwaysOn Availability Group configuration

/* 25.05.2017 */
- add MaxDOP option when performing dbcc checkdb/table, default 1 (dbo.usp_mpDatabaseConsistencyCheck) (SQL Server 2014 SP2 onwards)
- fix event message XML formatting bug, when object name constain reserved chars (dbo.vw_logEventMessages)

/* 24.05.2017 */
- add new parameter to dbo.usp_mpJobQueueCreate stored procedure: @skipDatabasesList - comma separated list of the databases to be excluded from maintenance.

/* 18.05.2017 */
- add new parameter to dbo.usp_mpDatabaseOptimize stored procedure: @skipObjectsList - comma separated list of the objects (tables, index name or stats name) to be excluded from maintenance.
- add @recreateMode option when generating parallel maintenance SQL Server agent jobs. Old/custom job definitions may be kept
- add MaxDOP option when rebuilding heap tables, default 1 (dbo.usp_mpAlterTableRebuildHeap)

/* 17.05.2017 */
- perform online table/heap rebuild using WAIT_AT_LOW_PRIORITY (SQL Server 2014 onwards)

/* 16.05.2017 */
- update check/limitations when doing online index rebuild based on version/edition
- starting with SQL Server 2014, when doing online index rebuild, use WAIT_AT_LOW_PRIORITY(MAX_DURATION = [..] MINUTES, ABORT_AFTER_WAIT=SELF) option

/* 09.05.2017 */
- add email alerting flood control: allowing maximum 50 messages (default) in a 5 minutes time-frame

/* 08.05.2017 */
- fix bugs on maintenance-plan module when running on an AlwaysOn configuration with multiple groups (mix primary/secondary) (reported by Stefan Iancu)

/* 04.05.2017 */
- fix database shrink error & alert when another database is in a middle of a restore (reported by Razvan Puscasu)
- fix minor bugs on maintenance-plan module

/----------------------------------------------------------------------/
/* April 2017 new features & fixes
/----------------------------------------------------------------------/
/* 28.04.2017 */
- add support for ignoring error code 15281: SQL Server blocked access to procedure
- fix update statistics error when index name contains brackets (reported by Razvan Puscasu)

/* 19.04.2017 */
- fix "change backup type check" from differential to full when running on AlwaysOn AvaulabilityGroups

/----------------------------------------------------------------------/
/* March 2017 new features & fixes
/----------------------------------------------------------------------/
/* 26.03.2017 */
- allow dbcc checks to be made on secondary replicas / AlwaysOn

Assets 3
Loading