Whitepapers

Authored by George Crump, Lead Analyst, shows a strong relationship between DBAs and Storage Architects leads to better database performance. The DBA and the storage architect together often hold the key to resolve the issues. To foster a productive relationship between the DBAs and storage architects, it’s crucial to have a common tool that provides analytics they can both understand.
How do you know which of your database servers is a candidate to be virtualized? What are the key measurements you should be aware of before deciding to convert a physical box to virtual? DPA can help you determine if your database server is a candidate for virtualization, just by examining the information displayed in a handful of reports you get right out of the box.
Authored by Dean Richards, Senior DBA, shows how RTA provides a systematic way to discover and measure performance as it relates to user experience. RTA measures a query end to end, from request to response, all the waits encountered in between, and all the resources used by a query during processing.
Oracle’s evolving support and licensing policies for Oracle RAC on VMware means you can realize the benefits of virtualization-- reducing IT costs while increasing the efficiency, utilization, and flexibility of your existing assets—without risk.
One of the selling points of Exadata is that you just install it, drop all your indexes and it will increase your database performance significantly all within about a week. Although part of this statement is correct, if you only follow these steps, not only do you open the door for specific queries to run slower at the start, but there is a good chance even some of the queries that are running ok now will exponentially get worse.
90% of SolarWinds Database Performance Analyzer (DPA) for Oracle customers use both Oracle Enterprise Manager (OEM) and DPA to solve performance issues. This is not surprising. The combination of OEM and DPA provides the kind of help DBAs need to better understand database performance issues and save time, money and frustration.
Many SQL Server database administrators use Management Data Warehouse (MDW) for performance monitoring. MDW is provided by Microsoft to all their licensed SQL Server 2008 users for free, but organizations with mission critical systems also invest in third-party tools for more robust performance tuning and analysis.
In this white paper, Tom LaRock, Technical Evangelist and SQL Server MVP, demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to more advanced query tuning techniques like indexing. When you apply this process from start to finish, you will improve query performance in a measurable way, and you will know that you have optimized the query as much as is possible.
"The importance of performance to DevOps" from Bloor Research explains why production performance should be, but often isn’t, a functional requirement for application development projects, and describes how this practice can help IT teams achieve the best database performance possible.
Microsoft SQL Server Extended Events, a replacement for Trace, can provide you with a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. In this white paper, Janis Griffin, Senior DBA at Confio, explores how Extended Events are different than Trace, how to best use them as a deep-dive, complementary tool to a lightweight continuous performance monitoring solution such as Confio Ignite, and guidelines for getting started with them.
Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, Senior DBA Dean Richard describes response time analysis in detail and provides an overview of the tools available for effective response time analysis within a SQL Server environment.
Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, Senior DBA Dean Richard describes response time analysis in detail and provides an overview of the tools available for effective response time analysis within an Oracle database environment.
Read a commissioned study conducted by Forrester Consulting, “Total Economic Impact of Confio Ignite”. The study documents the economic benefits achieved by a Fortune 21 sized organization over a three year project using Confio Ignite.
It can be a daunting task to put together everything you need in a pre-upgrade checklist. This paper compiles the top eleven items that you should include in any checklist for migrating your database server to SQL Server 2012. Including these items is likely to help you avoid many potential upgrade issues.
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.
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, concludes that Confio’s time-based approach is not only more intuitive but is also more effective in monitoring and identifying root cause of database performance problems.
Many CIOs have embraced the need to reposition the IT organization as a strategic component of delivering world-class products and services. For CIOs in SaaS or Web-enabled businesses, an important element in this effort is the transformation from reactive to proactive application performance monitoring and management. This is accomplished by building performance into development from the start and breaking down the silos that separate teams, from architects to developers to QA to DBAs to systems administrators.
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.
This article by Sr. DBA, Kathy Gibbs, discusses her experience using both OEM and Ignite during her tenure at a 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.
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.

x

Are you sure?

SolarWinds Free Database Monitor (formerly Confio IgniteFree) is an awesome tool for monitoring SQL Server, Oracle, Sybase and DB2 performance in real time, but if you need historical trend analysis and report and alert features, check out the full featured version.

Feature Free Full Version
Real-time query response monitoring
Alerts
Historical trends 1 Hour Limited Unlimited
Monitored instances 20 Max Unlimited
Reports and multi-dimensional drill down

The full featured version easily converts to IgniteFree, just in case you change your mind later.

Continue to IgniteFreeTry the Full Version