August 2006 - Posts

• PLE - Discussion in the new 64-bit World

  On 32-bit systems, generally we did not sound alarm bells if PLE (Page Life Expectancy) was above 300 seconds (5 minutes). As I have been working more and more with 64-bit systems, I catch myself wondering if there is a different "benchmark" for PLE on Read More... Posted Sunday, August 27, 2006 7:26 AM by RickHeiges | 1 Comments

• Table and Index Partitioning - in Compatibility Mode???

  Table and Index Partitioning in SQL Server 2005 is one if the neatest management features. It allows you to slice up a large table and its associated indexes into more manageable chunks. This is clearly a 2005 feature. I saw a post on SQLServerCentral.com Read More... Posted Thursday, August 10, 2006 5:55 AM by RickHeiges | 0 Comments