Memory limitations, 2005 Standard - Microsoft SQL Server

Hi all,

I have recently implemented a SQL 2005 cluster using SQL 2005 Standard
on Windows 2003 Enterprise edition.

Both nodes have 4GB of RAM and according to the datasheet, SQL 2005
Standard can support the OS maximum memory amount and Win2K3 Ent
Edition can support 64GB!

However, in Enterprise Manager, if I go to the "Memory" tab of the
instance properties I can't increase the memory beyond 2147483647
(which I assume is around 2GB).

I don't have AWE enabled but am unsure as to the ramifications of this.

Any advice anyone could provide would be greatly appreciated.

Many thanks,

Ian

Mar 9 '06 #1

Subscribe Post Reply

5442

Erland Sommarskog

IM (ia*@ianmurphy.freeserve.co.uk) writes:

I have recently implemented a SQL 2005 cluster using SQL 2005 Standard
on Windows 2003 Enterprise edition.

Both nodes have 4GB of RAM and according to the datasheet, SQL 2005
Standard can support the OS maximum memory amount and Win2K3 Ent
Edition can support 64GB!

However, in Enterprise Manager, if I go to the "Memory" tab of the
instance properties I can't increase the memory beyond 2147483647
(which I assume is around 2GB).

No, that is a little over 2TB, as the unit of the parameter is MB
(or rather 2^20 bytes, I guess).

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Mar 9 '06 #2

Erland Sommarskog wrote:

IM (ia*@ianmurphy.freeserve.co.uk) writes:
I have recently implemented a SQL 2005 cluster using SQL 2005 Standard
on Windows 2003 Enterprise edition.

Both nodes have 4GB of RAM and according to the datasheet, SQL 2005
Standard can support the OS maximum memory amount and Win2K3 Ent
Edition can support 64GB!

However, in Enterprise Manager, if I go to the "Memory" tab of the
instance properties I can't increase the memory beyond 2147483647
(which I assume is around 2GB).

No, that is a little over 2TB, as the unit of the parameter is MB
(or rather 2^20 bytes, I guess).

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland, your're absolutely right. I am either blind or stupid (or
possibly a combination of both)!

Thanks for pointing this out :-) think I'll go back to washing dishes
or something...

Cheers,

Ian

Mar 10 '06 #3

Similar topics

STL and over 2GB memory

by: W Randolph Franklin | last post by:

Hi, Does STL work on a 32-bit machine when a process's total memory is over 2GB? E.g., a Pentium allows the process memory to be as large as 3GB. Ditto Boost multi arrays. Are there any...

C / C++

MS SQL Server - a plethora of limitations...

by: Jeager | last post by:

Why is it, Microsoft manage to write operating systems and office applications with every bell and whistle facility known to man. Yet, even after years and years of development they still cannot...

Microsoft SQL Server

innodb keeps crashing due to out-of-memory errors

by: Eddie | last post by:

I have a MySQL-server running Innodb. We have installed ~ 2GB of memory in the server. In spite of this MySQL keeps crashing due to out-of-memory errors. The server is a dual xeon i686 running...

MySQL Database

SQL Memory Issues - Need Advice

by: interflex | last post by:

We are currently using SQL 2000 Standard with W2K Standard and the server has 3Gb of RAM. SQL is currently occupying 1.85Gb of memory which I believe is the maximum for this version of the OS. I...

Microsoft SQL Server

Exception checking memory allocation. How?

by: Jacob | last post by:

It is common practice (I've heard) to always catch allocation exceptions from "new". How is done in practice? What would be a common procedure (path of sequence) after such an event has occured?...

C / C++

Test if pointer points to allocated memory

by: Andrew | last post by:

Is there anyway to test if a pointer points to allocated memory or not? For example if I have a pointer such as char *p is there a standard way to test whether an assignment such as the following...

C / C++

the maximum memory size allowed in malloc

by: Jerry | last post by:

I am wondering what is the maximum size of memory that malloc() could handle. Is there any limitation on that? Where am I supposed to get this kind of information? Thank you everybody.

C / C++

Help-Can I use 4 GB memory by SQL Server2000?

by: Damon | last post by:

There is a Server with 4G Memory. I installed a SQL Server 2000 standard version on it. I heard that SQLServer2000 could use only up to 2GB memory. Is it true? How can I use those 4GB memory? I...

Microsoft SQL Server

memory leak in the code?

by: George2 | last post by:

Hello everyone, Should I delete memory pointed by pointer a if there is bad_alloc when allocating memory in memory pointed by pointer b? I am not sure whether there will be memory leak if I do...

C / C++

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++