The AppD Approach: How to Identify Problematic Database Queries with Business Transactions
It happens all the time: the engineers notice your application is slowing down just as a health rule fires a warning. Now you are in a race to identify and fix the issue before customers feel its impact. One tried-and-true solution is database query optimization. But how do you know which queries to optimize? And […]
Top 6 Database Performance Metrics to Monitor in Enterprise Applications
The previous article presented an introduction SQL and NoSQL. This article builds on these topics by reviewing six of the top performance metrics to capture to assess the health of your database in your enterprise application. Specifically this article reviews the following: Business Transactions Query Performance User and Query Conflicts Capacity Configuration NoSQL Databases Business […]
Is Your Database Dragging Down your PHP Application?
Here’s a quiz from our last PHP application performance post: How much of a PHP application’s execution time is used up accessing the database? 50%? 75%? You may recall the real answer, since it is so (some might say surprisingly) big: some 90% of PHP execution time happens in the database layer. So it makes […]
Storage is Killing Your Database Performance
The other day I had the opportunity to speak with a good friend of mine who also happens to be a DBA at a global Financial Services company. We were discussing database performance and I was surprised when he told me that the most common cause of database performance issues (from his experience) was a […]