April 15, 2016 at 11:32 am
We are having a discussion about available RAM on an older server. Server specs are:
OS - Windows 2008 R2 standard, running SQL 2008. The server has 64 GB of RAM,
and SQL 2008 can and does use 32 GB. The production database on this
server is set to compatibility mode SQL 2000 (80) due to vendor coding restrictions.
The question? - How much actual memory can SQL access when running this
production database? 32 GB that SQL 2008 can use, or is RAM limited by what SQL 2000 was created / designed to handle?
April 15, 2016 at 12:40 pm
nelsonj-902869 (4/15/2016)
We are having a discussion about available RAM on an older server. Server specs are:OS - Windows 2008 R2 standard, running SQL 2008. The server has 64 GB of RAM,
and SQL 2008 can and does use 32 GB. The production database on this
server is set to compatibility mode SQL 2000 (80) due to vendor coding restrictions.
The question? - How much actual memory can SQL access when running this
production database? 32 GB that SQL 2008 can use, or is RAM limited by what SQL 2000 was created / designed to handle?
Even though the database is using compatibility mode 80 it is still a SQL Server 2008 R2 database and the server is SQL Server 2008 R2. That means it will use 32 GB of RAM.
April 15, 2016 at 1:04 pm
Thanks for the quick reply Lynn. I was in error, but knew I could rely on the experts here to clear up the question.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply