Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

UPDATE: My fault, i misread X86 and X64. We don't have a 64bit OS.

Hey all,

Quick question, our IT Dept have installed a 32bit version of SQL Enterprise on a 64bit OS. This works, quite well in fact, however is it sub-optimal?

The machines have 32gb of ram and 16 cores, can the 32bit version of SQL 2005 actually access all 32gb of ram? Or will it still have the 32bit limitaion?

Cheers, D

share|improve this question

migrated from Jan 28 '11 at 15:41

This question came from our site for professional and enthusiast programmers.

This belongs on ServerFault. – SLaks Jan 27 '11 at 15:29
Absolutely correct, my apologies. – Dean Thomas Jan 27 '11 at 15:40

Definitely sub-optimal. See: 64-bit vs 32-bit Windows/SQL install. Is there a reason why they're not installing the 64-bit version?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.