OS 64 Bit, SQL 32 Bit

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » OS 64 Bit, SQL 32 Bit

OS 64 Bit, SQL 32 Bit

Rate Topic

Display Mode

Topic Options

Author

Message

dakshinamurthy-655138

Posted Monday, August 20, 2012 3:45 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

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

GilaMonster

Posted Monday, August 20, 2012 3:53 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:52 AM
Points: 38,102, Visits: 30,393

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

dakshinamurthy-655138

Posted Monday, August 20, 2012 3:59 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

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

GilaMonster

Posted Monday, August 20, 2012 5:04 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:52 AM
Points: 38,102, Visits: 30,393

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

dakshinamurthy-655138

Posted Monday, August 20, 2012 5:07 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

Okay thanks a lot

With Regards
Dakshina Murthy

Post #1347082

opc.three

Posted Monday, August 20, 2012 2:49 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 6,826, Visits: 11,951

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1347484

dakshinamurthy-655138

Posted Monday, August 20, 2012 9:42 PM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:27 AM
Points: 329, Visits: 890

Thanks for the inputs.

With Regards
Dakshina Murthy

Post #1347548

« Prev Topic | Next Topic »

Permissions