Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 )

share|improve this question
1  
"Intel X86" - you installed the 32-bit version? –  Phil Dec 14 '13 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 '13 at 23:07
1  
I think I win a prize. –  Phil Dec 14 '13 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 '13 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 '13 at 23:15

2 Answers 2

up vote 7 down vote accepted

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

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.