{"repo":"rentadba/dbaTDPMon","free":true,"listed":false,"github":"https://github.com/rentadba/dbaTDPMon","clone":"git clone https://github.com/rentadba/dbaTDPMon.git","description":"dbaTDPMon - Troubleshoot Database Performance and Monitoring","language":"TSQL","stars":21,"topics":["sql-server","sql","sqlserver","maintenance","backup","indexing","consistency-checking","health-check","reindex","always-on"],"license":"MIT","category":"databases-storage","readme_excerpt":"dbaTDPMon - Troubleshoot Database Performance and Monitoring This utility is a bespoke database / system maintenance, health-check and monitoring solution for SQL Server. It runs for versions from SQL Server 2000 until 2022 plus Azure SQL Database and Managed Instances. Some features are only available for SQL Server 2005 and beyond. Utility consists in plain T-SQL code. A database is needed in order to store objects used by this utility. Task automation is performed using SQL Agent jobs, pre-scheduled. Maintenance-plan, health-check and monitoring modules can be used as “agentless” management system. Why dbaTDPMon? implement database maintenance best practices (including system databases) parallel database(s) maintenance (multiple databases at once) automate daily health checks / HTML reporting can be used to administrate multiple instances from a central point fully customization / various options / time limit / email alerting check full documentation for all details Custom Maintenance Plan Backup use checksum (+2k5) and verify the backup file retention can be set to days or backup file count automatically trigger a full database backup prior taking a transaction log / differential backup, if needed Consistency Checks can be run at database or table level checks are \"split\" over an entire week (configurable) Index Maintenance reorganize/rebuild decision can be based on logical fragmentation or page density use \"drive table\" to limit the number of analyzed indexes 2 algorith","default_branch":null,"files":null,"tree":[],"storefront":"/r/rentadba","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rentadba/dbaTDPMon/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}