Memory and storage limits depend on the amount of RAM on your server and the disk storage resources available to the DBMS providing database storage services.
You can fine-tune repository engine performance by following the performance hints provided in this documentation. For more information, see Optimizing Repository Performance.
Microsoft® SQL Server™ 2000 Meta Data Services uses storage provided by a DBMS. SQL Server 2000 imposes no practical limit on database size. If you are using msdb, or if you are creating a new repository using SQL Server 2000, you can configure database size when you require more storage.
Memory Limits at Run Time
The repository engine works with available RAM to process transactions and instantiate model information. The more RAM you have available, the better the repository engine performs.