troubleshooting Question

sQL 2008 R2 Windows 2008 R2 Memory issues

Avatar of Amanda Walshaw
Amanda WalshawFlag for Australia asked on
Microsoft SQL ServerMicrosoft SQL Server 2008Windows Server 2008
3 Comments3 Solutions598 ViewsLast Modified:
I have a QA server running SQL 2008 R2 on Windows 2008 Server, 16gb of physical memory was installed, only 3-4 users are using the server via an application quering sql server database and sql is taking up all the memory.  No other databases or application is installed on this server.  

I have configured the memory down to 5gb in SQL memory settings, was ok for a day then the SQL took up all the physical memory, paging file increased and cache did.  spoke with several DBAs we have reconfigured the memory settings to 13gb we are no using.


For Windows Performance Monitor on this server I have set up the following counters  as first port of call

Memory Object – Cache Byes counter for the system working set
-      Pool Nonpaged Bytes counter for size of unpaged pool
-      Available Bytes Counter
-      Modified Page List Bytes counter

We have not enabled AWE memory settings

I have read the various blogs on sql and memory.  I am not convinced that the DBAs answer of setting 13gb of memory will work.

I need to rule out SQL, I need to rule out the Web tool calling on sQL, I need to confirm if windows 2008 is at fault, it is a 64 bit operating system 4 processors 2.67 GHz.
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros