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

  • 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

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

  • 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

  • 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)

  • 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.

  • 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

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

  • 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

  • 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.

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

  • 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

  • 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

  • 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]

  • Kevin

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

    John

  • 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 17 total)

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