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

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Administering » How to determine if SQL Server and O/S are...

Add to briefcase

18 posts, Page 1 of 2

1 2 »»

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

Expand / Collapse

Author

Message

Posted Tuesday, July 21, 2009 2:01 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:32 PM
Points: 271, Visits: 248

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

Post #756932

Posted Tuesday, July 21, 2009 2:06 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:35 AM
Points: 50, Visits: 923

I believe issuing a

select @@version

will provide you the information both the OS and SQL engine.

Post #756935

Posted Tuesday, July 21, 2009 2:18 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:32 PM
Points: 271, Visits: 248

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

Post #756946

Posted Tuesday, July 21, 2009 2:23 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, January 28, 2013 2:05 PM
Points: 1,130, Visits: 1,181

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)

Post #756950

Posted Tuesday, July 21, 2009 2:41 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 6:35 AM
Points: 50, Visits: 923

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.

Post #756964

Posted Tuesday, July 21, 2009 2:42 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:32 PM
Points: 271, Visits: 248

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

Post #756966

Posted Tuesday, July 21, 2009 2:51 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 21,588, Visits: 27,375

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

Cool

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #756974

Posted Tuesday, July 21, 2009 3:00 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, January 28, 2013 2:05 PM
Points: 1,130, Visits: 1,181

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

Post #756986

Posted Tuesday, July 21, 2009 5:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 2012 2:49 PM
Points: 140, Visits: 310

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.

Post #757058

Posted Tuesday, July 21, 2009 5:23 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 2012 2:49 PM
Points: 140, Visits: 310

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

Post #757063

« Prev Topic | Next Topic »

Add to briefcase

18 posts, Page 1 of 2

1 2 »»

Permissions

Expand / Collapse