Memory

Question

Post reply

Memory

Chandra Sekhara Vyas Dhara

SSChampion

Points: 10207
More actions
November 13, 2014 at 9:45 pm

#292558

Comments posted to this topic are about the item Memory
November 14, 2014 at 1:45 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 63 total)

You must be logged in to reply to this topic. Login to reply

Shiva N Hall of Fame Points: 3125 More actions · Answer 1

Shiva N

Hall of Fame

Points: 3125

November 13, 2014 at 10:15 pm

#1758445

Nice Question...

Thanks,
Shiva N
Database Consultant

Jo Pattyn SSC-Dedicated Points: 32344 More actions · Answer 2

Could you rephrase it to What is the recommended minimum memory requirement ...?

Rune Bivrin SSCrazy Eights Points: 8510 More actions · Answer 3

Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

Since the question didn't specify Express Edition there's really no answer that's completely correct.

Just because you're right doesn't mean everybody else is wrong.

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 4

Rune Bivrin (11/14/2014)
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Since the question didn't specify Express Edition there's really no answer that's completely correct.

+1

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 5

Once again an example of badly phrased question. Makes me think that an option to rephrase or un-publish should be provided.

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 6

+1 to the badly phrased question.

I put none of the above because as with most things with SQL it depends.

With the cost of RAM these days I would never run any computer (let alone one used for SQL) with less than 4GB of RAM, hell my current Dell work machine has 16GB.

paul.knibbs SSCoach Points: 15320 More actions · Answer 7

Yeah, I also put "none of the above" because of the 4Gb recommended minimum for non-Express editions.

kaspencer SSCarpal Tunnel Points: 4880 More actions · Answer 8

What a ridiculous answer!

No edition was stated! If 1Gbyte was correct then so also was 4Gbyte.

I think that once again, the moderators are asleep on the job!

In frustration and annoyance

Kenneth Spencer

You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer

Mike Hays SSCommitted Points: 1871 More actions · Answer 9

If you asked the question: "What is recommended memory requirement for SQL Server 2012?",

why is the link that you provided go to the web page titled "Hardware and Software Requirements for Installing SQL Server 2014"?

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 10

Gotta agree. Without an edition being stated, the answers change. Just saying SQL Server, I would assume the full product, then the minimum is 1gb, but the recommended is 4gb. And you used recommended on purpose to avoid the easy minimums answer.

"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

rupert.hirst SSC Veteran Points: 214 More actions · Answer 11

Hi, its a misleading question - it asks for the recommended amount of memory, not the minimum - so the recommended amount would depend on the application requirements, so none of the above.....

batgirl SSCarpal Tunnel Points: 4979 More actions · Answer 12

Jo Pattyn (11/14/2014)
Could you rephrase it to What is the recommended minimum memory requirement ...?

The way I see it, "requirement" and "recommended" don't belong together.

There is a minimum requirement.

And then there is a minimum recommendation.

gordon.feeney SSC Enthusiast Points: 186 More actions · Answer 13

I'm agreement with others that the question ought to have been 'recommended minimum memory', hence my incorrect answer of 'none of the above'.