Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:19 PM
Points: 333, Visits: 378
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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:07 PM
Points: 60, Visits: 1,119
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:19 PM
Points: 333, Visits: 378
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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 8, 2014 12:25 PM
Points: 1,207, Visits: 1,278
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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:07 PM
Points: 60, Visits: 1,119
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 4:19 PM
Points: 333, Visits: 378
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

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 20,861, Visits: 32,888
Yes. and you are probably running on a X86 version of the OS as well.



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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 8, 2014 12:25 PM
Points: 1,207, Visits: 1,278
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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 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 12»»

Permissions Expand / Collapse