DBA Tools (Revision #0)

• Storage and Session managers now have a Tree Table tab displaying the server content as a tree and the first column (the tree) is always displayed as you scroll the other columns
  
• The toolbar actions of each DBA tool display actions particular for the currently selected sub tab of the tool
  
• All DBA Tools now use the new Sortable Table with a Quickfilter combobox

The MS SQL Server Database Administration (DBA) Tools provide users with tools to administer, manage and monitor all aspects of a MS SQL Server database. The tools may be accessed from the application DBA Tools menu or from the schema browser context sensitive popup menu.

The following is a list of tools provided with a description of each tool 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.
  => Documentation
  
  
• Storage Manager: Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
  => Documentation
  
  
• 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.
  => Documentation
  
  
• Session Manager: Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
  => Documentation
  
  
• SQL Server Agent Manager: Provides manageability for the SQL Server Agent. This includes operators, jobs and alerts.
  => Documentation
  
  

The Sybase Database Administration (DBA) Tools provide users with the tools to administer, manage and monitor all aspects of a Sybase 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 of the Sybase instance allowing the user to view and modify server parameters and viewing server version information.
  => Documentation
  
  
• Storage Manager: Provides manageability of the Sybase databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
  => Documentation
  
  
• Security Manager: Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase database.
  => Documentation
  
  
• Session Manager: Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.
  => Documentation