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.

Microsoft SQL Team Puts V-locity to the Test

by Brian Morin 15. September 2017 09:12

In a testament to Condusiv's longstanding 20+ year relationship with Microsoft® as a Gold Partner and provider of technologies to Microsoft over the years, Condusiv® became the first software vendor awarded the stringent certification of MS-SQL Server I/O Reliability joining a very short list containing the likes of Dell® / EMC®, IBM® and HPE®.

Microsoft developed the SQL Server I/O Reliability Program to ensure the reliability, integrity, and availability of vendor products with SQL Server. The program includes a set of requirements that, when complied with and approved by a Microsoft committee of engineers, ensure the product is fully reliable and highly available for SQL Server systems. The certification applies to SQL Server running on Windows Server 2008R2 and later (the most current 2016 release included).

V-locity® Certified for SQL I/O Reliability and Demonstrates Significant SQL Performance Gains

The program itself does not require performance characteristics of products, but it does require I/O testing to exhibit the reliability and integrity of the product. To that end, the full report links to a summary of before/after performance results from a HammerDB test (the preferred load test to measure MS-SQL performance) on Azure to demonstrate the gains of using V-locity I/O reduction software for SQL Server 2016 on Azure’s Windows Server 2016 Data Center Edition. While transactions per minute increased 28.5% and new orders per minute increased by 28.7%, gains were considered modest by Condusiv’s standards since only a limited amount memory was available to be leveraged by V-locity’s patented DRAM caching engine. The typical V-locity customer sees 50% or better performance improvement to SQL applications. The Azure test system configured by Microsoft did not boost available memory to showcase the full power of what V-locity can do with as little of 2-4GB of memory.

To read the full report CLICK HERE

 

Case Management Solutions Turns to V-locity I/O Reduction Software to Solve Slow MS-SQL Performance

by Brian Morin 27. July 2017 05:21

A little more than a year ago, Case Management Solutions reached out to Dealflow, a Condusiv® Authorized Reseller, about getting help in finding a solution for what had become a notoriously slow application sitting on MS-SQL supported by NAS storage.

“If a file was 50 pages long, I would sit and watch the page count loading all 50 pages before printing the report. Some of the files we process are more than 500 pages, so I think you can imagine the pain,” said Hal Brooks, Managing Partner, Case Management Solutions.

The problem wasn’t just the time it took to process files, but employees would sit and wait to log into the system and experience delays when going from page to page within the application. Hal reached out to Dealflow, a Condusiv authorized reseller, who specializes in building IT solutions to solve customer pain points.

“Case Management Solutions shared with us the pain they were experiencing and the need to find the most cost-effective solution possible. We quickly spotted some necessary server upgrades, but after having seen what V-locity® I/O reduction software had done for our other clients, we knew that was likely the only missing ingredient to tackle their performance issues,” said Lee Owens, VP of Sales, Dealflow.

“After we completed the server upgrades, we installed Condusiv’s V-locity I/O reduction software and Case Management Solutions saw exactly the kind of performance they were hoping to see. Even their backup times dropped,” said Owens.

“Query times improved by 4X. Employees no longer had to wait to login or process files, and no longer experienced delays when going from page to page within the app. Instead of watching all 50 pages count up before printing, it’s almost instantaneous,” said Brooks.

“From our perspective, when Condusiv says they guarantee to fix application performance issues on Windows servers, that’s exactly what they do. We can attest to everything they claim as being true. It has helped all of our customers remove sluggishness from their most important applications,” said Owens.

To read the full story on how V-locity I/O reduction software boosted their MS-SQL performance, read here: http://learn.condusiv.com/rs/246-QKS-770/images/CS-CaseManagement.pdf

 

Tags:

Application Performance | Performance | V-Locity

National Mortgage Lender Eliminates Sluggish MS-SQL Applications with V-locity I/O Reduction Software

by Brian Morin 25. July 2017 06:01

I first chatted with Chuck Keith (Dir of Infrastructure, Supreme Lending) a couple years ago at VMworld. They had a custom-built loan application that sat on MS-SQL that was the most mission critical application to the business. The loan officers relied on it daily to do their jobs effectively. One problem – it was slow. 

 “Our common workloads are supported by our older Dell Compellent arrays, but all of our MS-SQL workloads are supported by newer Nimble storage arrays. As great as Nimble performs from a ‘cost per performance’ standpoint, it simply wasn’t enough with the growth of data and users we had been experiencing. Loan officers were complaining about slow queries taking five to ten minutes to run reports, and up to five seconds to advance from screen to screen within the loan origination system,” said Chuck Keith, Director of Infrastructure, Supreme Lending.

“At the time, we thought our only solution was to invest hundreds of thousands of dollars into new all-flash arrays to get the performance we needed. No matter how well your business is doing, no one wants to have a million-dollar conversation that’s not in budget. We needed to see how we could maximize performance on the hardware we already had, which led to a conversation with Condusiv,” said Keith.

“We examined a couple server-side caching players including Pernix Data and Infinio, but since Condusiv’s V-locity® I/O reduction software does so much more than server-side caching, its proof of concept came out the clear winner on both performance and price. And we didn’t have to add any additional hardware, since we already had a good amount of DRAM,” said Keith.

Keith continued, “Right off the bat, MS-SQL reporting that used to take five to ten minutes dropped to 30 seconds with V-locity, and all user complaints about sluggishness disappeared. We couldn’t believe it,” said Keith. Moreover, the typical 30-second load times to log into the software package dropped to ten seconds – a 3X improvement. The five-second wait to advance from screen to screen also disappeared, so that users could load each screen almost instantly.

“Not only did V-locity solve our ‘death by a thousand cuts’ issue of excessively small, tiny writes and reads from Windows VMs, but their DRAM caching engine provided huge gains on top of that by offloading a good percentage of hot reads from our underlying Nimble hybrid storage. It made a huge difference and gave back a big chunk of IOPS to our Nimble storage to be used for other things. We saved hundreds of thousands of dollars by being able to squeeze significantly more performance from the hardware stack we already have.” said Keith.

To read the full story on how V-locity I/O reduction software boosted their MS-SQL performance, read here: http://learn.condusiv.com/rs/246-QKS-770/images/CS_SupremeLending.pdf

Tags:

Performance

Month List

Calendar

<<  September 2017  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar