Skip to main content

Scheduled SQL Maintenance Plans

  1. Last updated
  2. Save as PDF

Overview

Use preexisting SQL Server maintenance plans instead of creating your own.

Details

Instead of reinventing the wheel and creating your own maintenance plans, go to https://ola.hallengren.com for the SQL Server Maintenance Solution.

Here, you will find prewritten SQL Scripts that can be used to maintain your SQL server. It’s always good to properly manage your database and keep your database performing at an optimal level and take care of routine tasks on the database. A good maintenance plan can optimize database performance if planned correctly, implemented successfully, and managed appropriately and properly.

Start by downloading a maintenance script (MaintenanceSolution.sql) that will create all of the objects and jobs that your organization needs. This will save time and make things easier, instead of creating the jobs yourself.

The SQL Server Maintenance Solution includes:

  • DatabaseBackup - A good, working backup is essential in order to recover from most disasters. However, a backup will also help protect you against database upgrades that go bad, as well as table corruption and other system problems.
  • DatabaseIntegrityCheck - This procedure checks the allocation and structural integrity of user and system tables, and indexes in the database.
  • IndexOptimize - Indexes improve the speed of data retrieval operations on a database table by providing rapid random lookups and efficient access of ordered records.

We realize not every organization has the staff to support and set up an SQL Maintenance Plan. For this reason Netsmart offers database hosting. For further details on hosting your TIER applications and database with Netsmart, please contact your Client Alignment Representative.