Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.
      Image Added



    • Storage Manager: Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
      Image Added



    • 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.
      Image Added



    • Session Manager: Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
      Image Added


         Image Added
 


Image Added

MS SQL DBA Tools



Image Added

MS SQL DBA Tools - Context Menu