Solved

How to read the memory consumption page in SQL server

Posted on 2015-02-13
4
307 Views
Last Modified: 2015-02-19
Hi,

I generated memory consumption page using SQL server default statistics report.

Kindly some one give me about what is these stats and how that impact the resources base on this report.

eg. is there any issue with memory usage by the current process
Memory-Consumption---14022015-1203-AM---
0
Comment
Question by:ken hanse
  • 2
4 Comments
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40616495
Which type of file did you post? I can't open it.
0
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 40616668
(Quiet whispers from the wings: "The file appears to be a pdf.  (Adobe Acrobat) Don't mind me.  I'm just here, 'cause I'd love to see an answer too.")
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40618826
Can't explain everything because I don't know all the stats. Will focus only in what I think is more important:
Page life expectancy - "“Number of seconds a page will stay in the buffer pool without references”:So, a bigger the number, better. Means that your pages stays longer in the buffer. In you case 81396 seconds / 60 seconds = 1356.6 minutes. For sure you wasn't facing a memory pressure here. For example, a value of 300 is 5 minutes (300/60).
Memory Grants - 5 process acquired memory and 2 still in Pending state. You may have locking problems here.
Top Memory Consuming Components - This graph shows the components that are consuming more memory and OBJECTSTORE_LOCK_MANAGER is on the top. So, I think you really facing locking issues.

Can't say much more because I usually don't use the reports for checking the SQL Server memory usage.
Only a call of attention for your SQL Server memory configuration. It's 16GB reserved for it and it's using around 5GB. If it's a 16GB RAM machine you should let some free memory for the OS, so configure the max server memory and don't let it with the default value (2TB) that means consume all available memory.
0
 

Author Comment

by:ken hanse
ID: 40619878
That helps. Thank you.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now