Sybase ADDICT

MDA tables are very useful to understand what’s going on within your dataserver, so you can carry out accurate and successful performance and tuning campaigns. In this post I publish few basic Sybase stored procedures to use with MDA tables that focus on databases objects activity only (but I may release more MDA stored procedures in the future).

If you haven’t installed yet MDA tables in your Sybase Adaptive Server, you can refer to my previous post HowTo install MonTables to install them. Read more…

This sql query tells you if Direct IO is supported on your platform:

select low from spt_values
where  type='io'

A value of 1 means “Yes, direct io is supported on this platform”.
A value of 0 means “No, direct io is NOT supported on this platform”.

Read this nice post from David Wein about Direct I/O device option.

Want to know what platform your Sybase Adaptive Server is running on ? No need to connect to the machine to find out, just run this little query:

select name from master..spt_values
where type = 'E' and number = 1
go

For me it shows:

name
--------------------------------------------------------
linux

Nice…

The following transact-sql code will help you to find all defined rules in a Sybase ASE database.

select sysobjects.name as "rule name",
object_name(syscolumns.id) as "table name",
syscolumns.name as "column name"
from sysobjects, syscolumns
where object_name(syscolumns.domain)=sysobjects.name
and sysobjects.type = 'R'
go

The output displays the table and column to which the rules are bound.

Quickly find out the database’s tables having identity columns:

select object_name(id) as "tablename",name as "column_name"
from syscolumns where status =128
go

Enjoy