Sybase ADDICT

To know when the last full backup of your database occurred you can look at the backupserver logfile, of course. But you don’t have to. Indeed you can find this information with Sybase ASE using the command “dbcc dbtable”.
Read more…

To list the tables that use datapages or datarows locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and (sysstat2 & 16384 = 16384 or sysstat2 & 32768 =32768)

To list tables that use allpages locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and sysstat2 & 8192 = 8192

I recently had to resync a warm standby database for a customer. When I can’t stop the transactions on primary database I use the “dump marker” clause while recreating the connection to the warm standby database with replication server. Indeed, you can resync a warm standby database anytime with no downtime on the primary database side using the “dump marker” method. Let’s assume the following warm-standy architecture:

- SYBPARFRDEV01_DS as the primary dataserver
- SYBPARFRDEV02_DS as the target dataserver
- SYBPARFRDEV02_RS as the replication server
- projectdb as the primary and replicated database

Read more…

A database administrator regularly need to address database performance issues. But database performance and tuning is not always an easy task because it can sometimes involve several complicated processes to find bottlenecks. For several years now, I use a free tool  named ASEMON released under GNU GPL license (yes, it is open source !!). ASEMON is developed and maintained by Jean-Paul Martin at Sybase France. Here is a short description of the product…

1°) What is ASEMON ?

ASEMON is an efficient and reliable tool that collect and store performance metrics from various Sybase products such as Sybase ASE, Replication Server and Sybase IQ. It is made of two components:

Read more…

Embarcadero software and ISUG (International Sybase User Group) offer a free online webinar about query optimization for Sybase ASE. In this particular webinar, you will be able to ask directly your questions to optimize your sql queries with a bunch of top Sybase ASE experts like Peter Dobler and Kevin Sherlock. Query performances, Sybase ASE optimizer and optimizer mode will be discuss. This webinar is a valuable way to acquire or expand your knowledge.

3 sessions of this free webinar are scheduled October 21th from 7:00AM to 7:00PM.
See the schedule here.