PDF

Introduction

SybTools is a small collection of utilities for developing, monitoring and performance tuning of Sybase Adaptive Server Enterprise. They have all been developed by Dan Haywood.

The tools fall into two categories:

• Console

  Console is an Eclipse RCP-based Java desktop application that provides a platform for a number of DBA-style utilities. Console uses Eclipse's ability to deliver separate units of functionality as separately installable "features".

  The first (and currently only) piece of functionality provided for Console is a viewer to show blocking between processes. This saves the DBA having to use sp_lock and sp_who to diagnose blocking.

• SQL Scripts

  SQL scripts provide a collection of stand-alone SQL scripts and stored procedures that provide various functionality. Examples include error handling and unique id generation.

If there's some feature you'd like us to include in Console, or some Sybase-related SQL script that you'd like to share, please get in touch. The email is at the bottom of this page.