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 Wednesday, July 22, 2009 8:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 327, Visits: 364
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



Post #757478
Posted Thursday, July 23, 2009 2:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 2,880, Visits: 3,237
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #758028
Posted Thursday, July 23, 2009 3:03 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:46 PM
Points: 284, Visits: 263
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 ]http://sivasql.blogspot.com/
Post #758044
Posted Thursday, July 23, 2009 7:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 5,386, Visits: 9,962
Kevin

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

John
Post #758215
Posted Thursday, July 23, 2009 8:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 327, Visits: 364
Thanks John and to all who responded. The xp_msver extended sp provides a wealth of information.

Kevin



Post #758266
Posted Thursday, July 23, 2009 9:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
Interesting thread, and some good info.

Here's the weird one. What if you have a 32bit VM on a 64bit host. do you want to know the host platform? I'm curious if this ever matters. I don't think so, but I wonder if I'm overlooking something.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #758346
Posted Monday, January 10, 2011 6:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 10, 2011 6:53 AM
Points: 1, Visits: 1
You can determine what version of OS you are running by looking at

Start > Programs > Accessories > System Tools > System Information

[Note: I am running windows server 2008 R2 & it works for me]

also, for sql server, this works for me select serverproperty('edition')


Post #1045266
Posted Thursday, December 20, 2012 2:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 28, 2013 3:24 AM
Points: 4, Visits: 27
Task manager, in the description for SQL Server gives the bit version
Post #1398861
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse