March 24, 2017 at 10:07 am
Instance is under memory pressure. How to relieve it from pressure
March 24, 2017 at 10:11 am
coolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressure
You need to start by asking a question. This is so incredibly vague there is no possibility of an answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 24, 2017 at 10:38 am
coolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressure
How have you determined that there is a memory pressure, what are the specs of the server, what's running on the server, etc. etc. etc. etc. etc. etc.
😎
March 24, 2017 at 10:40 am
coolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressure
The two most common causes of this are 1) Not enough memory to begin with and 2) a whole lot of bad code.
Let's start with #1. How much memory has been assigned to the instance, how much has been setup for Max Memory in SQL, and how much memory has been reserved for the Operating System? Also, has the memory been "thin provisioned" through a VM or is it permanently provisioned?
--Jeff Moden
March 24, 2017 at 10:58 am
Eirikur Eiriksson - Friday, March 24, 2017 10:38 AMcoolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressureHow have you determined that there is a memory pressure, what are the specs of the server, what's running on the server, etc. etc. etc. etc. etc. etc.
😎
s�B�7���:^ �B
March 24, 2017 at 11:24 am
coolchaitu - Friday, March 24, 2017 10:58 AMEirikur Eiriksson - Friday, March 24, 2017 10:38 AMcoolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressureHow have you determined that there is a memory pressure, what are the specs of the server, what's running on the server, etc. etc. etc. etc. etc. etc.
😎It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes
s�B�7���:^ �B
That is what I see every day on my windows tablet, care to share any more information?
😎
March 24, 2017 at 11:54 am
coolchaitu - Friday, March 24, 2017 10:58 AMEirikur Eiriksson - Friday, March 24, 2017 10:38 AMcoolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressureHow have you determined that there is a memory pressure, what are the specs of the server, what's running on the server, etc. etc. etc. etc. etc. etc.
😎It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes
s�B�7���:^ �B
Care to provide specifics? This would include the configuration of the server or VM, of SQL Server, any other applications or services running on the server/VM. You know, the things everyone else has already asked you to provide.
March 24, 2017 at 12:25 pm
We are back to you needing to ask a question. What that means is you need to provide enough details of your situation that others have a chance at helping you. At this point all we know is you think there is too much memory pressure because "It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes". We don't even know what those values are. Keep in mind we can't see your screen, have no idea what your architecture or hardware is like. The ONLY information we have is what you have posted...and at this point you haven't posted anything resembling details. Look at all the people on this thread trying to pry the details out of you. We all want to help you. But for us to be able to do that requires that you provide us those details. Unless you can do that nobody can do anything to help you.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 24, 2017 at 12:40 pm
Sean Lange - Friday, March 24, 2017 12:25 PMWe are back to you needing to ask a question. What that means is you need to provide enough details of your situation that others have a chance at helping you. At this point all we know is you think there is too much memory pressure because "It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes". We don't even know what those values are. Keep in mind we can't see your screen, have no idea what your architecture or hardware is like. The ONLY information we have is what you have posted...and at this point you haven't posted anything resembling details. Look at all the people on this thread trying to pry the details out of you. We all want to help you. But for us to be able to do that requires that you provide us those details. Unless you can do that nobody can do anything to help you.
Anadin.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
March 24, 2017 at 12:51 pm
ChrisM@home - Friday, March 24, 2017 12:40 PMSean Lange - Friday, March 24, 2017 12:25 PMWe are back to you needing to ask a question. What that means is you need to provide enough details of your situation that others have a chance at helping you. At this point all we know is you think there is too much memory pressure because "It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes". We don't even know what those values are. Keep in mind we can't see your screen, have no idea what your architecture or hardware is like. The ONLY information we have is what you have posted...and at this point you haven't posted anything resembling details. Look at all the people on this thread trying to pry the details out of you. We all want to help you. But for us to be able to do that requires that you provide us those details. Unless you can do that nobody can do anything to help you.Anadin.
LOL. I had to google that to know what is was. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 24, 2017 at 1:38 pm
ChrisM@home - Friday, March 24, 2017 12:40 PMSean Lange - Friday, March 24, 2017 12:25 PMWe are back to you needing to ask a question. What that means is you need to provide enough details of your situation that others have a chance at helping you. At this point all we know is you think there is too much memory pressure because "It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes". We don't even know what those values are. Keep in mind we can't see your screen, have no idea what your architecture or hardware is like. The ONLY information we have is what you have posted...and at this point you haven't posted anything resembling details. Look at all the people on this thread trying to pry the details out of you. We all want to help you. But for us to be able to do that requires that you provide us those details. Unless you can do that nobody can do anything to help you.Anadin.
The English food is questionable, the English clothing challenging but the English humor is superb, Gold on this one mate!
😎
March 24, 2017 at 2:30 pm
coolchaitu - Friday, March 24, 2017 10:58 AMEirikur Eiriksson - Friday, March 24, 2017 10:38 AMcoolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressureHow have you determined that there is a memory pressure, what are the specs of the server, what's running on the server, etc. etc. etc. etc. etc. etc.
😎It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes
s�B�7���:^ �B
Cool.
Low PLE is not enough of a measure. What do you consider to be LOW? When is it low?
Is the memory cycling from highmem avialable to lowmem available on a constant basis?
How is the windows OS behaving? Is it showing signs of memory pressure?
From the information provided so far, you have listed a symptom that may not indicate an issue or even be related to a problem at all.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2017 at 2:53 pm
Jeff Moden - Friday, March 24, 2017 10:40 AMcoolchaitu - Friday, March 24, 2017 10:07 AMInstance is under memory pressure. How to relieve it from pressureThe two most common causes of this are 1) Not enough memory to begin with and 2) a whole lot of bad code.
Let's start with #1. How much memory has been assigned to the instance, how much has been setup for Max Memory in SQL, and how much memory has been reserved for the Operating System? Also, has the memory been "thin provisioned" through a VM or is it permanently provisioned?
While I agree that the question is a bit vague, we can still work on it. We first need answers to my questions above.
--Jeff Moden
March 24, 2017 at 3:21 pm
I believe the real answer to this question is that the user is running maintenance on the instance (based on the "5-day checkdb" thread recently posted). This will cause the observed symptoms.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 24, 2017 at 3:28 pm
SQLRNNR - Friday, March 24, 2017 3:21 PMI believe the real answer to this question is that the user is running maintenance on the instance (based on the "5-day checkdb" thread recently posted). This will cause the observed symptoms.
That would certainly do it.
--Jeff Moden
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply