THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » testing » Storage   (RSS)
Showing page 2 of 2 (15 total posts)
  • How did Random I/Os Outperform Sequential I/Os?

    Recently, when I was doing some I/O performance tests on an I/O path, I found that 8K random reads (and writes) significantly and consistently outperformed 8K sequential reads (and writes) in terms of I/O throughput (megabytes per second). I was puzzled. With a traditional hard disk that is made up of a stack of magnetic platters held by a ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on April 4, 2007
  • SQL Server Backup I/O Performance

    I had always thought that: SQL Server backup reads/writes sequentially, and SQL Server backup could fully utilize the throughput of the I/O path But I'm no longer so sure. Recently, I was doing some benchmark work on two I/O paths, and had the following numbers from pure I/O tests with sqlio.exe: Drive E:  ~200MB/sec for both ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on March 30, 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
  • Performance Impact of Disk Misalignment

    Just google for Windows disk alignment best practice, and you would find thousands of articles, whitepapers, and posts, all preaching the practice of aligning disk partitions on the 64K boundary. For instance, one of the EMC recommendations prescribes a disk alignment value of 64K for the host file systems when deploying SQL Server 2005. Microsoft ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 1, 2007
  • Beware of Shifting SAN

    Let’s say you are trying to determine the performance impact of a neat database design change you have just devised on an application. So you run some tests with the existing design and the tests run for several hours. Coming back the next day, you make the change and re-run the same tests. The test results look fantastic. Now, before you ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 3, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement