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

Manikreddy gravatar image

414 24 26 28

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][3]

So.. I'm sorry to say, but the answer to your question is: It depends :)

[3]: http://msdn.microsoft.com/en-us/library/ms178067.aspx
more ▼

answered Mar 11, 2011 at 02:19 AM

Magnus Ahlkvist gravatar image

Magnus Ahlkvist
16.6k 17 20 33

(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][1] lists the minimum, recommended, and maximums available to you.

[1]: http://msdn.microsoft.com/en-us/library/ms143506.aspx
more ▼

answered Mar 11, 2011 at 02:13 AM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 1155 times

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