White Papers
Technical Papers and Documentation
From MS SQL Server, Linux, San, Virtualization technology, and Oracle 11g features, our white papers cover a wide range of topics. Additionally, with our leading selection of Oracle white papers, you’ll be sure to find exactly what you’re looking for. Still need more information? Don’t forget to check out our published books. Have a question? Please contact us at info@perftuning.com
Our experienced consultants and authors are experts with leading technologies and can develop the documentation and messages that you or your customers require.
Performance Tuning Database Solution Methodologies
During the past 15 years, over 1000 clients have entrusted Performance Tuning Corporation with their mission critical Oracle and Microsoft SQL database projects. This experience has enabled PTC databse consulting experts to develop repeatable methodologies which ensure the success of our clients.>
NEW! Using SQL Tuning Sets for Plan Stability for an 11gR2 Upgrade from 10.2.0.4 by Edward Whalen
When upgrading a database from Oracle 10g to Oracle 11g one of the biggest risks is to performance. Most 11g execution plans are improvements over 10g plans, however, there are times where 11g execution plans result in poor performance and excessive query execution times. One way to mitigate this risk is to save and store 10g execution plans in SQL Tuning Sets (STS) and use these execution plans in the 11g environment if necessary. This whitepaper provides benefits of saving and using these 10g plans. Detailed scripts and SQL statements that can be used to save these STSs and convert them into SQL Plan Baselines are provided. How to find and lock in the original 10g plan is outlined. In addition, real-world experience with using this methodology is presented.
Oracle 10g Performance on Windows Server 2008 Hyper-V Virtual Machine by Gary Parker
Windows Server is one of the top platforms for Oracle databases. With Windows Server 2008, everything needed to support database server virtualization is available as an integral part of the operating system. This Oracle white paper demonstrates the performance capabilities of Oracle 10g on Hyper-V. It also highlights several best practices and resources essential to virtualization of Oracle database workloads.
Advantages of Running Oracle11g on Microsoft Windows Server x64 by Edward Whalen
Whitepaper presented at Collaborate 2008.This paper highlights some of the advantages of running Oracle on the Windows 64-bit operating system. In addition, it addresses some of the basic issues and factors to consider when choosing to deploy a new operating system, such as Windows.
Enabling the Maximum Availability Architecture on Linux by Edward Whalen
Whitepaper presented at Collaborate 2008. This paper explores how the MAA can be used to provide protection in a number of disaster scenarios.
Performance Tuning Oracle RAC on Linux by Edward Whalen
Whitepaper presented at Collaborate 2008. This paper explores the Oracle architecure, the troubleshooting tools and methodologies used to tune Oracle and the Linux operating system.
Oracle Recovery Manager (RMAN) and RAC by Edward Whalen
Presentation for Oracle IOUG RAC Attack 2008. This presentation discusses RMAN's application in backing up Oracle RAC databases.
Troubleshooting and Tuning: Oracle RAC on Linux by Edward Whalen
Presentation given at Oracle OpenWorld 2006. This presentation covers the aspects of performance tuning and its application to the Linux operating system and storage.
Comparison of the Oracle Database Server on Microsoft Windows Server 2003 and on Redhat Linux by Larry Pedigo
The focus of this paper is to compare the Oracle Database Server on Microsoft Windows Server 2003 and the Oracle Database Server on Rehat Linux. Both systems utilized x64 technology.
Comparison of 34-bit and 64-bit Oracle Database Performance on the Dell PowerEdge 6850 Server with Microsoft Windows Server 2003 by Larry Pedigo
The focus of this paper is comparing the performance of Oracle databases on 32-bit Microsoft Windows Server 2003 and 64-bit Oracle databases on the Microsoft Windows Server 2003 version for the EM64T processor.
Deployment Guide: Oracle on Microsoft Windows and the Dell PowerEdge 6850 Server by Bryan Thomas and Larry Pedigo
This paper identifies issues involved in configuring Oracle RAC on Windows with Dell hardware and provides a template for successful implementations. Topics covered include installing the Operating System for Oracle, configuring the Cluster hardware, installing Oracle software, creating the RAC database, and post-installation tasks.
Overview of I/O Performance and RAID in an RDBMS Environment by Edward Whalen
This paper covers the fundamentals of I/O topics and an overview of RAID levels commonly found in an RDBMS environment. This paper covers both the performance and fault tolerant properties of those RAID levels.
Tuning Oracle and RAC on Linux (excerpt)
Tuning Oracle is as much an art as it is a science. Tuning involves scientific investigation, good note taking, intuition and experience in order to determine if there is a performance problem, what that performance problem is, and how to solve it. Performance tuning is made easier by developing and sticking with a disciplined methodology.
Configuring, Tuning, and Using Oracle9i in a Red Hat Linux Environment by Edward Whalen
Tips on critical steps that must be taken when installing Linux to ensure the successful configuration of Oracle9i, including useful tuning suggestions and monitoring techniques.
Oracle 9i I/O Configuration in a SAN/NAS Environment by Edward Whalen
Some of the most common Oracle performance problems involve the I/O subsystem. Since Oracle’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in Oracle performance problems. Much of the design of the Oracle RDBMS is intended to make accessing the I/O subsystem as efficient as possible.
Configuration and Installation of Oracle Fail-Safe on Windows 2000 by Edward Whalen
This paper is designed as a beginner’s course for those interested in setting up Oracle Fail Safe in a Windows 2000 environment.
Oracle 10g on Linux Cluster by Bryan Thomas
High Availability (HA) is in high demand today. Corporations lose thousands if not millions of dollars every time there is an outage of their IT systems. This white paper will cover the basic steps for creating a Linux Cluster. Specifically, it will cover installing Oracle 10g on a Linux Cluster in active/passive mode utilizing the Red Hat Cluster Manager.
Survey of Popular Clustering Technologies by Edward Whalen
Clustering has become quite popular and there are a number of different products that use the term clustering that act and perform differently. This paper explains the different technologies and terminologies that are used to form clusters.
Performance Implications of Various Cursor Types in MS SQL Server by Edward Whalen
By choosing the most efficient cursor type for MS SQL Server 2000, you can not only speed up the application, but you can conserve valuable system resources as well. In this paper, the various cursor types are discussed and their performance implications detailed.
SQL Server 2000 I/O Configuration in a SAN/NAS Environment by Edward Whalen
Since SQL Server’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in SQL Server performance problems.
SQL Server Execution Plan Cost Formulas by Joe Chang
Presents why SQL Server uses a given execution plan for a specific query: the cost model and statistics; when the execution plan changes; and performance testing: how to get the same results in test as in actual use, and size and cardinality.
