MS SQL DBA Tools - 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. | |
Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available. Available Operations for Summary tab Available Operations for Parameters tab Available Operations for Server Logs tab | |
Summary Tab - Provides a summary of the MS SQL instance SQL Server Component : Shows the component name | |
Parameters Tab - Displays a list of MS SQL instance parameters Parameter: Name of the parameter Value: Value of the parameter Run: Current value Min: Minimum value of the parameter Max: Maximum value of the parameter Dynamic: Indicates whether the parameter can be changed during a session (dynamic), can be changed on the server restart (static) or not changeable (read-only) | |
Server Logs Tab - Displays a list of MS SQL instance server logs Log Date: Shows the date and time Process Info: Specifies the type of process Text: Log description |