Solved

How to read the memory consumption page in SQL server

Posted on 2015-02-13
4
302 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 45

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 45

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 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

17 Experts available now in Live!

Get 1:1 Help Now