Brand

Sybase ASE DBA Database Administration Tools

Aqua Data Studio offers a suite 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 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 (Sybase component, Value etc.)
  • Instance Parameters View, Edit (398 entries)

Sybase ASE Session Manager

Provides GUI view and Search access for:

  • Session Details, Kill Session, Last SQL, Show Plan
  • Session Statistics
  • Session Locks
  • Session Grouping (By Process ID, Status, and more)

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:

  • Databases, Datafiles, Log files View
  • 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, Alter, Drop Cache

Sybase ASE Security Manager

Provides GUI view Search and Modify access for:

  • Tree View for Logins, Server Roles
  • Login View, Create, Alter, Drop
  • Server Roles View, Create, Alter, Drop
  • Tree View for Users, Groups and Roles
  • Users View, Create, Alter, Drop
  • Groups View, Create, Alter, Drop
  • Roles View

References

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