Server 2008 R2 Memory Usage

I seem to get serious performance issues with applications accessing a SQL Server.

I was trying to determine the cause and I found that the memory usage on the system was 14.5

Amazingly there is only 8 GB of ram installed.  Does that mean that there is 6GB of paged memory??

We have people here who are using Access and linking to SQL databases to do custom queries etc.

When two or three of these individuals have access open at the same time are all their mappings etc for access mapped in the memory of the SQL Server?  If so then I can understand the great overrun on physical Memory.
Larry RungrenDirector of TechnologyAsked:
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.

Adam Andersoninfrastructure consultantCommented:
Have you made any changes to sql instance server memory options? When you right click on the sql instance then click on properties, Then select memory in here you can set the allowed memory min-max for that instance. Rather than leaving SQL to use all available memory from the server.
Peter HutchisonSenior Network Systems SpecialistCommented:
Paged memory is usually managed by the system itself, but if you set it, it should be approx.
paged memory = total memory x 1.25.

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
Larry RungrenDirector of TechnologyAuthor Commented:
Made the correction to config an there is joy in Mudville
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.