Product has been added to your cart.

1.2 How to Fix PAGEIOLATCH Waits

PAGEIOLATCH waits mean reading data pages from a data file. The 4 most common ways of tuning it, in order, are: Tune indexes Tune queries Add more memory Make storage faster Demo Code /* Restart the SQL Server, then: */ EXEC sys.sp_configure N’show advanced’, 1; RECONFIGURE; GO EXEC sys.sp_configure N’max server memory (MB)’, N’1024′; EXEC…

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Server Tuning with Wait Stats
  7. 1.2 How to Fix PAGEIOLATCH Waits
PAGEIOLATCH waits mean reading data pages from a data file. The 4 most common ways of tuning it, in order, are: Tune indexes Tune queries Add more memory Make storage faster Demo Code /* Restart the SQL Server, then: */ EXEC sys.sp_configure N'show advanced', 1; RECONFIGURE; GO EXEC sys.sp_configure N'max server memory (MB)', N'1024'; EXEC...
To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.