Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Memory Pressure


Memory Pressure

Author
Message
bala2
bala2
SSC Veteran
SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)

Group: General Forum Members
Points: 283 Visits: 1046
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,
menon.satyen
menon.satyen
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 230
Hi,

Yes it shows that it might be insufficient on memory.

but decisions cannot be taken on only one counter alone.

you might also have to check counters like available bytes/sec, %usage for paging file.
Jack Vamvas
Jack Vamvas
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 329
Focus on consistency - is the PLE consistently low?
Have you checked for missing indexes, updated statistics?
Try and establish why there is memory pressure.

Increasing physical memory will alleviate pressure , but you may just run into the same problems again

Jack Vamvas
sqlserver-dba.com
CapnHector
CapnHector
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 1789
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 faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2
TheSQLGuru
TheSQLGuru
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 6000 Visits: 8314
Increasing RAM from 4 to 16GB will only help if a) you have an edition of windows/SQL Server that can support that much and b) if 32 bit you configure various things properly for the memory above 4GB to be used.

Having said that, extra memory will still only REALLY help performance if you have either a small database that can sit in the larger memory or you have sufficient IO bandwidth to keep pages flowing into the buffer pool quickly. Almost all implementations I have come across in many years of consulting have a big win from quadrupling their RAM though!! :-)

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
bala2
bala2
SSC Veteran
SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)SSC Veteran (283 reputation)

Group: General Forum Members
Points: 283 Visits: 1046
THanks for reply,

update stastics has been updated upto date.
i have checked fragmentation and are fine...
Can you tell me how to find the missing indexes for high usage tables....
Jack Vamvas
Jack Vamvas
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 329
One method to use is to study the Execution Plans of the queries .Analyse the code - for example, is it forcing a table scan - where that may not be necessary.

Jack Vamvas
sqlserver-dba.com
menon.satyen
menon.satyen
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 230
Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/
CapnHector
CapnHector
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 1789
menon.satyen (11/2/2012)
Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/


Careful with the missing index DMV's. it may suggest 2 indexes with slight differences that could be accomplished with one index. they are a good guide but not the be all end all of index planning.

Here is a good article on index planning and gail has many more at the same blog.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/


For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search