THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Storage   (RSS)
Showing page 2 of 4 (36 total posts)
  • Solid-State Storage

    After years of anticipation and false starts, the SSD is finally ready to take a feature role in database server storage. There were false starts because NAND flash is very different from hard disks and cannot be simply dropped into a storage device and infrastructure built around hard disk characteristics. Too many simple(ton) people became ...
    Posted to Joe Chang (Weblog) by jchang on October 25, 2010
  • IO Queue Depth Strategy

    I am finally getting around to setting up a SSD array, starting with a few, then working up to perhaps 20 units over 2 controllers and 4 x4 SAS ports. During initial testing I observed very high disk latency, in the range of 100ms+ for reads and upto 400ms+ for writes in certain operations. This occurs during periods of exceptionally high disk ...
    Posted to Joe Chang (Weblog) by jchang on October 18, 2010
  • Caching RAID Controller Performance Tuning Secrets (cough-giggle)

    Over weekend I was looking at various RAID controller documents to update my material on storage performance, and I came across three items that were good for a hoot. Direct IO, not Cached IO The LSI slidedeck MegaRAID Performance Tuning and Benchmark Tips states that Direct IO is the correct setting on RAID controllers. ''All read data ...
    Posted to Joe Chang (Weblog) by jchang on October 11, 2010
  • Big-Iron Revival III

    Revenge, Return of Big Iron. In the old days, standard server systems did not have the power to run large enterprises, hence there were vendors that built really big servers. However it became apparent if not widely publicized that there were serious technical challenges scaling up on big iron systems. (Many of these difficulties have since ...
    Posted to Joe Chang (Weblog) by jchang on September 24, 2010
  • Speaking in Raleigh NC June 15th

    Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below: SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 2, 2010
  • Storage Configuration

    Storage performance is not inherently a complicated subject. The concepts are relatively simple. In fact, scaling storage performance is far easier compared with the difficulties encounters in scaling processor performance in NUMA systems. Storage performance is achieved by properly distributing IO over: 1) multiple independent PCI-E ports ...
    Posted to Joe Chang (Weblog) by jchang on April 4, 2010
  • Data, Log and Temp file placement

    First, especially for all the people with SAN storage, drive letters are of no consequence. What matters is the actual physical disk layout behind each RAID Group or LUN. Forget capacity, pay attention to the number of spindles supporting each RAID group. While there is nothing wrong with making 2 or more LUNs from the same set of disks, I prefer ...
    Posted to Joe Chang (Weblog) by jchang on March 23, 2010
  • Geek City: More About Nonclustered Index Keys

    I thought I had said almost all that could be said about nonclustered index keys in a post made almost exactly two years ago, on March 16, 2008.  But there's more. To get all the benefit from today's post, you'll really have to read that one, but I'll synthesize the crucial details here. Every index needs to be unique, in some way or ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 7, 2010
  • SQL 2008 R2 Enhancement

      The additions or changes in SQL Server 2008 R2 are mostly BI related but there is one I just became aware of that serves a more general purpose but at the same time is fundamental in how the storage engine works related to locking.  I won’t rehash (pun intended) what Sunil Agarwal wrote in the below listed blog but in a nut shell they ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 1, 2010
  • HP Storage Works 2000 sa and fc G2 performance specs

    While reading through the documentation for the HP Storage Works 2000 MSA, I found the following performance numbers cited in the quickspecs for both the FC and SAS versions. The 2000fc version cited performance numbers for the fc (Fiber Channel), sa (SAS) and i (iSCSI) models. The 2000sa version only cites SAS results. The MSA 2000 Technical ...
    Posted to Joe Chang (Weblog) by jchang on September 14, 2009
Privacy Statement