Choosing the Right Storage for SQL Server
Storage performance is key to the health and performance of a SQL Server database. When storage performance begins to slow down, queries suffer from more waits on disk. These waits can show up as a variety of SQL Server wait types, including WRITELOG and wait types starting with PAGEIOLATCH.