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

Question

Post reply

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

HookSQLDBA7

SSChampion

Points: 10709
More actions
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

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

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

bake13 SSC Eights! Points: 955 More actions · Answer 1

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

HookSQLDBA7 SSChampion Points: 10709 More actions · Answer 2

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

matt6288 SSCertifiable Points: 5058 More actions · Answer 3

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.

bake13 SSC Eights! Points: 955 More actions · Answer 4

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.

HookSQLDBA7 SSChampion Points: 10709 More actions · Answer 5

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

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

Thanks, Kevin

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

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

matt6288 SSCertifiable Points: 5058 More actions · Answer 7

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

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 8

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.

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 9

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

HookSQLDBA7 SSChampion Points: 10709 More actions · Answer 10

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

EdVassie SSC Guru Points: 60472 More actions · Answer 11

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

sivaprasad SSCertifiable Points: 6183 More actions · Answer 12

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]

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]

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 13

Kevin

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

John

HookSQLDBA7 SSChampion Points: 10709 More actions · Answer 14

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

Kevin