Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Memory Pressure
Add to briefcase

Memory Pressure Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
bala2
Posted Tuesday, October 30, 2012 6:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:47 AM
Points: 188, Visits: 627
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,
Post #1378726
menon.satyen
Posted Tuesday, October 30, 2012 9:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:12 AM
Points: 25, Visits: 111
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.
Post #1378848
Jack Vamvas
Posted Tuesday, October 30, 2012 9:44 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:36 PM
Points: 24, Visits: 240
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
Post #1378860
CapnHector
Posted Tuesday, October 30, 2012 3:10 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:07 AM
Points: 935, Visits: 1,709
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

Jeremy Oursler
Post #1379047
TheSQLGuru
Posted Wednesday, October 31, 2012 8:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:50 AM
Points: 3,572, Visits: 5,106
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
Post #1379366
bala2
Posted Friday, November 02, 2012 9:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 7:47 AM
Points: 188, Visits: 627
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....
Post #1380430
Jack Vamvas
Posted Friday, November 02, 2012 9:16 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:36 PM
Points: 24, Visits: 240
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
Post #1380441
menon.satyen
Posted Friday, November 02, 2012 11:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:12 AM
Points: 25, Visits: 111
Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/
Post #1380523
CapnHector
Posted Friday, November 02, 2012 11:34 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:07 AM
Points: 935, Visits: 1,709
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

Jeremy Oursler
Post #1380530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.