SQL Server disk design on an ISCSI SAN
Logs and data drives have different data access patterns that are in conflict with each other (at least in theory) when they share a drive. Log Writes Log access consists of a very large number of small sequential writes. Somewhat simplistically, DB logs are ring buffers containing a list of instructions to write data items … Read more