0

My SQL Server 2012 Standard edition, 64bit has a total virtual address space of 4GB. Why is that?

it is a 64bit installation: print @@VERSION :

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86) 
    Dec 28 2012 19:06:41 
    Copyright (c) Microsoft Corporation
    Standard Edition on Windows NT 6.2 <X64> (Build 9200: ) (WOW64)

virtual space of just 4GB

select total_virtual_address_space_kb from sys.dm_os_process_memory 
4194176

(entire result of sys.dm_os_process_memory http://screencast.com/t/2PN2PDQYpt )

Improve this question
6
  • 1
    "Intel X86" - you installed the 32-bit version?
    – Philᵀᴹ
    Dec 14, 2013 at 23:06
  • thanks @Phil I JUST freaking noticed that! I read the wrong article that said - x64 means its 64bit !
    – Greg Bala
    Dec 14, 2013 at 23:07
  • 1
    I think I win a prize.
    – Philᵀᴹ
    Dec 14, 2013 at 23:08
  • This is a freaking nightmare that cost me days of stupid investigation! @Phil, can you shed some light on this related question dba.stackexchange.com/questions/55030/…
    – Greg Bala
    Dec 14, 2013 at 23:14
  • I don't know enough about SQL Server to help you - others will be along soon; I'm an Oracle DBA. I do, however, know my X86 from my X64 :P
    – Philᵀᴹ
    Dec 14, 2013 at 23:15

2 Answers 2

Reset to default
7

The reason is because it isn't a 64-bit installation.

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86)

Intel X86 is 32-bit. X64 is 64-bit.

Improve this answer
-1

Simple mistake of installing the 32-bit version instead of the 64-bit version.

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86) 
Dec 28 2012 19:06:41 
Copyright (c) Microsoft Corporation
Standard Edition on Windows NT 6.2 <X64> (Build 9200: ) (WOW64)

This means 32-bit version, which has the stated memory limit. You should perform backups and reinstall SQL Server using the correct 64-bit version.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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