Database Archive

10 Popular Oracle Performance Metrics that Every DBA Should Know

Before you jump into creating KPIs for your Oracle database, clearly state and test your assumptions right up front. That has to come first. Otherwise, you’ll go down a blind alley many times trying to achieve better performance that will never happen because your assumptions were wrong in the first place. Be ...Read More

Franken-Monitor Visits a War Room [COMIC]

Having silo’d monitoring toolsets will often provide more trouble than they’re worth. All too often, monitoring tools don’t work well together, provide conflicting data, or just simply can’t diagnose the problem. In a War Room scenario — where people from the database team, servers, developers, IT operations, and anyone else involved — ...Read More

A Newbie Guide to Databases

Databases are an incredibly useful tool for storing data. Similar to a library storing books in an organized structure consisting of categories – such as history or art – a database imposes order on your data so that you can quickly construct the information you are looking for. Different types of databases ...Read More

The Franken-Monitor adds Database Monitoring [COMIC]

In June with our Summer ‘15 Release, we introduced the IT world to true Unified Monitoring — a single pane of glass to monitor your whole environment. Finally obtain complete visibility into your entire IT Infrastructure with an industry-first application-centric integrated monitoring platform. Coinciding with the release, we re-introduced the concept of ...Read More

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