locked
SQL Server in WOW mode? RRS feed

  • Question

  • We're looking in to upgrading our SQL 2008 SP3 cluster to SQL 2012 and I see something about not being able to upgrade a SQL cluster running in WOW mode.  I read up a little on WOW64 and understand what it means to run 32 bit applications on a 64 bit OS.

    But how do i tell if my SQL cluster is running in WOW mode?  I inherited this cluster and didn't originally build it.

    Thanks,

    Monday, August 5, 2013 6:15 PM

Answers

  • >But how do i tell if my SQL cluster is running in WOW mode?

    SQL Server is running in WOW64 mode just in case Windows is 64bit and SQL Server is 32bit.

    One way to tell is to query:

    select @@version

    That outputs the bitness of both SQL Server and Windows.  EG

    Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64) <----that means it's 64bit SQL Server and not running in WOW64.

    May 22 2013 17:10:44

    Copyright (c) Microsoft Corporation

    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)  <--windows is 64bit too

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Sofiya Li Thursday, August 8, 2013 1:38 AM
    Monday, August 5, 2013 6:21 PM

All replies

  • >But how do i tell if my SQL cluster is running in WOW mode?

    SQL Server is running in WOW64 mode just in case Windows is 64bit and SQL Server is 32bit.

    One way to tell is to query:

    select @@version

    That outputs the bitness of both SQL Server and Windows.  EG

    Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64) <----that means it's 64bit SQL Server and not running in WOW64.

    May 22 2013 17:10:44

    Copyright (c) Microsoft Corporation

    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)  <--windows is 64bit too

    David


    David http://blogs.msdn.com/b/dbrowne/

    • Marked as answer by Sofiya Li Thursday, August 8, 2013 1:38 AM
    Monday, August 5, 2013 6:21 PM
  • Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)   Sep 21 2011 22:45:45   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    Thanks for the info!

    Monday, August 5, 2013 6:26 PM