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

OS 64 Bit, SQL 32 Bit Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 3:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:42 AM
Points: 330, Visits: 973
Hi All,

i have a scenario where in the Operating System is Windows 2003 R2 Datacenter X64 bit edition service pack 2 and SQL is of 32 bit Standard Edition (In Database Server). Application side we have Operating System is Windows64 Bit Edition with Service Pack 2. I would like to know will there be any issue in handling the requests from SQL Server side.

With Regards
Dakshina Murthy
Post #1347048
Posted Monday, August 20, 2012 3:53 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:42 AM
Points: 39,980, Visits: 36,343
No issues, but you're going to have all the 32-bit memory limitations. Why not install 64-bit SQL?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1347050
Posted Monday, August 20, 2012 3:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:42 AM
Points: 330, Visits: 973
Thanks for the quick response.

Sure we will install 64 Bit SQL, but wanted to know will there be any major impact in serving the requests from the application side. Because its a production environment where we have 32 Bit SQL with 64 BIT OS.
We are planning the migrate to 64 BIT SQL, wanted to know if any major impacts in serving the requests.

With Regards
Dakshina Murthy
Post #1347053
Posted Monday, August 20, 2012 5:04 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:42 AM
Points: 39,980, Visits: 36,343
Shouldn't be any issues unless you're using linked servers with 32-bit drivers.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1347080
Posted Monday, August 20, 2012 5:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:42 AM
Points: 330, Visits: 973
Okay thanks a lot

With Regards
Dakshina Murthy
Post #1347082
Posted Monday, August 20, 2012 2:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:44 PM
Points: 7,107, Visits: 12,661
In addition to Linked Servers (including adhoc uses via OPENQUERY, OPENDATASOURCE and OPENROWSET) calling an external app using xp_cmdshell can be affected if the called apps cannot run in a 64-bit shell. If you're using SSIS on the server any data access drivers can become an issue as well of which upgrading to use a 64-bit Excel driver is a common need.

From the client-side though, in terms of remote clients connecting to the instance, the change to 64-bit should not be detectable.

edit: should not be


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1347484
Posted Monday, August 20, 2012 9:42 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:42 AM
Points: 330, Visits: 973
Thanks for the inputs.

With Regards
Dakshina Murthy
Post #1347548
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse