Previous Topic: Physical Tuning Parameters

Next Topic: Database Placement

Hardware Configurations

Consider implementing the mart for CA ERwin Data Modeler Workgroup Edition on a multiprocessor system, especially if multiple data modelers are saving information simultaneously. Install the software on a stand-alone Microsoft SQL Server, if possible, or on a development computer. The database overhead noticeably affects other databases running on the same system during save and load operations. If few modelers save and load simultaneously, the overhead is less.

To improve caching performance, implement the mart on servers that have at least 512 MB of RAM.