AquaFold, Inc.

MS SQL Server DBA Database Administration Tools

Aqua Data Studio offers a suit 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 Tablespaces, Database Objects, 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 (Instance Name, Database Name, Hardware Parameters, Version etc.)
- Instance Parameters View, Edit
- Server Logs

SQL Server Session Manager

Provides GUI view and Search access for:

- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Port, Host, Database 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 Job, Stop Job, Enable Job, Disable Job, Job History

SQL Server Storage Manager

Provides GUI view Search and Modify access for:

- Tree view of Databases, Datafiles and Log files
- Databases View, Create, Alter, Drop, Backup, Restore, Attach, Detach, DBCC Operation, Update Statistics, Set Checkpoint, Shrink, Set Online
- Datafiles View
- Backup Devices View, Create Backup, Drop Backup

SQL Server 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

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.
    Microsoft Corporation Wikipedia article.

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

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