Optimizing the Databases


As of Dundas BI Version 4.0, the task of rebuilding indexes is built into the application and this article is no longer applicable.

1. Overview

The Dundas BI Application Database and Warehouse Database are SQL Server databases and critical to the operation of Dundas BI. Over time, the indexes in these databases may become fragmented, and degrade performance.

To avoid index fragmentation, we strongly recommended that you rebuild the indexes periodically. You can set up a scheduled task using SQL Server Management Studio, or do this on demand following the instructions on the Microsoft Developer Network.

2. Setting up a Rebuild Index Task

You can use the Maintenance Plan Wizard in SQL Server Management Studio to set up a scheduled task for rebuilding indexes.

For example, launch SQL Server Management Studio.

Expand your SQL Server instance and the Management folder. Right-click on Maintenance Plans and select Maintenance Plan Wizard.

Launch the Maintenance Plan Wizard
Launch the Maintenance Plan Wizard

In the Select Plan Properties step, you can choose to schedule the task periodically or leave the schedule as On Demand.

Set up a periodic schedule
Set up a periodic schedule

In the Select Maintenance Tasks step, select the Rebuild Index option.

Rebuild Index task
Rebuild Index task

The remaining steps allow you to choose the databases for the index rebuild. Make sure your Dundas BI Application Database and Dundas BI Warehouse are selected. They are named Dundas BI Instance1 and Dundas BI Instance1 Warehouse by default.

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri