Brand

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

  1. ^ SQL Server Wikipedia article. Microsoft SQL Server is a relational database server, developed by Microsoft.
  2. ^ Microsoft Corporation Wikipedia article.