x

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 '11 at 02:11 AM in Default

Manikreddy gravatar image

Manikreddy
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 '11 at 03:13 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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][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 '11 at 02:19 AM

Magnus Ahlkvist gravatar image

Magnus Ahlkvist
15.9k 15 19 32

(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 '11 at 02:13 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.3k 14 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 '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)
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x53

asked: Mar 11 '11 at 02:11 AM

Seen: 1041 times

Last Updated: Mar 11 '11 at 02:13 AM