Memory Concerns

kthompson · Post by **kthompson** » Tue Jun 21, 2005 8:30 am

Hello,

We are experiencing a problem with the database server that is storing the vault db. The SQL Server instance is using a great deal of memory, 800 MB and up. This problem shows up from within the first 30 seconds of restarting the server till we shut it down. Is this typical behavior?

We are running Vault 3.0.7.

Any comments/suggestions would be greatly appreciated.

Thank you,
Keith

Post by **jclausius** » Tue Jun 21, 2005 9:07 am

SQL Server will cache results in order to improve performance. As more and more repositories are accessed, SQL Server will cache tables/rows for performance reasons.

How much available memory is in the SQL Server? What else is running on the SQL Server? Is the memory consumption a problem?

By default, this amount is self tuning based on the systems memory. If you feel it is using too much, the value can be changed within SQL Server.