?
Solved

How to read the memory consumption page in SQL server

Posted on 2015-02-13
4
Medium Priority
?
370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 51

Expert Comment

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

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 51

Accepted Solution

by:
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.
0
 

Author Comment

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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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. …
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Suggested Courses

777 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