How to read the memory consumption page in SQL server

Posted on 2015-02-13
Medium Priority
Last Modified: 2015-02-19

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
Question by:ken hanse
  • 2
LVL 54

Expert Comment

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

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.")
LVL 54

Accepted Solution

Vitor Montalvão earned 2000 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.

Author Comment

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

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 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