Server-Level Tuning Parameters

You should perform the following server-level tuning tasks:

Configure Microsoft SQL Server to use as much memory as possible. Allocating more memory to the Microsoft SQL Server caching mechanisms means less physical reads from the disk and improved database query performance.
Allow several megabytes of disk space for the procedure cache because CA ERwin Data Modeler Workgroup Edition uses many stored procedures.

The following table shows the recommended configuration parameters for a Microsoft SQL Server running CA ERwin Data Modeler Workgroup Edition:

Parameter Type	Recommended Value	Notes
memory (Sybase 15: "total memory")	512 MB minimum Note: 1 GB is recommended	More memory implies less physical I/O
procedural cache	Set the cache to grow to a fixed size, such as 50 MB or 100 MB.	CA ERwin Data Modeler Workgroup Edition is stored procedure-intensive

Parameter Type

Recommended Value

Notes

memory (Sybase 15: "total memory")

512 MB minimum

Note: 1 GB is recommended

More memory implies less physical I/O

procedural cache

Set the cache to grow to a fixed size, such as 50 MB or 100 MB.

CA ERwin Data Modeler Workgroup Edition is stored procedure-intensive