SQL Server Performance

how to find out 32/64 bit installation

Discussion in 'General DBA Questions' started by ramasubbup, Apr 25, 2006.

  1. ramasubbup New Member

    Hi,

    How of find out if SQL Server installed is 32bit or 64bit edition?
  2. satya Moderator

    Using
    select @@version
    will get you the and for 32 bit it returns "(Intel X86)".

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. manojbandha New Member

    what it will return if it is 64 bit
  4. Luis Martin Moderator

    You can use xp_msver also.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  5. ramasubbup New Member

    using select @@version it returns

    "Microsoft SQL Server 2000 - 8.00.911 (Intel X86) Jan 29 2004 13:24:35 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"

    can anyone send the output of 64 bit version using select @@version?


  6. ramkumar.mu New Member

    xp_msver too doesnt explicitly say whether the machine is 64 or 32

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  7. ramasubbup New Member

    I heard that if it is 64 bit, select @@version will display 64 bit in braces. For 32 bit it is not.

    You can also get the info from the command prompt c:>sqlserv.exe -v or

    select serverproperty('edition')
  8. satya Moderator

    I haven't experiemented on 64 bit systems, I think it will return 64-bit at the end of the version results.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. ramkumar.mu New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ramasubbup</i><br /><br />I heard that if it is 64 bit, select @@version will display 64 bit in braces. For 32 bit it is not.<br /><br />You can also get the info from the command prompt c:&gt;sqlserv.exe -v or <br /><br />select serverproperty('edition')<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Ramasubbu,<br /><br />Serverproperty('Edition') doesnt give you the info about 64 and 32 bit.. I referred in BOL,<br /><br />Edition The edition of the Microsoft® SQL Server™ instance installed on the server. <br />Returns:<br /><br />'Desktop Engine'<br />'Developer Edition'<br />'Enterprise Edition'<br />'Enterprise Evaluation Edition'<br />'Personal Edition'<br />'Standard Edition'<br /><br />Base data type: nvarchar(12<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /> <br />and pathetically i am getting an acces denied message if i run the command prompt<br /><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  10. satya Moderator

    Edition reference is different from the installation type of 32 bit or 64 bit, if you're getting access denied then make sure you have admin rights on the server.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  11. ramkumar.mu New Member

    quote:Originally posted by satya

    Edition reference is different from the installation type of 32 bit or 64 bit, if you're getting access denied then make sure you have admin rights on the server.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

    Yes I do. i am a local administrator to the machine

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  12. vbkenya New Member

    If you have a 64-bit Intel box, you will get something like this when you run SELECT @@VERSION

    "Microsoft SQL Server 2005 - 9.00.1399.06 (Intel IA-64)"

    Note: IA-64 instead of X86

    Nathan H. Omukwenyi
    MVP [SQL Server]
  13. ramasubbup New Member

    Thanks. This clarifies the original question of this forum.


    can you also please specify what will be output for the following commands in 64-bit version
    Just to see that if they also returns the required info

    1. master..xp_msver
    and
    2. select serverproperty('edition')
  14. ramasubbup New Member

    Here is the output of master..xp_msver
    and select serverproperty('edition') on a 64-bit environment

    -------------------------------------------------------
    1 ProductName NULL Microsoft SQL Server
    2 ProductVersion 589824 9.00.2047.00
    3 Language 1033 English (United States)
    4 Platform NULL NT AMD64
    5 Comments NULL NT AMD64
    6 CompanyName NULL Microsoft Corporation
    7 FileDescription NULL SQL Server Windows NT - 64 Bit
    8 FileVersion NULL 2005.090.2047.00
    9 InternalName NULL SQLSERVR
    10 LegalCopyright NULL © Microsoft Corp. All rights reserved.
    11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
    12 OriginalFilename NULL SQLSERVR.EXE
    13 PrivateBuild NULL NULL
    14 SpecialBuild 134152192 NULL
    15 WindowsVersion 248381957 5.2 (3790)
    16 ProcessorCount 4 4
    17 ProcessorActiveMask 4 f
    18 ProcessorType 8664 NULL
    19 PhysicalMemory 8023 8023 (8413024256)
    20 Product ID NULL NULL
    -------------------------------------------------------


    Here is the output of select serverproperty('edition')
    -------------------------------------------------------
    Enterprise Edition (64-bit)

  15. satya Moderator

    .. good you've answered your own question, that helps for a newbie [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  16. ramkumar.mu New Member

    what are these 64 and 32 all about? can anyone brief me??

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  17. vbkenya New Member

  18. ramkumar.mu New Member

    quote:Originally posted by vbkenya

    CPU (processor) architectures.

    http://en.wikipedia.org/wiki/64-bit]


    Nathan H. Omukwenyi
    MVP [SQL Server]


    This is Cool. Thanks for the link.

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  19. satya Moderator

    ... as in terms of SQL Server is more memory.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page