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.
![](/download/attachments/12660246255/ms_sql_dba_tool_instance_summary_tab.png?version=1&modificationDate=1665597889739&api=v2)
- Storage Manager: Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
![](/download/attachments/12660246255/ms-sql-dba-tool-storage-tree-tab.png?version=1&modificationDate=1665597891722&api=v2)
- 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.
![](/download/attachments/12660246255/ms_sql_dba_tool_security_logins_server_roles_tab.png?version=1&modificationDate=1665597890481&api=v2)
- Session Manager: Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
![](/download/attachments/12660246255/ms_sql_dba_tool_session_sessions_tab.png?version=1&modificationDate=1665597890883&api=v2)
![](/download/attachments/12660246255/dba_sqlserver_agent_400x150.png?version=1&modificationDate=1665597895503&api=v2)