Hello,

Appeared two errors to the SQL Server 2014 where I installed the SCOM database.

MSSQL 2014: Page Life Expectancy is too low and MSSQL 2014: Buffer Cache Hit Ratio is too low.

The server in question has 8GB of RAM and only is consuming 60%, the server is a Windows Server 2012 R2 and is completely updated. The version of the SCOM is 2012 R2, and this Server is a fresh install for the SCOM Database.

However I went to check the SQL performance data in question, and the ratio of data is 100 and Page Life Expectancy is 0. The thresholds are the default 0 and 300 respectively.

I don't understand what's happening. Anyone have any idea?

Thank you,
Rui Pinheiro

Hi Sir,

"Checking out the Page Life Expectancy (PLE) counter is a great way to check for memory pressure. A value too low for your system indicates that pages are being flushed from the buffer pool too quickly."

http://timradney.com/2013/03/08/what-is-page-life-expectancy-ple-in-sql-server/

Based on this  , I would suggest you to check the Memory settings of SQL server :

"

• In Object Explorer, right-click a server and select Properties.

• Click the Memory node.

• Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

"

https://msdn.microsoft.com/en-us/library/ms178067.aspx?f=255&MSPPError=-2147217396

Also please try to disable pagefile for SQL server for test .

In addition , you may get further assistance for SQL performance issue from SQL forum:

https://social.technet.microsoft.com/Forums/systemcenter/en-US/home?forum=sqldatabaseengine&filter=alltypes&sort=lastpostdesc

Hope it is helpful to you .

Best Regards,

El