Post reply

How to determine if SQL Server and O/S are 32-Bit or 64-Bit?

  • July 21, 2009 at 2:01 pm

    #140019

    We are running SQL Server 2000 (SP4) 8.00.2055 on Microsoft Windows Server 2003 R2 Standard Edition SP2 on NT Intel X86. I would like to know the following:

    How do you determine if your operating system is 32 or 64-bit?

    How do you determine if your SQL Server Database is 32 or 64-bit?

    Thanks in advance, Kevin

  • July 21, 2009 at 2:06 pm

    #1027903

    I believe issuing a select @@version will provide you the information both the OS and SQL engine.

  • July 21, 2009 at 2:18 pm

    #1027912

    No 'select @@version' does not explicitly display 32 or 64-bit. I have tried the following sql commands and neither supply what I am looking for.

    --Version Number

    select @@version

    --Service Pack

    select serverproperty('ProductLevel')

    --Version Number

    select serverproperty('ProductVersion')

    --Edition

    select serverproperty('Edition')

    Thanks, Kevin

  • July 21, 2009 at 2:23 pm

    #1027916

    select @@version works for the 64-bit sql edition but i am not sure how to get the OS.

    output from select @@version on 64-bit machine.

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)

  • July 21, 2009 at 2:41 pm

    #1027928

    Ah, ok, you are correct. Depending on your permissions, another option might be an xp_cmdshell call such as xp_cmdshell 'systeminfo'. You might need to output that to a table and parse through it for the information you are seeking.

  • July 21, 2009 at 2:42 pm

    #1027930

    This is the results I get with 'select @@version' on our machine:

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Does the (Intel X86) - indicates 32-bit SQL Server 2000?

    Thanks, Kevin

  • July 21, 2009 at 2:51 pm

    #1027938

    Yes. and you are probably running on a X86 version of the OS as well.

  • July 21, 2009 at 3:00 pm

    #1027950

    Here is the only difference I have found to tell for sure. On 64-bit sql instances this returns 2 rows

    name

    affinity64 mask

    affinity64 I/O mask

    SELECT [name] FROM sys.configurations

    WHERE NAME LIKE '%64%'

    on 32-bit instances it returns 0 rows.

    Still working on the OS version

  • July 21, 2009 at 5:20 pm

    #1028010

    Type msinfo32 in start-->run mode , takes you to the system information.Check for the system type, processor..if they are X86 based then it is a 32 bit else 64 bit.

    Properties of My computer show u 64bit, if it is a 64-bit.

  • July 21, 2009 at 5:23 pm

    #1028015

    you cannot install SQL 2005 of 64bit on 32 bit processor, so ur's shud be a 32-bit OS with 32bit SQL 2005

  • July 22, 2009 at 8:29 am

    #1028351

    Is there a SQL Server 2005 32-bit version that I could load onto the 32 bit processor?

    Thanks to all of you for your assistance, Kevin

  • July 23, 2009 at 2:33 am

    #1028800

    There are 32-bit and 64-bit version of all of SQL Server 2000, 2005 and 2008.

    The 64-bit version of SQL Server 2000 is for database services only, most other components run only at 32-bit.

    There are some 64-bit restrictions in SQL Server 2005 - the main one I know of is that AMO (Analysis services Management Objects) run only in 32-bit but can manage a 64-bit instance of SSAS. Also, last time I looked I could not find a 64-bit version of SQL 2005 Express with Advanced Services on the MS download site.

    There are no 64-bit restrictions with SQL Server 2008 that I know of.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • July 23, 2009 at 3:03 am

    #1028809

    On DOS Command Prompt run the command below to know what sort of processor running on the server.

    Microsoft Windows XP [Version 5.1.2600]

    (C) Copyright 1985-2001 Microsoft Corp.

    D:\Documents and Settings\Siva>set processor

    PROCESSOR_ARCHITECTURE=x86

    PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel

    PROCESSOR_LEVEL=6

    PROCESSOR_REVISION=0f0d

    D:\Documents and Settings\Sivat>

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • July 23, 2009 at 7:39 am

    #1028947

    Kevin

    Try xp_msver. It returns lots of information on the processor, the Windows version, SQL Server and more.

    John

  • July 23, 2009 at 8:27 am

    #1028988

    Thanks John and to all who responded. The xp_msver extended sp provides a wealth of information.

    Kevin

Viewing 15 posts - 1 through 15 (of 18 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy