RE: [SQLDownUnder] 64bit users x86

[Greg Wood]

Hi Rowan,

name,minimum,maximum,config_value,run_value
awe enabled,0,1,1,1

name,minimum,maximum,config_value,run_value
min server memory (MB),0,2147483647,5051,5051

name,minimum,maximum,config_value,run_value
max server memory (MB),4,2147483647,14798,14798

name,minimum,maximum,config_value,run_value
set working set size,0,1,0,0

 

as you can see i tried starting it at 5 gig, didn't do anything.

I also checked to see if any more info in the logs.. nothing. No other process is taking any memory.

as to the other question IA64 is a different version of OS & yes we have that hardware and the SQL Server 2000 version for that build.

We have now opened a call with MS. Our other test is to put more memory in our IA64 server(currently 4gig) and see if we get over this4gig limit

 

Greg Wood gwood@xxxxxxxxxxx

---

From: "Rowan Burke" <rburke@xxxxxxxxxx>
Reply-To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
To: <SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: [SQLDownUnder] 64bit users x86
Date: Wed, 31 Aug 2005 17:24:56 +1000
MIME-Version: 1.0
Received: from mail.mdnug.org ([203.89.209.190]) by mc5-f17.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 31 Aug 2005 00:21:29 -0700
Received: from fnsexc.fns.com.au ([203.56.230.14]) by mdnug.org with MailEnable ESMTP; Wed, 31 Aug 2005 17:22:54 +1000

Cool,

 

So the OS and SQL know about the memory.

 

Is anything set in the config options?:-

exec sp_configure 'awe'
exec sp_configure 'min server memory (MB)'
exec sp_configure 'max server memory (MB)'
exec sp_configure 'set working set size'

 

What about any messages in the SQL log at startup?

 

You could try and fix the memory above 4GB and see whether SQL can grab the memory. 

 

Depending on your settings it may be yielding it.  Does task manager say that the remaining 8GB is free or does some other application have large amounts of memory allocated?

 

Rowan

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Greg Wood
Sent: Wednesday, 31 August 2005 4:53 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] 64bit users x86

Rowan,

I see the 310 message in the SQL Server Agent Error Log - it is a informational message

Task Manger shows all the memory 16776108

properties of SQL Server shows -see attached fiel

 

Greg Wood gwood@xxxxxxxxxxx

---

From: "Rowan Burke" <rburke@xxxxxxxxxx>
Reply-To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
To: <SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: [SQLDownUnder] 64bit users x86
Date: Wed, 31 Aug 2005 16:39:45 +1000
MIME-Version: 1.0
Received: from mail.mdnug.org ([203.89.209.190]) by mc9-f32.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 30 Aug 2005 23:34:55 -0700
Received: from fnsexc.fns.com.au ([203.56.230.14]) by mdnug.org with MailEnable ESMTP; Wed, 31 Aug 2005 16:37:43 +1000

Greg,

 

Do you see all the memory in the System Properties or in task manager?  It looks like the OS should be able to use up to 32GB, and 4.2.3 seems to confirm that to me....   

 

Where do you see the message:-

[310] 8 processor(s) and 4096 MB RAM detected

 

Rowan

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Greg Wood
Sent: Wednesday, 31 August 2005 3:40 PM
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Cc: davele@xxxxxxxxxxxxx
Subject: [SQLDownUnder] 64bit users x86

Hi,

I need some advice/experience from some other users in the 64bit world.

We have just setup a new server
4 way Xeon 64bit
16 GB Memory
Windows 2003 Standard Server x64 Edition
SQL Server 2000 64bit with sp4 and AWE patch(http://www.microsoft.com/downloads/details.aspx?FamilyID=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en)

We cannot get sq server process to move over the 4gig memory mark(hangs around the 3.8), I can see in the start up the machine reports
[310] 8 processor(s) and 4096 MB RAM detected

I have had a read of IBM's document and point 4.2.3 tells me that i should go to the Enterprise edition http://www.redbooks.ibm.com/redpapers/pdfs/redp3982.pdf

Will rebuilding the OS solve this problem or is it a waste of time - project due in 10 days. Any advice would be welcomed

Greg Wood

gwood@xxxxxxxxxxx

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net