Memory usage by server..

We have 62 GB ram and 32 bit virsion (os and sql server) how much memory we can allocate to sqlserver?

more ▼

asked Mar 11, 2011 at 02:11 AM in Default

avatar image

414 25 26 31

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?

Mar 11, 2011 at 03:13 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first


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


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 :)

more ▼

answered Mar 11, 2011 at 02:19 AM

avatar image

Magnus Ahlkvist
21.2k 19 39 42

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 11, 2011 at 02:13 AM

avatar image

ThomasRushton ♦♦
40k 20 49 52

Hi Thomas, We have serves like below
WINDOWS SERVER 2000 with sql2000
WINDOWS SERVER 2000 wiht sql 2005
windows 2003 with sql 2000
windows 2003 with sql 2005

Mar 11, 2011 at 02:16 AM Manikreddy

@Manikreddy - and you have 62GB RAM between them? Is this a virtual server host?

Mar 11, 2011 at 02:25 AM Fatherjack ♦♦

some are stand alone and some are virtual ones

Mar 11, 2011 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, 2011 at 03:39 AM Magnus Ahlkvist
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 11, 2011 at 02:11 AM

Seen: 1303 times

Last Updated: Mar 11, 2011 at 02:13 AM

Copyright 2016 Redgate Software. Privacy Policy