Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

FREE monitoring tool for SYBASE

2 posts in Product Futures Discussion Last posting was on 2007-07-07 02:12:37.0Z
Gregory Surilov Posted on 2007-07-06 19:53:18.0Z
From: Gregory Surilov
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: FREE monitoring tool for SYBASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: 6 Jul 2007 12:53:18 -0700
X-Trace: forums-1-dub 1183751598 (6 Jul 2007 12:53:18 -0700)
X-Original-Trace: 6 Jul 2007 12:53:18 -0700,
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1944
Article PK: 97554

FREE monitoring tool for SYBASE

DBA Informer for SYBASE allows you to see:

1. All running processes - by clicking on a process you can
see some additional information on currently executing SQL,
such as:
· Running SQL
· Query plan
· Procedure nesting - If the process is running a nested
stored procedure, DBA Helper will provide you with a list
off all procedures in the order they were executed
· Some additional detailed info like network packet size,
packets and bytes sent and received, physical and logical
reads, pages modified, etc.

2. Lock information -
· locks in use
· blocked locks and the ability to alert users on any
blocking that is happening on the server.

3. Recent server activity -
· Detailed, graphical explanation of all deadlocks that
were generated on the server since the last server reboot.
· Recently executed SQL
· Most CPU-consuming SQL

4. Database statistics -
· Backup status (backup in progress, last backup failed,
transaction log consumption and utilization)
· Most frequently used objects
· Unused indexes
· Detailed information on all cached objects

5. Table information - this section is a very useful feature
of the tool. It allows you to see if tables are fragmented
(fragmentation usually prevents the optimizer from making
accurate and efficient decisions). It shows the following
information without making any kind of OS calls like
· Data page cluster ratio
· Index page cluster ratio
· Data row cluster ratio
· Large I/O efficiency
· Space utilization

6. Server information section displays:
· Detailed engine activity
· Procedure Cache Hit Ratio
· Live view of the SYBASE Server log

"Paul Horan[TeamSybase]" Posted on 2007-07-07 02:12:37.0Z
From: "Paul Horan[TeamSybase]" <phoran AT sybase DOT com>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <>
Subject: Re: FREE monitoring tool for SYBASE
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Message-ID: <468ef695$1@forums-1-dub>
Date: 6 Jul 2007 19:12:37 -0700
X-Trace: forums-1-dub 1183774357 (6 Jul 2007 19:12:37 -0700)
X-Original-Trace: 6 Jul 2007 19:12:37 -0700,
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1945
Article PK: 97555

Please post product announcements of this nature in the
news.3rd_party_products forum.

Paul Horan[TeamSybase]

<Gregory Surilov> wrote in message