White Papers
Technical Papers and Documentation.
Our experienced writers are experts with the technology and can develop the documentation and messages that you or your customers require.
Our whitepapers cover a wide range of topics, including performance optimization
of Oracle and MS
SQL Server, RAID, SAN, and Linux configuration, and a variety of other subjects. Need more information? Have a question? Let us know

- Troubleshooting and Tuning: Oracle RAC on Linux by Edward Whalen
Presentation given at Oracle OpenWorld 2006.
- 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.
top

- 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 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.
top |
|