Versions Compared

Old Version 3

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

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

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.
MS SQL DBA Tools - Instance ManagerImage RemovedImage Added

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Summary tab
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find

Available Operations for Parameters tab
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Edit Parameter: Edits the value of the currently selected parameter

Available Operations for Server Logs tab
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Archive: Displays the server log archive selected

Summary Tab - Provides a summary of the MS SQL instance

SQL Server Component : Shows the component name
Value: Shows the specification of the component

Image AddedMS SQL DBA Tools - Instance Manager - Summary TabImage Removed

MS SQL DBA Tools - Instance Manager - Summary Tab


 
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)
Image AddedMS SQL DBA Tools - Instance Manager - Instance Parameters TabImage Removed

MS SQL DBA Tools - Instance Manager -Instance Parameters Tab


 
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
Image AddedMS SQL DBA Tools - Instance Manager - Server Logs TabImage Removed

MS SQL DBA Tools - Instance Manager - Server Logs Tab

...