If you run multiple databases on the same SQL Server, are they all fighting for the Procedure Cache? I'm trying to figure out how SQL Server determines how long to hold a procedure cache? If other databases consume memory, will this affect the procedure cache for this database on the same server?
I find that on some bootstraps the pages in our application are slow, but as soon as requests are cached, obviously fast. I'm just not sure how long SQL Server has stored the procedure cache, and if other databases will affect this amount of time.
source
share