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.

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

For and By

by karen 23. August 2011 04:29

Diskeeper has long been a popular compliment for design and engineering software systems, including by the the most popular design and enginerring software company itself:

“Diskeeper indeed provided the ROI we expected. We are very satisfied. I have been using your product on my personal desktop and at work for the past few versions. It always proved to be a valuable product for transparent defrag and overall performance. 

Prior to installing Diskeeper our systems were almost unresponsive. This easy deployment was done right away as Diskeeper was much needed. It is a fine product that we rely upon.  It was reported to me that the automatic defrag did not take any visible resources or produce any slower performance which was really appreciated. 

The automatic defrag also helped overall performance greatly on the files sytem access. One of the folders has millions of files in it with no subfolders and it was almost inaccessible before the Diskeeper implementation due to the fragmentation level being very high” 

- Marc-Andre, Autodesk   

Autodesk, Inc., is a leader in 3D design, engineering and entertainment software. Customers across the manufacturing, architecture, building, construction, and media & entertainment industries—including the last 16 Academy Award winners for Best Visual Effects—use Autodesk software to design, visualize, and simulate their ideas before they’re ever built or created. From blockbuster visual effects and buildings that create their own energy to electric cars and the batteries that power them, the work of our 3D software customers is everywhere you look. Since its introduction of AutoCAD software in 1982, Autodesk continues to develop the broadest portfolio of state-of-the-art 3D software for global markets.

Tags:

Diskeeper | Diskeeper | Success Stories | Success Stories

RecentComments

Comment RSS

Month List

Calendar

<<  September 2019  >>
MoTuWeThFrSaSu
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

View posts in large calendar