July 18, 2006 at 3:12 pm
I am setting up SQL Server 2000 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 3:33 pm
Max Server Memory is an instace level setting. You could accomplish what you want by installing a second instance of SQL Server. Run the production database on one instance and the test/training on another. You can then set the Max Server Memory settings accordingly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply