bala2 (10/30/2012)
Hi,We have Production server win 2003 with Sql server 2008 running on it.
Ram --4GB.
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]
FROM sys.dm_os_performance_counters
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........
Many THanks,
the emphasis above is mine. the question on my mind is any thing else running on the server or just sql server. i would look at upgrading the ram if you are paging allot to disk.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]