32-bit on 64-bit platform

Question

Hi,

is 32-bit SQL Server certified on a windows 64-bit ?

Thanks

Answer 1

Hi,

If your hardware supports 64 bit and you are running Windows 64 bit I would strongly suggest you install and use SQL server 64 bit. 32 bit SQL has lots of potential performance issues that are eliminated with the use of 64 bit.

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 2

OK thanks I know that

but is it certified ?

Answer 3

Do you mean SQL server 2008? Yes, 32 bit editions are supported on 64 bit Windows for stand alone instances i.e. not clustered instances.

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 4

OK thanks I know that

but is it certified ?

certified for what ?

if you effectively mean supported by Microsoft please check the link provided by Sean in the previous posting (scroll down till the section "SQL Server 2008 R2 DataCenter (32-bit)" or "SQL Server 2008 R2 Enterprise (32-bit)" or "SQL Server 2008 R2 Standard (32-bit)" depending on your edition.