This project has moved and is read-only. For the latest updates, please go here.

dbaTDPMon - v2015.9

Rating: No reviews yet
Downloads: 36
Released: Aug 27, 2015
Updated: Aug 27, 2015 by danandreistefan
Dev status: Stable Help Icon

Recommended Download

Application dbaTDPMon-v2015_9.zip
application, 638K, uploaded Aug 27, 2015 - 36 downloads

Release Notes

-- =======================================================================
-- Copyright (c) 2004-2015 Dan Andrei STEFAN (danandrei.stefan@gmail.com)
-- =======================================================================
-- Author : Andrei STEFAN
-- Module : dbaTDPMon (Troubleshoot Database Performance / Monitoring)
-- Description : SQL Server 2000/2005/2008/2008R2/2012+ maintenance, checks and monitoring
-- =======================================================================
/----------------------------------------------------------------------/
/* August 2015 new features & fixes
/----------------------------------------------------------------------/
/* 03.08.2015 */
- change default algorithm for index rebuild to online mode (alternative will be the "space efficient" one)

/* 04.08.2015 */
- check forwarded records percentage and page density in order to decide whenever to rebuild a heap (http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/06/how-often-do-you-rebuild-your-heaps.aspx)
- check page density in order to decide whenever to reorganize/rebuild an index
- add time limit option for the optimization task in maintenance plan
- version 2015.8 released

/* 05.08.2015 */
- fix a bug on backup files cleanup algorithm when running for a remote server

/* 06.08.2015 */
- add upper limit for page count for rebuilding indexes (@RebuildIndexPageCountLimit) - very large tables will only be REORGANIZED
- may use to implement staggered index maintenance (http://sqlmag.com/blog/efficient-index-maintenance-using-database-mirroring)

/* 07.08.2015 */
- auto-complete value for option "Default backup location" at install time with current instance default backup directory

/* 14.08.2015 */
- add fill_factor to the index details xml schema information
- fix small bug when running backup cleanup on SQL Server 2000 instances

/* 17.08.2015 */
- documentation reviewed / corrections made (thank you Dragos Esanu)
- add health-check rule for detecting frequently fragmented indexes / for which lowering the fill-factor may prevent fragmentation

/* 18.08.2015 */
- when rebuild an index online, check the SQL Server version and reset MAXDOP to 1 (automatic check and fix for KB2969896)

/* 19.08.2015 */
- create simple batches in order to automate maintenance plan when running as agent on SQL Express edition
- when running DBCC CHECKDB, DATAPURITY option will be used only when dbidbccFlags <> 2 (SQL Server 2005 onwards)
- fix small bug on database backup, getting state while database was restoring
- add stored procedure to automatically lower the fill-factor / rebuild all detected frequently fragmented indexes (customizable) dbo.usp_hcChangeFillFactorForIndexesFrequentlyFragmented

/* 20.08.2015 */
- fix small bugs on checking database state before performing maintenance plan
- get start date and time information for jobs currently running, in health-check module

/* 24.08.2015 */
- add health-check rule for detecting long running SQL Agent jobs (default more than 3 hours)
- fix small bugs when running setup on SQL Server 2000

/* 25.08.2015 */
- gather running time when collecting SQL Agent job information

/* 27.08.2015 */
- fixed small bugs on health-check HTML report
- version 2015.9 released

Reviews for this release

No reviews yet for this release.