How can we set the Maximum ram for SQL Server 2008 R2

Hi Experts
How can we set the maximum ram for SQL Server 2008 R2?
Is it in the settings?  How do I do this?  

Thanks in advance.  
mrotor
mainrotorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
By default each SQL Server instance is using all the available RAM in the server.

To change the memory configuration, go to SSMS and right-click on the instance name and chose Properties, then Memory. You'll be able to set the new values. No restart is needed.
ServerMemory.PNG
mainrotorAuthor Commented:
Is it common for SQL Server to use 40% to 50% of CPU?
it_saigeDeveloperCommented:
To set a fixed amount of memory


1.In Object Explorer, right-click a server and select Properties.


2.Click the Memory node.


3.Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

Use the default settings to allow SQL Server to change its memory requirements dynamically based on available system resources. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647 megabytes (MB). The minimum amount of memory you can specify for max server memory is 16 MB.
Source
-saige-

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Is it common for SQL Server to use 40% to 50% of CPU?
Depends. There's no rule.
How many processors exists? How many of them are configured to SQL Server use? How are the other resources (Memory, disk, network)? What kind of operations are on the database? How many concurrent connections?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Wondering what the accepted solution has different than mine, specially because the words aren't even from the Expert who posted it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.