Whether they know it or not, every department, group or function within a business, from marketing to sales to the executive leadership, relies on a database in some way or another.
How? Applications are the heart of all critical business functions and an essential component to nearly every end user’s job, affecting productivity, end user satisfaction and ultimately revenue. In fact, in a recent SolarWinds survey of business end users, 93 percent of respondents said application performance and availability affects their ability to do their job, with 62 percent saying it is absolutely critical.
And at the heart of nearly every application is a database.
This means when an application performance or availability problem arises — something end users have little patience for (67 percent of end users also said they expect IT to resolve such issues within an hour or less) — there’s a good chance it’s associated with the underlying database’s performance. So, to not only keep end users happy, but productivity and revenue humming, application performance should be a paramount concern, and database performance must be a key element of that concern.
As validation of this point, another SolarWinds survey found that 71 percent of IT pros agree that a significant amount of application performance issues are related to databases and that application performance should start with the database. In addition, 71 percent also said application response time is a primary challenge they are trying to solve by improving database performance.
Why? There are three primary reasons. First, database engines are very complex — from complex queries and execution plans to replication and the inner workings of the database.
Second, there is a shortage of skilled performance-oriented database administrators (DBAs) in the market, resulting in many “accidental DBAs”.
Finally, compute and network resources can easily scale vertically or horizontally with today’s virtualization and cloud technologies, the same cannot be said for databases.
If you’re experiencing database-related application performance issues, or simply want to improve application performance by optimizing underlying databases, you should consider the following tips.
1. Get a full view of the application stack
The days of discrete monitoring tools are over. The use of tools that provide visibility across the entire application stack, or the application delivery chain comprised of the application and all the backend IT that supports it — software, middleware and extended infrastructure required for performance, especially the database — is a must in today’s complex, highly interconnected IT environment.
2. Be proactive and align the team behind end user experience
No one likes fighting fires. One way to minimize them is to be proactive and look at performance continuously, not only when it becomes a major problem. The entire team supporting applications should understand end user experience goals in terms of page-load and response times so it becomes a shared objective with very concrete business impact. Without a scoreboard everyone can see, it’s hard to know if you are winning.
3. Stop guessing
It’s not uncommon to default to adding hardware to hopefully improve performance — for example, switching to SSD drives. However, this is a gamble that has cost more than a few people their jobs. If the bottleneck is memory or a really bad SQL query, investing in SSD drives is unlikely to improve application performance.
4. Go beyond traditional monitoring
Most traditional monitoring tools focus on health and status, providing many charts and a lot of data, most of which is hard to interpret and time consuming to tease out performance insights from. Instead, tools with wait-time analysis capability can help identify how an application request is executed step-by-step, and what the processes and resources are that the application is waiting on. It provides a different view into performance, one that is more actionable than traditional infrastructure dashboards.
5. Establish baselines
It’s important to establish historic baselines of application and database performance that look at how applications performed at the same time on the same day last week, and the week before that, to detect any anomalies before they become larger problems. By so doing, if a variation is identified, it’s much easier to track the code, resource or configuration change that could be the root cause.
6. Get everyone on the same page
Today’s complex applications are supported by an entire stack of technologies that is only as good as its weakest link. And yet, most IT operations teams are organized in silos, each person or group supporting a part of the stack. To avoid finger pointing, get every team in the organization a unified view of application performance, ideally based on wait-time analysis, so everyone can focus on solving application problems quickly.
As the backbone of nearly all business-critical applications, the impact of database performance on application performance cannot be underestimated. Following these tips can help eliminate many potential bottlenecks.
Gerardo Dada is VP Product Marketing and Strategy at SolarWinds.
The Latest
Part 4 covers OpenTelemetry: Next year, we're going to see more embrace of OpenTelemetry across the entire industry — opening up the future of instrumentation ...
Part 3 covers even more on Observability: Observability will move up the organization to support the sustainability and FinOps drive. The combined pressure of needing to adopt more sustainable practices and tackle rising cloud costs will catapult observability from an IT priority to a business requirement in 2024 ...
Part 2 covers more on Observability: In 2024, observability platforms will embrace and innovate with new technologies like GenAI for real-time analytics, becoming the fulcrum for digital experience management ...
The Holiday Season means it is time for APMdigest's annual list of Application Performance Management (APM) predictions, covering IT performance topics. Industry experts — from analysts and consultants to the top vendors — offer thoughtful, insightful, and often controversial predictions on how APM, Observability, AIOps and related technologies will evolve and impact business in 2024. Part 1 covers APM and Observability ...
To help you stay on top of the ever-evolving tech scene, Automox IT experts shake the proverbial magic eight ball and share their predictions about tech trends in the coming year. From M&A frenzies to sustainable tech and automation, these forecasts paint an exciting picture of the future ...
Incident management processes are not keeping pace with the demands of modern operations teams, failing to meet the needs of SREs as well as platform and ops teams. Results from the State of DevOps Automation and AI Survey, commissioned by Transposit, point to an incident management paradox. Despite nearly 60% of ITOps and DevOps professionals reporting they have a defined incident management process that's fully documented in one place and over 70% saying they have a level of automation that meets their needs, teams are unable to quickly resolve incidents ...
Today, in the world of enterprise technology, the challenges posed by legacy Virtual Desktop Infrastructure (VDI) systems have long been a source of concern for IT departments. In many instances, this promising solution has become an organizational burden, hindering progress, depleting resources, and taking a psychological and operational toll on employees ...
Within retail organizations across the world, IT teams will be bracing themselves for a hectic holiday season ... While this is an exciting opportunity for retailers to boost sales, it also intensifies severe risk. Any application performance slipup will cause consumers to turn their back on brands, possibly forever. Online shoppers will be completely unforgiving to any retailer who doesn't deliver a seamless digital experience ...
Black Friday is a time when consumers can cash in on some of the biggest deals retailers offer all year long ... Nearly two-thirds of consumers utilize a retailer's web and mobile app for holiday shopping, raising the stakes for competitors to provide the best online experience to retain customer loyalty. Perforce's 2023 Black Friday survey sheds light on consumers' expectations this time of year and how developers can properly prepare their applications for increased online traffic ...