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.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |