Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Memory question

Author  Topic 

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2009-01-14 : 17:32:56
Pardon me if I'm posting this in the wrong forum.

If I've a SQL Server 2005 with a couple of DBs of size 2TB, what is the optimal memory that should be assigned to this server?
How much memory will be assigned to the OS?
Has the memory got to do anything with 32-bit and 64-bit?

Thanks,
Sunny.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-14 : 17:36:00
Buy as much memory as you can afford, minimum 64GB or perhaps 128GB.

I'd highly recommend 64-bit.

The OS doesn't need much if it's a dedicated database server, typically just 1.5-2GB.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-14 : 20:17:46
With 64 bit, you can get system max memory for SQL Server.
Go to Top of Page
   

- Advertisement -