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.