THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » Best Practices » SAN   (RSS)
  • SQL Server and SANs: The QueueDepth Setting of a Host Bus Adapter (HBA)

    Too many DBAs tend to view a drive presented from a Storage Area Network (SAN) as something of a monolithic nature. They look at the drive as if it had some intrinsic performance characteristics. This view doesn't help one appreciate the true performance characteristics of such a drive. A more constructive view is to look at the drive as an I/O ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on September 18, 2007
  • Should I Use a Windows Striped Volume?

    In Windows Server 2003, you can use the Disk Management console to create a striped volume over multiple dynamic disks (well, you can also create a mirrored, a RAID-5 volume, etc). If these disks (or LUNs) are presented from a SAN, most likely you can stripe across the same storage devices--making up these LUNs--inside the SAN to present ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on March 12, 2007
  • Is RAID 5 Really That Bad?

    RAID 5 is a dirty word in the DBA community and beyond. There are websites devoted to trash RAID 5. I've seen DBAs declaring performance root cause found the very moment they found out that some database files were placed on RAID 5 volumes. You'd be ridiculed and run out of town if you dare to suggest putting the transaction log file on RAID ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 7, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement