Recently I contributed my thoughts in a new ebook from ScaleArc called “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter is an ongoing struggle for those of us in the operational trenches, and a number of us in the industry contributed our thoughts to ScaleArc to help administrators sift through the options and learn how to make these upgrades easier. It’s a great read, and learning from the great contributors is fun! Check it out!
I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft SQL Server“.
Performance tuning inefficient legacy applications can be a tremendous drain on development resources in an organization. Handling availability of the database layer of these applications can be an even larger challenge. ScaleArc can help improve both challenges by improving the availability of the database layer and accelerating common repetitive database queries from the application.
The past five years or so has seen a shift in people’s expectations for application performance. As they’ve seen their personal apps deliver continuous uptime and high performance, they’ve grown more frustrated with the slower performers in business.
Despite these business apps being critical to corporate performance, users have “just dealt with it” for years whenever they’re slow and unreliable. One challenge, of course, has been that these enterprise apps are much more complex than the personal apps, making it harder to update them. Plus, making the necessary changes to “update” the application might be out of the hands of an organization when they don’t control the source code, or are costly and time prohibitive to update when they do. A compelling alternative has emerged. Rather than recoding apps for improved uptime and performance in a database environment, consider the benefits of database load balancing software. A pioneer in this technology, ScaleArc has set out to make business application platforms more highly available and perform better by managing the traffic into the database servers. The ScaleArc software acts as an intermediary between the application and database layers. Sitting in between, it buffers database outages from impacting application availability and transparently accelerates the application’s performance, all without code or usability changes. This whitepaper explains the benefits of the ScaleArc software and shows benchmarking results of one feature set – app-transparent caching. In our tests, the ScaleArc software enabled a 5x improvement in the operations processed per minute and a drop in CPU consumption from a peak of 100% to a peak of 60%.
Next week I am participating in two exciting webinars that I want to share with you!
Application availability is an “across the stack” problem – straddling the app tier, database, virtualization, and cloud infrastructure. DBAs, IT ops, and architects must do more to improve app uptime, particularly at the database tier, where failovers and maintenance cycles disrupt the app, impacting the customer experience.
– Enhancements in clustering and Availability Groups
– Why these solutions can’t enable seamless failover
– How database-level buffering and acceleration improve app availability
– What IT can do across the stack to improve the customer experience
Get your questions answered on this live event – register here.
Next we’re going to talk about the reasons and challenges around upgrading to the latest versions of SQL Server with PernixData.
Upgrading to SQL Server 2014 and beyond gives you new levels of performance and flexibility. This is especially true if you are still on SQL Server 2005, which will no longer be supported by Microsoft as of April 12th, 2016.
But are you aware of the landmines that come with such an upgrade? Going in blind can cost you substantial time and money, which your business cannot afford.
Join this interactive video webinar where PernixData’s Bala Narasimhan and I will discuss how you can navigate the top challenges of a SQL Server upgrade, specifically:
– How to optimize storage to avoid database performance hits
– How to minimize SQL server licensing costs during (and after) an upgrade
– How to go virtual without sacrificing SQL Server performance
– Low cost options for in-memory computing
The webcast will feature a live Q&A. Register now or request an on-demand recording.
Also, on May 11th I’m presenting a new session called ‘Virtual SQL Servers, Actual Performance‘ to the PASS Virtualization virtual chapter.
Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.