A quick performance comparison of server side paging in SQL Server 2012, split into two tests, with a focus on the unnecessary IO reads that make paging costly.
SQL SERVER – Server Side Paging in SQL Server 2012 – A Better Alternative
Server side paging in SQL Server 2012 is simpler with OFFSET and FETCH NEXT. I compare it with the older ROW_NUMBER and OVER method from SQL Server 2005/2008.
SQL SERVER – What is Page Life Expectancy (PLE) Counter
What is Page Life Expectancy (PLE)? A quick query to read it from sys.dm_os_performance_counters, the recommended minimum of 300 seconds, and what it means.
SQL SERVER – Finding Memory Pressure – External and Internal
A quick query to find external and internal memory pressure in SQL Server and see how much memory each memory type is using right now.
Page Density: The Fragmentation Number That Actually Slows Scans
Measure page density and fragmentation, compare scan reads around a test rebuild, and choose fill factor using workload evidence.
When Auto Update Statistics Is Not Enough
Auto update statistics can miss important data patterns; inspect thresholds, ascending keys, sampling, and targeted update schedules.
Replaying a Production Workload After Distributed Replay
Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.