How much Ram required.

Question

Post reply

How much Ram required.

Minnu

SSCertifiable

Points: 6451
More actions
June 25, 2013 at 9:33 am

#279521

Hi Team,
I've installed sql server standard edition 2008R2, and my database size is 30GB, Harddisk is : 500GB,
How much of RAM is required to overcome High physical memory utilisation issue.
please suggest..!

Viewing 5 posts - 1 through 4 (of 4 total)

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

Abu Dina SSChampion Points: 14155 More actions · Answer 1

Minnu (6/25/2013)
How much of RAM is required to overcome High physical memory utilisation issue.

What do you mean?!

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Lowell SSC Guru Points: 323506 More actions · Answer 2

i don't think there is a hard and fast rule you can just say, it depends on the data and how often it gets accessed;

SQL will use all the RAM you give it; for example, if the server had enough RAM, it might slowly put the whole 30 gig database in RAM,

If it's a 30 gig Archived database that rarely gets accessed, all the RAM could be used elsewhere.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Abu Dina SSChampion Points: 14155 More actions · Answer 3

Was going to say that in an ideal world you'd host all your databases in memory but as you say it depends.

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

SQL Guy 1 SSCoach Points: 15974 More actions · Answer 4

It sounds like your home PC. And apparently not SQL Server experiences the issue with memory, but your other apps running on same machine.

SQL Server will grab nearly all RAM on your PC. Try to play with Max Server memory in SQL Server.