1 of 19 – Sybase ASE – Instance Manager – General
2 of 19 – Sybase ASE – Instance Manager – Parameters
3 of 19 – Sybase ASE – Storage Manager – Tree
4 of 19 – Sybase ASE – Storage Manager – Databases
5 of 19 – Sybase ASE – Storage Manager – Device Usages
6 of 19 – Sybase ASE – Storage Manager – Objects
7 of 19 – Sybase ASE – Storage Manager – Database Devices
8 of 19 – Sybase ASE – Storage Manager – Dump Devices
9 of 19 – Sybase ASE – Storage Manager – Caches
10 of 19 – Sybase ASE – Security Manager – Logins & Server Roles
11 of 19 – Sybase ASE – Security Manager – Logins
12 of 19 – Sybase ASE – Security Manager – Server Roles
13 of 19 – Sybase ASE – Database Users & Groups
14 of 19 – Sybase ASE – Security Manager – Users
15 of 19 – Sybase ASE – Security Manager – Groups
16 of 19 – Sybase ASE – Security Manager – Roles
17 of 19 – Sybase ASE – Session Manager – Sessions
18 of 19 – Sybase ASE – Session Manager – Session Stats
19 of 19 – Sybase ASE – Session Manager – Locks
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
- ^ Sybase ASE Wikipedia article. Adaptive Server Enterprise is a relational database server, developed by Sybase.
- ^ Sybase, an SAP Company Wikipedia article.