Say Goodbye to Hard Disk Drives: Why Your SQL Server Needs an All-Flash Array

Posted by VIOLIN SYSTEMS on Sep 14, 2020 8:00:00 AM

More and more organizations are choosing structured query language servers to power their databases. Why?

Read More

Topics: MySQL, flash storage, Technology Trends, Extreme Performance, cost savings

IO: Understanding Random vs Sequential

Posted by VIOLIN SYSTEMS on Aug 15, 2018 10:59:13 AM

Storage for DBAs:

Ever been to one of those sushi restaurants where the food comes round in dishes on a conveyor belt?

Read More

Topics: IO Randomization, MySQL, IO scheduling, Storage for DBAs, SQL Server, Extreme Performance

Modernizing vs Revolutionizing

Posted by VIOLIN SYSTEMS on Apr 26, 2013 12:41:20 PM

SSD’s are like cordless phones and DVD’s.  They made an improvement on an existing technology but didn’t revolutionize its use.  In technology there is a difference between the concept of modernizing and revolutionizing.  Modernizing is finding a way to do the same thing, just a little bit faster or little bit easier.  Revolutionizing is either eliminating or vastly changing how something is done.

Read More

Topics: MySQL, OLTP, Oracle, database, flash, flash storage, reporting, SSD, Sybase, SQL Server, storage architecture, transactional, Virtualization

Why is flash good for data warehousing?

Posted by VIOLIN SYSTEMS on Apr 26, 2013 12:41:10 PM

Flash is about latency and IOPs so why would it be good for Data Warehousing or Business Intelligence?

Excellent question.  Yes, the typical marketing and wow-factor stats around flash are based on latencies and IOPs (Input Output Per Second).  Data warehousing (DW) and Business Intelligence (BI) is normally a throughput game, so what gives?

Read More

Topics: MySQL, Oracle, BI, Big Data, Business Analytics, Business Intelligence, data warehouse, database, ETL, flash, flash storage, reporting, SSD, Sybase, SQL Server