MS SQL DBA Tools
The MS SQL Database Administration (DBA) Tools provide users with the tools to administer, manage and monitor all aspects of a MS SQL database. The tools may be accessed from the application DBA Tools menu or from the schema browsers context sensitive popup menu.
The following is a list of tools provided with a description of each tools functionality.
- Instance Manager: Provides manageability for the MS SQL instance allowing a user to view and modify server parameters and to view server version information and the server logs.
![MS SQL DBA Tools Instance Manager](https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation22.1/page/27/attachment/AD30F8D2-62A6-A0B9-AB26-B256FE9F6CDD/mssql-instance-manager-400x150-png)
- Storage Manager: Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
![MS SQL DBA Tools Storage Manager](https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation22.1/page/27/attachment/266B1F1E-A8C2-1583-874C-CE6D6FDBC0B0/mssql-dbatool-storage-manager-400x150-png)
- Security Manager: Provides manageability for logins, server roles, users, roles and profiles allowing a user to manage permissions, roles and security of the MS SQL database.
![MS SQL DBA Tools Security Manager](https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation22.1/page/27/attachment/4A1726B4-EFEB-3D6C-AB25-69EB3D3D399B/dba-sqlserver-security-400x150-png)
- Session Manager: Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
![MS SQL DBA Tools Session Manager](https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation22.1/page/27/attachment/E8CBDD7C-1FCA-65AB-E22F-D385A96BFD14/dba-sqlserver-session-400x150-png)