AppDynamics for databases gives DevOps teams visibility of how their application's SQL executes. When performance drops below acceptable threshholds, they can collaborate with DBAs rather than simply pointing a finger. Users of AppDynamics will now be able to find the root cause of slow SQL and stored procedures in their applications, you can quickly and easily isolate slow queries and diagnose the root cause of performance issues in your application.
Application databases these days vary significantly. Most use Oracle, some use MySQL and obviously .NET applications work better with Windows-based platforms such ase SQL Server and Sybase. It's therefore critical that you obtain a holistic view of performance across all your databases.
Real-Time Performance Metrics
You need too know immediately what is happening in a database at any given moment. Did the database run out of connections? Is the database experiencing latency from row locking? These are just a few answers you can get from the “Current” workspace which provides a real-time view of database resources and performance.
Historical Analysis of Database Activity
Real-time data is good, but you also need historical data to identify trends, spikes and abnormal performance patterns. For example, a simple application code change can have a dramatic impact on a database and performance. We had an agile customer last year who deployed a code release in production and immediately saw a slowdown in application response time. When they drilled into AppDynamics for Java they noticed that one business transaction was now performing 25 SQL queries per execution instead of just two. This was the difference between 20,000 and 250,000 executions per minute in the database. Obviously when you increase concurrency like this, thee application will experience contention. Being able to visually track database resources, time spent, wait states and number of executions over-time is invaluable.
More About AppDynamics for Databases
Tuning SQL has never been easier with AppDynamics for Databases. Now you can access highly granular SQL performance management data in your production environment, allowing you to respond rapidly to new issues as they arise and to proactively solve problems before they affect your end users.
We engaged the AppDynamics Enablement Team and within a week we found over a dozen major defects that were affecting the performance and stability of our products. Great team, great enablement.
Bob Hartley, Family Search, Development Manager
We're enthusiastic with the support we received from the AppDynamics training team. They helped us gain critical visibility into our applications that's helped us make better architectural and design decisions.
Hedeih Yaghami, Tivo Director, Software Development
Relational databases are still an important application component even in today’s modern application architectures. There is usually at least one relational database lurking somewhere within the overall application flow and understanding the behavior of these databases is major factor in rapidly...
Server monitoring a foundational component to any data center monitoring architecture but it has become a crutch and a deterrent to successfully building out a holistic monitoring platform. Servers exist to run applications and you will never properly monitor applications with server monitoring...