Maintanance Templates
How to create a new maintenance template Template Configuration 1. Select a Template Name Choose a unique and meaningful name for the template to ensure easy identification and organization. 2. Choose Template Type Regular Template: Applicable for all MSSQL editions except Express Edition. Rules in regular templates are implemented as MSSQL jobs. Express Template: Designed […]
Restore from Backup
Restore maintenance rule Purpose: To recover a database from a backup. Why It’s Important: Database restore is essential for recovering from data loss, corruption, or system failures. It ensures business continuity by restoring the database to its previous state. Regularly testing restores validates your backup strategy and ensures backups are functional when needed. Restore rule […]
Shrink Maintanance
Shrink maintenance rule Purpose: To reclaim unused space in the database Why It’s Important: Shrinking reduces database file size when there is significant free space (e.g., after deleting large amounts of data). However, caution is required because frequent shrinking can cause fragmentation and performance issues. It is best used after significant cleanup or archiving operations […]
Integrity Maintenance
Integrity maintenance rule Purpose: To detect and report any corruption or inconsistencies in the database. Why It’s Important: Running DBCC CHECKDB helps identify issues with data pages, tables, indexes, and the overall physical structure of the database. Detecting corruption early prevents data loss or operational downtime. Regular integrity checks are critical for ensuring database reliability […]
Update Statistics
Update Statistics maintenance rule Purpose: To refresh metadata used by the SQL Server query optimizer for making execution plan decisions. Why It’s Important: The SQL Server query optimizer relies on statistics (data distribution and cardinality information) to choose the best query execution plan. As data changes over time, statistics become stale or inaccurate, leading to […]
Database Reindex
Reindex maintenance rule Purpose: To rebuild or reorganize indexes for improved query performance. Why It’s Important: Over time, indexes become fragmented due to frequent INSERT, UPDATE, and DELETE Fragmented indexes slow down queries. Reindexing reduces fragmentation, improves data access speed, and optimizes storage. It ensures SQL Server can efficiently use indexes to speed up query […]
Database Backup
Backup maintenance rule Purpose: To ensure that critical data is protected and can be recovered in case of data loss, corruption, hardware failure, or disaster. Why It’s Important: Backups allow you to restore your database to a consistent state after an unexpected issue. Regular backups (full, differential, or transaction log) help achieve Recovery Point Objectives […]
Maintanance Schedule
Scheduling options UI Scheduling Options for Maintenance Rules 1. Familiar Interface: The scheduling options are modeled after the MSSQL Job Scheduler to provide a familiar look and feel for seamless integration. 2. Flexible Scheduling: You can attach one or more schedules to any maintenance rule, enabling precise control over execution. You can do that by […]
Experda Maintenance Overview
How does it work? The Experda Maintenance Plan Generator provides a comprehensive suite of automated maintenance solutions tailored to meet your database management needs. Maintenance actions can be executed directly from the server object tree or scheduled through the maintenance settings for streamlined operations. Within the maintenance settings, it is recommended to utilize maintenance templates […]