Database Archive

Too many tools, not enough big picture: A case of Franken-monitoring

In recent interview, an IT operations director told us, “We frankly have too many tools, and many of them weren’t performing to our expectations.” If you are an enterprise ops leader managing complex applications, chance are pretty high that you can relate to that statement. At AppDynamics, we call this “Franken-monitoring,” a situation ...Read More

Welcome to Application-centric Server Monitoring

Application-centric. And business transaction-focused. These two qualities are the heart of what sets AppDynamics Server Monitoring apart from other server monitoring tools, and make it such an essential component of a unified monitoring solution. “Application-centric” in that it takes a top-down approach. Typical legacy approaches employ a bottom-up strategy, meaning that they ...Read More

Monitoring ADO.NET Performance

One of the most overlooked parts of .NET is the glue that links your application through to a database known as ADO.NET (an evolution of ActiveX Data Objects). The lowly connection string is the only real access we get to the underlying technology. I was with a client recently and noticed they ...Read More

AppDynamics and MongoDB Work Together to Scale Databases [VIDEO]

If you haven’t noticed, enterprise IT is going through a generational inversion. Not necessarily in people (although that seems to be starting too) but in technology. There is a move from on-premise to cloud. From difficult to use enterprise applications with extended training required, to consumer-grade, intuitive interfaces that are nearly as ...Read More

Improving GIS performance with AppDynamics

Twenty years ago I started my professional career working in a niche field of IT called Geographical Information Systems (GIS) – basically mapping systems. This is an area where Big Data was prevalent, long before the term was officially coined, GIS covered a range of concepts from satellite imagery and aerial photography ...Read More

A Real Example of the Database to Storage Performance Relationship

Most enterprise databases today run on shared storage volumes (SAN, NAS, etc…) that are accessed over the network or via Fibre Channel connection. The shared storage concept is great for helping to keep storage infrastructure and management costs relatively low but creates cross silo finger pointing when there are performance issues. In ...Read More

What’s up with the Network and Storage teams?

A few weeks ago I was presenting at CMG Performance and Capacity 2013 and during my presentation we (myself and a few audience members) got slightly side-tracked. Our conversation somehow took a turn and became a question of why it was so hard to get performance data from the network and storage ...Read More

Database Monitoring for MariaDB and Percona Server

Both MariaDB and Percona Server are forks of MySQL and strive to be drop in replacements for MySQL from a binary, api compatibility, and command line perspective. It’s great to have an alternative to MySQL since you never know what might happen to it given that Oracle bought it for 1 billion dollars. ...Read More

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 ...Read More

How To Set Up and Monitor Amazon RDS Databases

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 troubleshooting application problems. In 2009, Amazon launched their RDS service which basically allows ...Read More