November 16, 2015 at 2:38 pm
Page Life Expectancy of SQL instance "MSSQLSERVER" on computer "computername" is too low. See "alert context" tab for more details.
How can I fix this issue?
November 16, 2015 at 2:54 pm
That is a very vague question. There isn't a "one" type solution for this. Not sure where you got that warning message from, i would set up perfmon @15 secs sampling for peak business hours and see if PLE is really low. Old school standard was 30 , these RAM is much cheaper i typically get concerned if it gets less than 1800 ( 30 mins). If you feel PLE is low, you could add more RAM to give a lift, other way would be to identifying queries which are using up resources.
How much is the RAM assigned to SQL instance ( this is probably the first question i should have asked 🙂 )
November 17, 2015 at 2:01 am
Firstly, there is no case where a single perfmon counter tells you what to do. See chapter 1 of https://www.red-gate.com/community/books/accidental-dba
Sustained low page life expectancy suggests that you may have memory pressure, see chapter 4 of the book referenced above.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2015 at 8:59 am
Thank you! There is 8GB of memory allocated to the server.
sa
November 17, 2015 at 10:35 am
My laptop's got more than that...
Seriously though, read the two chapters of the book that I recommended. Problems are not identified with a single counter value or setting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2015 at 11:42 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply