RE: [SQLDownUnder] 64bit users x86


    [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
    • From: jmplun
    • Subject: RE: [SQLDownUnder] 64bit users x86
    • Date: Wed, 31 Aug 2005 17:23:34 +1000

    Minas,
    
    Hate to tell you this but all your images have been removed from text
    and sent as attachments ( always happens)
    So your article is to me unreadable.
    
    Jarrad
    
    -----Original Message-----
    From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx
    [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
    mcasiou@xxxxxxxxxx
    Sent: Wednesday, 31 August 2005 5:09 PM
    To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
    Subject: Re: [SQLDownUnder] 64bit users x86
    
    
    
    (Not deliberately being rude - it'd just take ages to try figure out how
    to make it sound nice... so ignore any negative connetations etc.) Both
    of the following references suggest that YOU DO NOT require Windows 2003
    Enterprise....
    
    Also, I suspect you've already checked:
    (Embedded image moved to file: pic08928.jpg)
    
    & if dynamic, tried to load heaps of data to wind it right up?
    
    
       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
    The end of older memory tuning techniques
    The increased flat memory model of Windows Server 2003, x64 Edition
    allows means that older memory turning options such as /4GT (equivalent
    is /3GB in Windows
    2000) and
    Physical Address Extensions (/PAE) are not longer required.
    
    Table 4-3 Physical memory and processor limits
    Note: For more information about the BOOT.INI switches (/PAE and /3GB)
    that are used in Windows 32-bit operating systems, refer to the IBM
    Redbook, Tuning IBMEserver xSeries Servers for Performance, SG24-5827
    
    Operating system 32-bit 64-bit (x64)
    Windows Server 2003, Standard Edition 4 GB / 4-way 32 GB / 4-way Windows
    Server 2003, Enterprise Edition 32 GB / 8-way 1 TB / 8-way Windows
    Server 2003, Datacenter Edition 64 GB / 32-way 1 TB / 64-way
    
     
    http://www.microsoft.com/windowsserver2003/evaluation/features/compareed
    itions.mspx#32ram
    
    
     
    
     
    
     
    
     
    
     
    
     
    
     
    
     Compare the features of the Windows Server 2003 family using this set
    of   
     tables, which is organized by function.
    
     
    
     
    
     Features
    
     
    
     
    
     Key: (Embedded image moved to file: pic05858.gif)Feature included or
    
     supported = Feature included  (Embedded image moved to file:
    pic02249.gif) 
     Feature partially supported = Feature partially supported  (Embedded
    image 
     moved to file: pic21603.gif)Feature not included = Feature not included
    
     
    
     
    
     
    
     
    
     
    
     
    
      Feature
    
                       Standard Edition
    
                                          Enterprise Edition
    
                                                           Datacenter
    Edition   
     
    We 
     
    b  
     
    Ed 
     
    it 
     
    io 
     
    n  
     
    
     
    
     
    
     
    
     
    
      Hardware Specifications
    
     
    
     
    
                       64-Bit Support1
    
                                             (Embedded image moved to file:
    
                                              pic11102.gif)Feature included
    
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic22530.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c1 
     
    63 
     
    03 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic14854.gif)Feature
    not   
                                             included
    
     
    
                       Hot Add Memory2, 3
    
                                             (Embedded image moved to file:
    
                                            pic00616.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic00601.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c1 
     
    90 
     
    70 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic04224.gif)Feature
    not   
                                             included
    
     
    
                       Non-Uniform Memory Access (NUMA)3
    
                                             (Embedded image moved to file:
    
                                            pic29929.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic21471.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    83 
     
    34 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic10012.gif)Feature
    not   
                                             included
    
     
    
                       Datacenter Program
    
                                             (Embedded image moved to file:
    
                                            pic20582.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic14649.gif)Feature 
                                                               not included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    98 
     
    65 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic11452.gif)Feature
    not   
                                             included
    
     
    
                       2 GB RAM Maximum
    
                                             (Embedded image moved to file:
    
                                            pic13731.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic26876.gif)Feature 
                                                               not included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    38 
     
    35 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                        (Embedded image moved to file: pic29554.gif)Feature
    
                                             included
    
     
    
                       4 GB RAM Maximum
    
                                             (Embedded image moved to file:
    
                                              pic27157.gif)Feature included
    
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic30367.gif)Feature 
                                                               not included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c1 
     
    42 
     
    35 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic20959.gif)Feature
    not   
                                             included
    
     
    
                       32 GB RAM Maximum4
    
                                             (Embedded image moved to file:
    
                                            pic21515.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic06466.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    39 
     
    31 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic15948.gif)Feature
    not   
                                             included
    
     
    
                       64 GB RAM Maximum5
    
                                             (Embedded image moved to file:
    
                                            pic03482.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic08737.gif)Feature 
                                                           partially
    supported  
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c2 
     
    07 
     
    85 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic32650.gif)Feature
    not   
                                             included
    
     
    
                       1 TB RAM Maximum6
    
                                             (Embedded image moved to file:
    
                                            pic14925.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic24278.gif)Feature 
                                                               not included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    80 
     
    99 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    pa 
     
    rt 
     
    ia 
     
    ll 
     
    y  
     
    su 
     
    pp 
     
    or 
     
    te 
     
    d  
                      (Embedded image moved to file: pic03977.gif)Feature
    not   
                                             included
    
     
    
                       2-Way SMP
    
                                             (Embedded image moved to file:
    
                                              pic02953.gif)Feature included
    
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic25426.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c1 
     
    97 
     
    33 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                        (Embedded image moved to file: pic03003.gif)Feature
    
                                             included
    
     
    
                       4-Way SMP
    
                                             (Embedded image moved to file:
    
                                              pic08130.gif)Feature included
    
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic30618.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c2 
     
    37 
     
    62 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic20262.gif)Feature
    not   
                                             included
    
     
    
                       8-Way SMP
    
                                             (Embedded image moved to file:
    
                                            pic10336.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic09537.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c0 
     
    22 
     
    68 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    in 
     
    cl 
     
    ud 
     
    ed 
                      (Embedded image moved to file: pic04683.gif)Feature
    not   
                                             included
    
     
    
     
    
     
    
     
    
     
    
     
    
      32-Way SMP
    
                       (Embedded image moved to file: pic00623.gif)Feature
    not  
                                               included
    
                                             (Embedded image moved to file:
    
                                            pic08361.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic22644.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c1 
     
    14 
     
    51 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
     
    
     
    
     
    
     
    
     
    
     
    
     
    
      64-Way SMP
    
                       (Embedded image moved to file: pic11785.gif)Feature
    not  
                                               included
    
                                             (Embedded image moved to file:
    
                                            pic02552.gif)Feature not
    included   
                                                             (Embedded image
    
                                                              moved to file:
    
     
    pic04968.gif)Feature 
                                                                 included
    
     
    (E 
     
    mb 
     
    ed 
     
    de 
     
    d  
     
    im 
     
    ag 
     
    e  
     
    mo 
     
    ve 
     
    d  
     
    to 
     
    fi 
     
    le 
     
    :  
     
    pi 
     
    c2 
     
    16 
     
    18 
     
    .g 
     
    if 
     
    )  
     
    Fe 
     
    at 
     
    ur 
     
    e  
     
    no 
     
    t  
     
    in 
     
    cl 
     
    ud 
     
    ed 
     
    
     
    
     
    
     
    
     
    
    
    
    
    
    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: pic20611.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:
    davele@xxxxxxxxxxxxx                                               
                          SQLDownUnderList@listserver.         Subject:
    [SQLDownUnder] 64bit users x86                                     
                          readify.net
    
     
    
     
    
                          31/08/2005 03:39 PM
    
                          Please respond to
    
                          SQLDownUnder
    
     
    
    
    
    
    
    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-4
    8B8-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
    
    
    
    



    (Click here for more information on the sqldownunder mailling list)