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 » Performance » Storage   (RSS)
Showing page 1 of 2 (14 total posts)
  • Storage Performance

    Storage has changed dramatically over the last three years driven by SSD developments. Most of the key components necessary for a powerful storage system are available and the cost is highly favorable for direct placement of data files. Some additional infrastructure elements could greatly enhance the flexibility of storage systems with ...
    Posted to Joe Chang (Weblog) by jchang on March 24, 2013
  • Consumer SSDs with SQL Server

    Over the last two years, I have stood up several proof-of-concept (POC) database server systems with consumer grade SSD storage at cost $2-4K per TB. Of course production servers are on enterprise class SSD, Fusion-IO and others, typically $25K+ per TB. (There are some special situations where it is viable to deploy a pair ...
    Posted to Joe Chang (Weblog) by jchang on September 16, 2011
  • 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
  • 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
  • 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
  • Solid State Drive versus Memory, TPC-H Nehalem

    A recently published TPC-H benchmark result, along with previously published results provide some insight into to the relative impact of SSD to disk drives, and SSD versus system memory. The TPC-H configurations are shown below. All results are at SF 100. The first two are on Windows Server 2003 sp1, and SQL Server 2005 sp1 and sp2 ...
    Posted to Joe Chang (Weblog) by jchang on August 12, 2009
  • HP Oracle 10X Extreme Performance Data Warehouse with Exadata Storage Server

    For several months, we have seen ads for the joint HP/Oracle RAC and Exadata storage combination talking about extreme performance (10X faster) for large data warehouses. One thing I like about Oracle is that they have courage to pursue technology with deep hardware design implications, even if it takes several iterations to iron out the major ...
    Posted to Joe Chang (Weblog) by jchang on June 9, 2009
  • SQL Server Fast Track Data Warehouse

    This came out on the Microsoft website. I have not had time to look over the hardware configuration carefully. Of course the recommended storage is a SAN, vendors love to sell very high margin products when there are perfectly good merely high margin alternatives. Well atleast this one looked at sequential disk IO bandwidth, unlike past ...
    Posted to Joe Chang (Weblog) by jchang on February 24, 2009
  • Dell PERC6 RAID Controller Performance

    Last month, Scott pointed out the really bad performance characteristics of the Dell PERC6 in RAID0 sequential write, particularly compared with RAID-5. Granted, this is not necessarily a red flag because few people use RAID 0 in production. Still, if one can't write code or test correctly, one should not be in the hardware/firmware business. Dell ...
    Posted to Joe Chang (Weblog) by jchang on October 1, 2008
  • Brains still matter - silly SSD notions

    Everytime a good product comes out, people seem to contrive bad ideas for what can be replaced, usually brains, or people with brains, or that people lacking brains can accomplish something on their own. Let me put it simply. Suppose one had a query that uses a nonclustered index, and required a key lookup, and the key lookup required a disk ...
    Posted to Joe Chang (Weblog) by jchang on September 8, 2008
1 2 Next >
Privacy Statement