Database Health Check: Operate at Fullest Potential

Posted by Soaring Eagle Consulting on Apr 17, 2019 10:30:00 AM

 

Whether your company runs on Oracle, Microsoft SQL Server, IBM Db2, MySQL, IBM Informix, PostgreSQL, or MongoDB, your database is a complex machine that relies on maintenance to function well. A database health check is essential to identify problematic sections so you can enhance your database in the areas that aren’t operating at their fullest potential.

Read More

Topics: Databases, Storage for DBAs, SQL Server, Extreme Performance, Transformation

IO: Understanding Random vs Sequential

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

 

Read More

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

What could you do if your Storage Infrastructure ran @ the Speed of Memory?

Posted by VIOLIN SYSTEMS on Jul 25, 2013 6:22:43 PM

Suspend disbelief for a moment and ponder the following questions: What would your business look like if we made it economical to run your storage infrastructure at speeds closer to that of memory than that of disk storage? How fast would your applications run? What business models would it open up? How much competitive advantage can you gain?

Read More

Topics: Oracle, database, flash memory, SSD, VDI, SQL Server, Virtualization

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

Flash for Transactional Workloads

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

Transactional workloads are commonly defined as being small atomic pieces of work.  This is in contrast to decision support, Data Warehouse, Business Intelligence or otherwise labeled reporting systems that require fewer, larger, more sequential workloads.  Updates, inserts, deletes and even small result-set selects are all included in OLTP, transactional efforts.

Read More

Topics: OLTP, Oracle, flash, flash storage, SSD, SQL Server, transactional