InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 05:35:01 GMT20http://www.sqlservercentral.com/Forums/Topic1428511-1292-1.aspxYes. Optimise queries, tune indexes.Mon, 11 Mar 2013 03:14:05 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1428511-1292-1.aspxThanks OPCDuring times of the low PLE - I am noticing some nasty selects coming through. I suppose my next move is to try and optimize the queries ?ThanksMon, 11 Mar 2013 00:24:31 GMTSQLSACThttp://www.sqlservercentral.com/Forums/Topic1428511-1292-1.aspxWhy BCHR doesn't normally matter: [u][url=https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/]https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/[/url][/u]As for PLE drops, you can trace for queries running when the PLE bottoms out to figure what is happening in the database when it drops. Many times it's a nasty select for a report that requires a ton of data which displaces a large percentage of the buffer pool. You can also look for external pressure, i.e. memory set trims imposed on SQL Server by Windows. You can find notices for those in the SQL Error Log.Fri, 08 Mar 2013 15:13:07 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1428511-1292-1.aspxHi AllOn one of my SQL Servers, I am noticing what I think is memory pressurePLE is +-100Buffer Cache Hit Ratio is 99%I would think that with a low PLE comes a low Buffer Cache Hit Ratio??I am noticing PAGEIOLATCH waits on top of my wait_stats list - I'm assuming that this ties into the low PLE.Server: SQL 2008 ENT on Windows 2008 ENTMemory: Server memory - 50GB, Memory allocated to SQL - 42GBLocked pages in memory is setI have had some user complaints about performanceWhat is the recommended method to approach thisThanksFri, 08 Mar 2013 04:33:56 GMTSQLSACT