RE: [SQLDownUnder] 64bit users x86

[mcasiou]

I thin kyour problem is that 64bit SQL Server is for Itanium!!!

Should you not be running on x64, but rather an Itanium Server.

Can you switch to SQL Server 2005? They have an x64 Edition of SQL Server
2005 Beta 2.
May be your best bet.

Cheers
Minas Casiou
Information Systems Architect, Senior Consultant

CSC Australia
Enterprise Business Solutions
Financial Services
26 Talavera Road
Macquarie Park NSW
2113 Australia
Ph: (02) 9034 3338
Mob: 0412 343 069
email: mcasiou@xxxxxxxxxx
(Embedded image moved to file: pic30458.gif)
----------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------------------




                                                                                                                                       
                      "Greg Wood"                                                                                                      
                      <gwood@xxxxxxxxxxx>                  To:      SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx                                
                      Sent by:                             cc:                                                                         
                      SQLDownUnderList@listserver.         Subject: RE: [SQLDownUnder] 64bit users x86                                 
                      readify.net                                                                                                      
                                                                                                                                       
                                                                                                                                       
                      31/08/2005 05:04 PM                                                                                              
                      Please respond to                                                                                                
                      SQLDownUnder                                                                                                     
                                                                                                                                       




More fuel to the fire in this article towards the bottom


http://www.devx.com/amd/Article/20342


 By contrast, on a 64-bit system, the WOW64 infrastructure can allocate as
much 4GB of RAM to a 32-bit Windows application—and that address space does
not need to accommodate the operating system and drivers. That gives the
full 4GB to the application, a significant increase for resource-hungry
applications

i think this might be the answer, anymore comments?





Greg Wood gwood@xxxxxxxxxxx
From: "Greg Wood" <gwood@xxxxxxxxxxx>
Reply-To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [SQLDownUnder] 64bit users x86
Date: Wed, 31 Aug 2005 16:52:44 +1000
MIME-Version: 1.0
X-Originating-IP: [202.53.47.138]
X-Originating-Email: [gwood@xxxxxxxxxxx]
X-Sender: gwood@xxxxxxxxxxx
Received: from mail.mdnug.org ([203.89.209.190]) by mc4-f33.hotmail.com
with Microsoft SMTPSVC(6.0.3790.211); Tue, 30 Aug 2005 23:53:14 -0700
Received: from hotmail.com ([65.54.175.44]) by mdnug.org with MailEnable
ESMTP; Wed, 31 Aug 2005 16:55:56 +1000
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Tue, 30 Aug 2005 23:52:44 -0700
Received: from 65.54.175.201 by by104fd.bay104.hotmail.msn.com with
HTTP;Wed, 31 Aug 2005 06:52:44 GMT







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


<< sqlPic.JPG >>


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

Attachment: pic30458.gif
Description: GIF image