Sybase ADDICT

Sybase regularly provides podcasts or webcasts about their products.

Here is a bunch of podcasts about ASE (Adaptive Server Enterprise) targeting various “perfomance & tuning” topics. Enjoy

+ General Best Practices

Tune in with Sybase ASE experts and special guest Peter Thawley, senior director and architect for Sybase engineering, to explore the best practices in performance and tuning for database applications based on Adaptive Server Enterprise.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ Monitoring Practices and Tools

In this Podcast, Stefan Karlsson and guest Jeff Tallman discuss the details of monitoring within the ASE environment.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ Tips & Tricks

ASE experts Stefan Karlsson, Jeff Tallman, Rob Verschoor and Steve Bologna share their tips and tricks for improving database performance.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “CPU interaction”

David Wein and Stefan Karlsson discuss ASE’s kernel and how ASE interacts with the OS in the first of this 3-part discussion on system tuning.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Task management”

Sybase drill down into ASE task management in the second of this 3-part series on system tuning.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Monitoring & Configuration”

In the last of this 3-part discussion on system tuning Sybase tackles monitoring and configuration.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

+ System Tuning “Spinlocks”

Stefan Karlsson discusses spinlocks, what they are and how to monitor and tune.

Audio clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

Find out the dataserver’s page size without using global variables like @@pagesize or @@maxpagesize.

When you work with heterogeneous versions of Sybase Ase (12.0.x and 12.5.x or 15.x), this query can help you while coding your dba stored procedures…

declare @page_size int
select  @page_size = low /1024 from master.dbo.spt_values
where type = 'E' and number = 1
go

It will produce the result in Kb. This works with Sybase ASE from version 11.x to 15.x.

Might be a good idea to share some usefull code snippet. Let’s start with a simple query to find out text/image columns in a database. This one will build a list of columns using text/image columns for each tables:

select user_name(o.uid) as "owner",
o.name as "table",
c.name as "column"
from   sysobjects o, syscolumns c
where  o.type = "U"
and    o.id = c.id
and    c.type in (34,35)
order  by 1,2,3
go

Enjoy