MS SQL Server DBA Tools (Revision #3)

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