Whitepapers

VMWare SQL Server Oracle Confio Show All
This article by Sr. DBA, Kathy Gibbs, discusses her experience using both OEM and Ignite at her position in Denver-based financial services company. The paper maps out the three key reasons why a DBA should considering using Ignite alongside OEM.
There are differences between performance tuning on a RAC database versus a single instance. In this paper, Kathy Gibbs, Sr. Oracle DBA, will explore the RAC-only waits as well as some tuning suggestions for code to help your RAC environment run more smoothly.
To evaluate the difference in Oracle operation between physical and VMware servers, a direct head-to-head comparison of transaction performance was conducted using both scenarios at separate times on the same physical server. By illustrating how a DBA can visualize the response time, query throughput, and server resources utilized in both scenarios, this paper demonstrates how a DBA team can effectively monitor Oracle on VMware to ensure continued performance.
Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this detailed paper follow a simple, repeatable, four-step process. Several tuning case studies help illustrate how the method works in real applications. This methodology is a valuable time saver because it will help you get it right the first time.
Using your Ignite trial, these 5 basic steps show you how to identify your most critical query, find the important bottleneck, receive automatic progress reports, and be proactively alerted on serious changes.
Using your Ignite trial, these 5 basic steps show you how to identify your most critical query, find the important bottleneck, receive automatic progress reports, and be proactively alerted on serious changes.
Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this paper are derived from years of SQL tuning and Oracle database performance consulting. The methodology follows a simple, repeatable, four-step process and is a valuable time saver because you'll get it right the first time.
Virtualization makes it much more difficult for DBAs to see the interaction between the database and the underlying server resources. Here are five scenarios that merit attention for DBAs with VMware.
A Kaminario and Confio White Paper. This case study highlights the overall Microsoft® SQL Server® performance improvement that can be achieved using the Kaminario K2 storage appliance. Ignite for SQL Server was used to diagnose and quantify I/O bottlenecks and to illustrate the performance benefit achieved with Kaminario.
Authored by Dale Cunningham, Sr SQL Server DBA at Sunshine Software. This paper documents how DBAs can use performance intelligence tools to find and resolve database problems that directly impact customer service.
Confio’s Igniter Suite™ delivers demonstrated hard cost savings for IT operations. Prove to management that Ignite saves money. This paper documents cost savings in four different business scenarios, and illustrates the ROI calculations in excess of 1000%.
In my mind, one company got-it from the beginning. Not only has Confio embraced the elegance of response time analysis, but has created the graphical interface to capture the essence of Response Time Analysis". Read the entire description by Craig Shallahamer of Orapub, internationally known consultant and teacher.
The only performance that matters in a computer system is how long it takes to respond to a users request for information. This paper, written by internationally recognized firm Bloor Research, that Confio’s time-based approach is not only more intuitive but is also more effective in monitoring and identifying root cause.
Databases are one of the last frontiers for virtualizing into a VMware environment. They can be very resource intensive, so many companies have been hesitant to move them into a virtual environment. Most of the hesitation has come from poor experiences during initial tests of VMware. Many of our customers are successfully running databases inside VMware and the key for them was monitoring the correct metrics that can help show where the bottlenecks are. This paper will review the VMware metrics that helped many companies have a far better virtualization experience.