FREE monitoring tool for SYBASE

[unknown]

FREE monitoring tool for SYBASE

www.dbainformer.com

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
optdiag:
· 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

[Sherlock, Kevin]

cool, except that it _requires_ SDK 10 or 11. Most folks out there probably
don't have this SDK any longer.

Any chance of getting a version which is 12.x or even 15.x compatible?

<Gregory Surilov> wrote in message news:***@sybase.com...
FREE monitoring tool for SYBASE

www.dbainformer.com

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
optdiag:
· 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

[unknown]

Post by Sherlock, Kevin
cool, except that it _requires_ SDK 10 or 11. Most folks
out there probably don't have this SDK any longer.
Any chance of getting a version which is 12.x or even 15.x
compatible?

It is already compatible to 12.x and 15.x

[Rob Verschoor]

Please don't cross-post to all newsgroups.

Rob V.


<Gregory Surilov> wrote in message news:***@sybase.com...
FREE monitoring tool for SYBASE

www.dbainformer.com

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
optdiag:
· 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