AquaFold, Inc.

Sybase ASE DBA Database Administration Tools

Aqua Data Studio offers a suit of Sybase ASE Database Administration Tools for the monitoring, maintaining and tuning of the Sybase ASE server. It includes an Instance Manager, Storage Manager, Security Manager and Session Manager. These managers allow the monitoring and maintenance of Tablespaces, Database Objects, Sessions, Users and Permission via GUI.



Aqua Data Studio Sybase ASE Administration Tools Include:

Sybase ASE1 Instance Manager

Provides GUI view Search and Edit access for:

- General Instance Data (Instance Name, Database Name, Hardware Parameters, Version etc.)
- Instance Parameters View, Edit (258 entries)

Sybase ASE Session Manager

Provides GUI view and Search access for:

- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Port, Host, Database etc.)

Auto refresh data in specified intervals

Views for dynamically changed data such as Session Manager can be set for automatic refresh with intervals from 1 second and up.

Sybase ASE Storage Manager

Provides GUI view Search and Modify access for:

- Tree view of Databases, Datafiles and Log files
- Databases View, Create, Alter, Drop, DBCC Operation, Update Statistics, Set Checkpoint, Move Log, Set Online
- Device Usage View
- Objects View
- Database Devices View, Create, Alter, Drop, Reinitiate
- Dump Devices View, Create, Drop
- Caches View Cache, Alter Cache, Drop Cache

Sybase ASE Security Manager

Provides GUI view Search and Modify access for:

- Tree View for Logins, Roles
- Login View, Create, Alter, Drop
- Server Roles View, Alter
- Database Users View, Create, Alter, Drop
- Database Roles View, Create, Alter, Drop
- Database Groups View, Create, Alter, Drop

References

  1. ^ Sybase ASE Wikipedia article. Adaptive Server Enterprise is a relational database server, developed by Sybase.
    Sybase, an SAP Company Wikipedia article.

Home • Aqua Data Studio • Aqua Data Server • AquaClusters • Support • Store • Company • Privacy

Copyright © 2001–2012 AquaFold, Inc. All Rights Reserved.