Link to home
Create AccountLog in
Avatar of marrowyung
marrowyung

asked on

SQL server 2012 express edition.

Dear all,

Right now we consider to use Microsoft® SQL Server® 2012 - Express Edition for one of our new system and we found this link to compare:


May we know that:


1) It say Maximum memory utilized is 1GB, is that means total Physical memory SQL express can take even if there are more than 1GB of totally server memory.
2)It say Number of CPUs is 4, so if we have 8 Cores CPU, it can only use 1 core?

DBA100.
ASKER CERTIFIED SOLUTION
Avatar of jogos
jogos
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of marrowyung
marrowyung

ASKER

Thanks.

 did you run that youself on a machine with 4 core and it supports?
Why do you keep doubting the MS-doc?  And no I did not checked that for sql2012 with my own eyes.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Anthony Perkins
Have you considered that in the time that you have asked this same question twice you could have first tested it with SQL Server 2008 and then with SQL Server 2012?
acperkins,

"Have you considered that in the time that you have asked this same question twice you could have first tested it with SQL Server 2008 and then with SQL Server 2012? "

I didn't consider as I just prompt the one who answer me to ask again for SQL server 2012, funny. And surely this question is not for you.

If I tested both version and the finall conquence is I don't come and ask at all. funny.
MrAli,

"unless of course you get creative with a RAM drive and put the base table in the ram disk, and now even a table scan is similar to a 'in memory' operation.
"
yeah, very creative. but we might not try it.


"Most servers aren't CPU bound these days and SQL Express doesn't give you compression which would increase CPU overhead, but yes, you are limited to those specs.  You can check the affinity mask to verify. "

4 core anyway.
Just remember that RAM drives are volatile.  If you reboot the machine all data is lost.  In some cases that's fine (for example data that get's populated easily right away).  In some cass, it's a disaster.  If you need the memory to stay persistent through a reboot look into a PCI-E SSD solution such as:

http://www.amazon.com/OCZ-Technology-Drive-Series-Express/dp/B0058RECUE/ref=sr_1_3?ie=UTF8&qid=1352186206&sr=8-3&keywords=fusion+io

Or if you have more money go for a FusionIO card.
MrAli,

OK, great, never use this before as we all use SAN.

This one is a SSD card, I see a lot like that but we don't use anyway.

Usuall who will use this ? for the tempdB only ? as the temp DB is create automatically each time the SQL server start.