Condusiv Technologies Blog

Condusiv Technologies Blog

Blogging @Condusiv

The Condusiv blog shares insight into the issues surrounding system and application performance—and how I/O optimization software is breaking new ground in solving those issues.

University of Illinois Doubles SQL and Oracle Performance on All-Flash Arrays with V-locity® I/O Reduction Software

by Brian Morin 19. May 2017 11:00

The University of Illinois, had already deployed an all-flash Dell Compellent storage array to support their hardest hitting application, AssetWorks AiM, that runs on Oracle. After a year in service, performance began to erode due to growth in users and overall workload. Other hard hitting MS-SQL applications supported by hybrid arrays were suffering performance degradation as well.

The one common denominator is that all these applications ran on Windows servers – Windows Server 2012R2.

“As we learned through this exercise with Condusiv’s V-locity I/O reduction software, we were getting hit really hard by thousands of excessively small, tiny writes and reads that dampened performance significantly,” said Greg Landes, Manager of Systems Services. “Everything was just slower due to Windows Server write inefficiencies that break writes down to be much smaller than they need to be, and forces the all-flash SAN to process far more I/O operations than necessary for any given workload.”

Landes continued, “When you have a dump truck but are only filling it a shovelful at a time before sending it on, you’re not getting near the payload you should get with each trip. That’s the exact effect we were getting with a surplus of unnecessarily small, fractured writes and subsequent reads, and it was really hurting our storage performance, even though we had a really fast ‘dump truck.’ We had no idea how much this was hurting us until we tried V-locity to address the root-cause problem to get more payload with every write. When you no longer have to process three small, fractured writes for something that only needs one write and a single I/O operation, everything is just faster.”

When testing the before-and-after effect on their production system, Greg and his team first measured without V-locity. It took 4 hours and 3 minutes to process 1.57TB of data, requiring 13,910,568 I/O operations from storage. After V-locity, the same system processed 2.1TB of data in 1 hour and 6 minutes, while only needing to process 2,702,479 I/O operations from underlying storage. “We processed half a terabyte more in a quarter of the time,” said Landes.

“Not only did V-locity dramatically help our write-heavy MS-SQL and Oracle Servers by increasing performance 50–100% on several workloads, we saw even bigger gains on our read heavy applications that could take advantage of V-locity’s patented DRAM caching engine, that put our idle, unused memory to good use. Since we had provisioned adequate memory for these I/O-intensive systems, we were well positioned to get the most from V-locity.”

“We thought we were getting the most performance possible from our systems, but it wasn’t until we used V-locity that we realized how inefficient these systems really are if you’re not addressing the root cause performance issues related to the I/O profile from Windows servers. By solving the issue of small, fractured, random I/O, we’ve been able to increase the efficiency of our infrastructure and, ultimately, our people,” said Landes.

Tags:

General | SAN | Success Stories | virtualization | V-Locity | Windows Server 2012

SQL Batch Job Hell

by Brian Morin 1. October 2014 04:16

ASL was in SQL batch job hell.

A regular import of 150 million records into their SQL database would take 27 hours to complete.

ASL’s account team and clients needed access to the most current data immediately, but the 27 hour batch job meant that access would slip a full day of production or even two. That wasn’t acceptable as some clients would hold back business while waiting on new data to come online.

“Typically, IT professionals respond to application performance issues by reactively buying more hardware. Without the luxury of a padded budget, we needed to find a way to improve performance on the hardware infrastructure we already have,” said Ralph Ortiz, IT Manager, ASL Marketing.

ASL upgraded their network to 10GbE and was looking at either a heavy investment in SSD or doing a full rip-and-replace of the SAN architecture before its full lifecycle. Since that kind of hardware investment wasn’t in the budget, they decided to take a look at V-locity® I/O reduction software.

“I was very doubtful that V-locity could improve my I/O performance through a software-only solution. But with nothing to lose, we evaluated V-locity on our SQL servers and were amazed to see that, literally overnight, we doubled throughput from server to storage and cut our SQL batch job times in half,” said Ortiz.

After deploying V-locity, SQL batch jobs that used to take 27 hours to complete now take 12–14 hours to complete. The weekly college database import that used to take 17 hours to complete is now down to 7 hours.

Read the full case study – ASL Doubles Throughput with V-locity I/O Reduction Software

The Student Enrollment Blues

by Scott Thomas 21. January 2014 06:58

It was a bad day for Steve Bettoni, Tech Support and IT Procurement Officer of Stockport College. Steve is responsible for the infrastructure that supports the college's enrollment apps, SAP, and Exchange, so you can imagine his level of anxiety on enrollment day—the busiest day for any education institution—when the system crashed and the finance director got involved.

Steve's team had already spent hours, days, and weeks troubleshooting helpdesk calls related to poor application performance. The team virtualized to get more from legacy systems, but with the increase in I/O traffic, application response time began to suffer.

Steve heard about Condusiv’s V-locity acceleration software and its ability to solve the toughest application performance challenges without adding new hardware. A bit skeptical, he decided to evaluate the solution—and dropped enrollment processing times from 15 minutes down to 5. Convinced of what V-locity could do for their applications, he deployed on other VMs and saw a 522% improvement with SAP and 85% improvement with Exchange.

Read the full story: Stockport College case study.

When Big Data Hurts

by Robin Izsak 5. December 2013 03:38

I recently spoke with Bell Mobility's Adam Moore, a member of the organization's OSS Systems Integration Team. Bell Mobility is Bell Canada's wireless division, employing a multitude of analysts who eat, sleep, and breathe Big Data. They capture metrics and run analytics on call failures, call drops, and call volume—helping the company provide better service to their customers.

Sure we hear a lot about Big Data these days, but we need these catch phrases to talk about abstract concepts. And Big Data is as important as it is abstract: it represents a smarter way to do business, to create value from all this data we have, and to make better decisions. Big Data enables Bell Mobility directors to pinpoint inefficiencies and see where optimization is needed to maintain optimal services to a broad customer base.

So on our call, Adam told me that things had slowed down. His users were dealing with longer and longer SQL query times, which was impacting their ability to do their jobs. Faced with significant data growth and a need for faster delivery of that data to meet SLAs with their users, Adam's team needed a solution to escalating performance problems, like right now. 

In assessing their options, Adam and team conducted an evaluation of V-locity® VM™. The results? A 61% reduction in I/O to the SAN, which led to 98% faster data processing times. And backups? "They used to run at 10MB per minute and sometimes didn't complete at all. Now they run at 60-120MB per minute and complete consistently." 

Read more about the team's success with V-locity in the 
Bell Mobility case study.

Tags:

Big Data | Channel | Cloud | General | Hyper-V | IntelliMemory | IntelliWrite | SAN | SSD, Solid State, Flash | Success Stories | virtualization | V-Locity | VMware

The Notorious 45-Second Query

by Robin Izsak 19. November 2013 05:17

You just clicked OK. Now wait 45 seconds for your query to complete. Now do this a bunch more times until you've compiled all the data you need for a report. And right about now, frustrated, you think about getting a snack and more coffee. 

That's what was happening at SunCoke Energy, as sys admin Chris Mueller's business users started complaining of painfully slow queries and application response.

When the "45-second query" became notorious around the office, Chris and his team started a months' long troubleshooting mission, trying to tune Oracle performance and improve the speed of the business's Cognos VMs. “A bad day for my team is when our people can’t do their jobs—it’s like trying to find a needle-in-a-haystack, troubleshooting for performance.”

After a number of attempts, including consolidating all the VMs and updgrading the SAN, the team brought in V-locity® VM™ and dramatically improved speed—overnight.

Read the SunCoke Energy case study to learn more about their immediate success with V-locity.

Tags:

Big Data | Cloud | General | IntelliMemory | IntelliWrite | SAN | Success Stories | virtualization | V-Locity | VMware

Month List

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar