October 30, 2013 at 5:06 am
If you read the Documentation (for Hekaton CTP1)released in June 2013, by Kalen Delaney, she mentions that In-memory OLTP components will always be installed with 64 bit but not with 32 bit edition.
October 30, 2013 at 5:07 am
Do we have SQL 2014 installation setup for 32-bit machines? 🙂
October 30, 2013 at 5:20 am
MSDN makes it seems you can install SQL 2014 on 32-bit systems:
Hardware and Software Requirements for Installing SQL Server 2014
On the preview site, I see the following:
Previews
ISO 64-bit and 32-bit
CAB 64-bit and 32-bit
SQL Server 2014 CTP2 on Windows Azure
Why you would want to install a memory-intensive database engine on a 32-bit machine seems a mystery to me.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 6:57 am
As much as possible, always go to the documentation in Books Online first.
Here are the requirements for Memory Optimized Tables. It's 64 bit and Enterprise only (or Development, yes).
As Koen says, why on earth would you take something that's going to require just scads and scads of memory and then try to run it on a brain dead 32bit system?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 6, 2013 at 2:33 am
I agree with earlier answers. we can't use 32 bit SQL Instance to create In-Memory optimized tables. Here is the error message if you attempt to do so.
http://msdn.microsoft.com/en-us/library/dn232521(v=sql.120).aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply