|
We have 62 GB ram and 32 bit virsion (os and sql server) how much memory we can allocate to sqlserver?
(comments are locked)
|
|
EDIT I see that there's Windows 2000 and SQL Server 2000 involved. Then you should read this blog, and even more so the links included: http://blogs.msdn.com/b/joaol/archive/2008/02/05/sql-server-2000-64-bits-versus-sql-server-2000-32-bits-memory-management.aspx END EDIT That depends on which version and edition of SQL Server you are running. For SQL Server 2005, there's a post on the Microsoft CSS SQL team blog: http://blogs.msdn.com/b/psssql/archive/2008/04/05/sql-server-2005-memory-limits-and-related-questions.aspx As you can see in that article, it also depends on what Operating System version and edition you are using. You can read further about memory limits for SQL Server 2008 R2 here: http://msdn.microsoft.com/en-us/library/ms178067.aspx So.. I'm sorry to say, but the answer to your question is: It depends :)
(comments are locked)
|
|
It depends on the exact version of Windows and SQL... Assuming you're running SQL Server 2008, then this page lists the minimum, recommended, and maximums available to you. Hi Thomas, We have serves like below
Mar 11 '11 at 02:16 AM
Manikreddy
@Manikreddy - and you have 62GB RAM between them? Is this a virtual server host?
Mar 11 '11 at 02:25 AM
Fatherjack ♦♦
some are stand alone and some are virtual ones
Mar 11 '11 at 03:09 AM
Manikreddy
Per server (virtual or physical) - what's the memory configuration? Windows 2000 handles memory different than Windows Server 2003 and Windows Server 2008. SQL Server 2000 handles memory very different from SQL Server 2005 and SQL Server 2008. The memory limitations differ between Standard Edition and Enterprise Edition.
Mar 11 '11 at 03:39 AM
Magnus Ahlkvist
(comments are locked)
|
Have you just "found" 62GB and want to spread it over your systems, or are they all on one box and want to make sure the allocation is correct?