Tuning Tips

The following tuning tips may help improve the performance of your database in an Iguana environment.

Setting up a Database Maintenance Plan for MS SQL

If you are using an MS SQL database, a Database Maintenance Plan is recommended. This will ensure that your database is safe and properly maintained. The following resources provide more information on creating a Database Maintenance Plan:

• Creating a SQL Server Maintenance Plan
• A video can be found here: Creating a Maintenance Plan in SSMS (free registration required)

Installing MS SQL on a Separate Partition

If you are using MS SQL, you should not install your database on the system. A better solution is to install your database on a separate partition with a large amount of available disk space. This will ensure that there will be enough space to store your database tables as they grow.