SAN drives and the transaction logs

Giganews Newsgroups
Subject: SAN drives and the transaction logs
Posted by:  Jay Warmack (JayWarma…@discussions.microsoft.com)
Date: Thu, 9 Nov 2006

In the old days when we have physical disk drives in our SQLServers, we
always located the logs on a seperate volume from the data files for
performance reasons.  In the new era of using SAN storage for the database
files, does it still make sense to use seperate logical SAN drives for the
data and log files?  Or will it make any performance difference for the data
and log files to be on the same SAN drive since we don't know where the data
is really physically going 'under the covers' of the SAN technology?

Replies