SQL 2005 x64 not really 64 bit?

  • Got an odd one here. I was "informed" that the 64 bit version of SQL Server 2005 is not really 64 bit and that it does some kind of weird memory mapping/merging to access the higher memory registries (AKA some modified version of AWE in the 32 bit world). I can't possibly understand how this is true since the executable is definitely 64 bit. Has anyone else heard this strange rumor or see how it is remotely possible?

  • I'd ask them to supply a whitepaper or similar official item on the subject, news to me.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • x64 is a full-blown 64-bit version of SQL, flat memory addressing up to the maximum supported.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply