MS SQL Server DBA Database Administration Tools
Aqua Data Studio offers a suite of SQL Server Database Administration Tools for the monitoring, maintaining and tuning of the SQL Server. It includes an Instance Manager, Storage Manager, Security Manager, Session Manager and Agent Manager. These managers allow the monitoring and maintenance of Database Objects, Datafiles, Sessions, Users and Permissions via GUI.
Aqua Data Studio SQL Server Administration Tools Include:
SQL Server1 Instance Manager
Provides GUI view Search and Edit access for:
- Instance Summary (SQL Server Component, Value)
- Instance Parameters View, Edit
- Server Logs
SQL Server Session Manager
Provides GUI view and Search access for:
- Session Details with current statement, Kill Session, Last SQL
- Session Statistics
- Session Grouping (By Process ID, Context ID, and more)
- Session Locks
- Session Grouping (By Process ID, Context ID etc.)
SQL Server Agent Manager
Provides GUI view Search and Modify access for:
- Alerts View, Create, Alter, Drop
- Operators View, Create, Alter, Drop
- Jobs View, Start, Stop, Enable, Disable, History
SQL Server Storage Manager
Provides GUI view Search and Modify access for:
- Tree view of Databases, Datafiles, Log files
- Databases View, Create, Alter, Drop, Backup, Restore, Attach, Detach, DBCC Operation, Update Statistics, Set Checkpoint, Shrink, Set Online
- Datafiles View
- Table, Index Storage View
- Devices Backup View, Create, Drop
SQL Server Security Manager
Provides GUI view Search and Modify access for:
- Tree View for Logins, Server Roles
- Login View, Create, Alter, Drop
- Server Roles View, Alter
- Tree View for Users, Roles
- Database Users View, Create, Alter, Drop
- Database Roles View, Create, Alter, Drop
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.
References
- ^ SQL Server Wikipedia article. Microsoft SQL Server is a relational database server, developed by Microsoft.
- ^ Microsoft Corporation Wikipedia article.