We have Production server win 2003 with Sql server 2008 running on it.
We have performance issue for a database which application is running very slow.
Can any one clarify whether Page Life Expectancy value will effect the performance.?
when i checked Page Life Expectancy with below command on the sql server insatnce the
PLE value is 9 which is below 300.
SELECT cntr_value AS [Page Life Expectancy]
WHERE OBJECT_NAME = N'SQLServer:Buffer Manager'
AND counter_name = N'Page life expectancy'
Can any one calrify if we increase the Ram from 4 GB to 16 GB will it decrease the memroy pressure.
Please suggest what will best suggestion to do........