by Kathleen Long | Dec 15, 2014 | Blog, Data Management, Databases
A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version...
by Barrie Shaw | Aug 4, 2014 | Blog, Databases
When tuning performance for an IBM Informix instance, one important issue to look for is the presence of tables and indexes containing a large number of extents. Today’s high speed disks and SSD drives can mask some of the performance hit, making this an area...
by Matt Wolinski | Jul 30, 2014 | Blog, Portals
I recently came across a unique issue with a client. I was working on some performance optimizations due to latency on page load. I found an interesting issue around caching and this inspired my blog. Without giving any specific details, the client...
by XTIVIA | Feb 6, 2013 | Blog, Data Warehousing, Databases
We all worry about the performance of our servers. It is what separates the DBA’s from the pretenders. You just never know just what setting will be the one that makes the big difference. The worst part is, the setting that works today may...
by Asier Del Pozo | Jan 17, 2013 | Blog, Databases, Portals
There are many tools for monitoring applications. One that we may want to use is JAMon, the Java Application Monitor; it can be really useful for discovering what the hell is going on in our application. We are going to view a quick introduce in it. But first, a...
by XTIVIA | Feb 3, 2012 | Blog, Databases
When we focus on IO performance for SQL Server it is vitally important to understand the architecture of the disk subsystem. Typically, a DBA will focus on Disk Queue Length as the primary measure of IO performance; however, in a Storage Area Network (SAN)...