SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
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
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
I am in a what feels like a whirl wind tour of the globe so content may be light this week. Jetlagged in Denmark right now and should seriously be asleep. I have some interesting topics in the works but until then I have "suggested reading" at several places.
FriendFeed:
http://friendfeed.com/statisticsio
Google Reader Shared Items:
http://www.google.com/reader/shared/09956560379006770135
Facebook:
http://www.facebook.com/profile.php?id=1013730310&ref=profile
Google reader is probably the most SQL focused link. The others have google reader shares + stuff. If you are reading this, chances are you will find what I find cool at least slightly interesting as well.
Found this while reading the SSD article on intel's new laptop SSD. The game is going to change and it is going to change fast. Hell, I might go buy some intel stock!
A beach tip from a cousin in law that works at EMC. Here is the press release. I am not going to go into a lot of txt but this is the tipping point. Get ready for a wild ride. Soon 1GB network connections won't be enough! Related posts: SSD
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
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 expensive2. Solid state devices are best when directly attached to the internal bus architecture3. Solid state drives will only be niche players4. 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
This stuff is really going to change SQL. Heck, it is going to change computing.
BiTMICRO to Deliver 3.5-inch 4Gbit Fibre Channel Flash Solid State Drive with up to 1.6 TB Capacity and Robust Storage Performance for High-Performance Computing Applications Latest 3.5-inch E-Disk Altima 4Gb FC solid state drive model promises to grab the attention of the military, scientific, industrial and enterprise markets by delivering unprecedented solid state drive performance with sustained rates of more than 230 MB/s, over 55,000 IOPS and with capacities of up to 1.6TB of pure non-volatile solid state storage
BiTMICRO to Deliver 3.5-inch 4Gbit Fibre Channel Flash Solid State Drive with up to 1.6 TB Capacity and Robust Storage Performance for High-Performance Computing Applications
Latest 3.5-inch E-Disk Altima 4Gb FC solid state drive model promises to grab the attention of the military, scientific, industrial and enterprise markets by delivering unprecedented solid state drive performance with sustained rates of more than 230 MB/s, over 55,000 IOPS and with capacities of up to 1.6TB of pure non-volatile solid state storage
Let's not even consider all of the theoretical changes in SQL Server that will need to be made once this hardware catches on. Let's imagine a RAID 0 array with 10 disks on SQL 2005. That is 2.2GB/s not to mention 16TB of storage in a very small area. Maybe even internal to the server. On top of that, I suspect that the power footprint is much smaller than the current 16TB solutions out there.
The full press release is here.