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.
=> 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
|