Oltp White Papers

14 white papers are tagged with: oltp


A Performance Characterization of SQL Server 2005 VMs on PowerEdge Servers Running ESX Server 3.5

This whitepaper provides performance results and analysis about how SQL Server 2005 VMs, running on Dell PowerEdge servers, perform with a hypothetical Online Transaction Processing OLTP workload. Performance scaling with this typical OLTP application should be indicative of how other similar OLTP ...

An Enterprise Database Performance Comparison of the Dell PowerEdge 6850 and the Sun Fire V490 UltraSPARC Server

To test the performance of latest generation dual‐core quad‐socket servers from Dell and Sun, a performance test using the open source and freely available Dell DVD store database was conducted. Similarly configured Dell PowerEdge 6850 and Sun Fire V490 servers were used for the performance ...

Best Practices for Deploying SSDs in a Microsoft® SQL Server™ 2008 OLTP Environment with Dell EqualLogic™ PS-Series Arrays

This whitepaper discusses the performance improvement on using Dell EqualLogic™ SSD arrays to deploy Microsoft® SQL Server™ 2008 database. This paper details the experimental analysis for the following scenarios, based on a standard OLTP workload using Dell EqualLogic arrays.  Deployment of ...

IBM System z & DS8000 Technology Synergy

System z has had a unique relationship with its storage since the inception of S/360 in 1964. IBM’s publication

The ESA/390 Principles of Operations (SA22-7201) & z ...
Tags: oltp sdm

Performance and Scalability of a Large OLTP Workload with DB2 9 for System z on Linux

DB2 9 on Linux on System z is a scalable solution for large OLTP workloads. This paper illustrated that a high volume of transactions can be processed on a large database. It demonstrated that the database size can grow by a factor of six to approximately 1.4 TB with no marked performance change. ...

Top 10 Reasons for Developers to Upgrade to ASE 15.0

Upgrading any software package is not always a pleasant task. Whether it is the UI changes that cause drops in productivity due to having to hunt for functions that you used to know where they were located – or whether ...

Tags: jdbc oltp dbms

Top 10 Server Configuation Tips for a New ASE 15 Installation

In almost 20 years of tuning Sybase Adaptive Server Enterprise (including the time it wasn’t yet called ASE), I’ve found a variety of similarities in the types of missed opportunities in server ...

Tags: oltp pci-dss

Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications

Understanding how to analyze the characteristics of I/O patterns in the Microsoft® SQL Server® data management software and how they relate to a physical storage configuration is useful in determining deployment requirements for any given workload. A well-performing I/O subsystem is a critical ...

Optimizing Transaction Performance in Adaptive Server® Enterprise 12.5

The transaction logging subsystem is one of the most critical components of a database server. To be able to accomplish ...

Tags: oltp

Oracle E-Business Suite Release 12.1 with Oracle Database 11g Advanced Compression

This white paper details tests performed with Oracle E-Business Suite Release 12.1 running on Oracle Database 11g Release 1 with Advanced Compression using a mix of online and batch workloads to validate and quantify the benefits of Advanced Compression.
5 10 15
per page
First Previous 1 2