Post reply

OS 64 Bit, SQL 32 Bit

  • August 20, 2012 at 3:45 am

    #260868

    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

  • August 20, 2012 at 3:53 am

    #1527481

    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, MVP, M.Sc (Comp Sci)
    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

  • August 20, 2012 at 3:59 am

    #1527484

    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

  • August 20, 2012 at 5:04 am

    #1527510

    Shouldn't be any issues unless you're using linked servers with 32-bit drivers.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • August 20, 2012 at 5:07 am

    #1527511

    Okay thanks a lot

    With Regards

    Dakshina Murthy

  • August 20, 2012 at 2:49 pm

    #1527867

    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

  • August 20, 2012 at 9:42 pm

    #1527922

    Thanks for the inputs.

    With Regards

    Dakshina Murthy

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply