BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Thursday, November 20, 2008

SQL Server News & Information

tsql, performance tuning, industry trends, & bad jokes

exec spSubscribeMinimize
Print  
sp_help 'jmassie'Minimize

This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.

You can contact him at jason@statisticsio.com or 469.569.5965

Jason has the following certifications:
  • Microsoft Certified IT Professional Database Administrator (early adopter)
  • Microsoft Certified IT Professional Database Developer
  • MCDBA (7.0 and 2000)
  • MCSE
  • MCSD
Print  
tblTagCloudMinimize

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless

Print  

"Disks are dead, they just don’t know it yet"

Posted by Jason on Saturday, July 26, 2008 to SSD, hardware
351 Views | 3 Comments | Article Rating

I have been drooling over following Texas Memory Systems for a couples years and more recently, BitMicro.

I am not comparing the products that the companies sell because they are different products and the measurements are not the same. These bullets are mainly for drool factor and background for a post that I will refer you too.

Ā 

Texas Memory Systems:

RamSan-400 SSD SAN

  • The World's Fastest StorageĀ®

  • First solid state disk with 4Gb Fibre Channel interfaces.

  • First solid state disk with 4x InfiniBand interfaces.

  • Over 400,000 random I/Os per second.

  • 3000 MB/s random sustained external throughput.

  • Full array of hardware redundancy to ensure availability.

Ā 

BitMicro:

E-DiskĀ® Altimaā„¢ 4Gb Fibre Channel 3.5" Solid State Drive

  • Up to 640GB of storage per disk on 1" drives.
  • 1.6TB on 3.5" drives
  • 800 MB/sec Full Duplex Burst Rate
  • Up to 55,000 IOPS I/O Rate
  • Similar offering on u320 SCSI

Now these are numbers from the manufacturers. Lots of missing info like read\write numbers. Numbers for different sizes of reads and writes etc. However, did I say WOW?

I am making this post because I ran across a blog post by Mike Ault on a FriendFeed conversation.

Mike address's these SSD "lies"

1. Solid state drive technology is very expensive
2. Solid state devices are best when directly attached to the internal bus architecture
3. Solid state drives will only be niche players
4. You can get the same IO rate from disks as from SSD

and he ends with this quote:

I am not afraid to say it: SSD technology is here, it is ready for prime time and it is only a matter of time before disks are relegated to second tier storage. Disks are dead, they just don’t know it yet.

We can only hope so :) I highly recommend reading the whole posts here.

I hope Microsoft is watching this technology. Sure, SQL will like a SSD SAN right now but I bet it could be heavily be optimized to run on SSD.

Ā 

edit: link fixed

email it! |   |   |   |  | 
Permalink     3 Comments  

Rate this Post:
COMMENTS:

I just hope they are affordable and in place for laptops by the time I'm ready to buy one next spring. That 640GB would do nicely in a new thinkpad next spring.

Snap! Sudden thought. Since it's all sold state, you wouldn't have the issues running virtual machines off of them as with disks, so a vm running off the same drive as the OS should, in theory, be quite fast.

Sweet.

posted @ Saturday, July 26, 2008 12:18 AM by Arcane Code


Can you fix the "whole post here" link? It does not seem to work and I am interested in reading the information.
Thanks

posted @ Saturday, July 26, 2008 12:23 AM by Jeremiah Clark


ArcaneCode - keep in mind that both VMware and Hyper-V still only support one HBA per lun per guest OS max, so you still have SAN I/O bandwidth problems on big databases like data warehouses, or anything else that would normally use SAN multipathing. Using SSDs reduces the random access problem, but not the bandwidth problem. I'm eagerly awaiting VMware's eventual fix for that.

posted @ Sunday, July 27, 2008 6:13 AM by Brent Ozar


Name (required)

Email (required)

Website


Simple BBCode can be used like [URL]...[/URL] and [B]

Copyright 2006 by Statistics IO, My SQL Server Blog