Pages

Sunday, September 1, 2013

SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28 | Journey to SQL Authority with Pinal Dave

For any good system three things are vital: CPU, Memory and IO (disk). Among these three, IO is the most crucial factor of SQL Server. Looking at real-world cases, I do not see IT people upgrading CPU and Memory frequently. However, the disk is often upgraded for either improving the space, speed or throughput. Today… Continue Reading...

Source: SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28 | Journey to SQL Authority with Pinal Dave