Top 10 Server Configuration Tips for a New ASE 15 Installation
Executive overview

Sybase Adaptive Server® Enterprise 15 offers a broad scope of tuning options at the server level. Many are simple decisions: configure them.
Others require a small amount of research. This article focuses specifically on configuring ASE performance at the server level. I’ve created a list of
things I look for, most of which are automatic and underutilized. A few are things you can change after a modicum of research into sp_configure
output. So, to that end, I tip my hat to David Letterman and offer you… my Top 10 configuration changes to make on an ASE database.

Introduction

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 configuration. This has gotten worse over time, as with the release of each new server, new
configuration options become available.
This article focuses specifically on configuring performance at the server level. For information on identifying queries to tune, check out the
article on finding poorly performing queries in ASE 15.
To this end, I’ve created a list of things I look for, most of which are automatic and underutilized. A few are things you can change after a
modicum of research into sp_configure output. So, to that end, I tip my hat to David Letterman and offer you… my Top 10 configuration changes
to make on an ASE database.
Most of these options are “no-brainers” — meaning that I make them automatically. Regardless, you should always track all of your changes,
and measure the results of the change.
My only caveat: Tuning a database management system is what the word implies; a balancing act between resources. Tuning decisions are
not made in isolation; they are made with all of the other system resources in mind. As a result, for many of these recommended configuration
changes, I am going to advise you to look at specific external resources, and/or to look at the results of sp_sysmon (ASE’s performance monitoring
stored procedure) to determine “how much.”
So without further ado, and in no particular order:

Dowload the Top 10 Server Configuration Tips for a New ASE 15 Installation document in pdf format below.

http://www.sybase.ch/files/White_Papers/...ips_wp.pdf