July 18, 2006 at 11:53 am
I am setting up SQL Server Enterprise Edition on a new Windows 2003 Enterprise Edition server. The server has 18 GB RAM and 4 - 2.2GHz dual –core processors. The PAE is set in the boot.ini file. I will have 2 databases residing on the server, one production and one for testing/training. I want to allocate as much memory as I can to the production database, but still have some for the test database. Is max server memory set per database? I would like to allocate more to production. Is this possible? Any recommendations? thanks
July 18, 2006 at 8:16 pm
You aren't able to allocate memory to individual databases. Memory allocation is at the instance level. You are, however, able to allocate memory to individual instances if you run multiple instances.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply