Monitor Databases in Model Explorer
The Monitor Databases dialog in Model Explorer helps users monitor and manage the databases used by their models. This dialog provides information about the databases that are linked to the modeling environment, allowing users to monitor their status, performance, and activity.
 |
The Monitor Databases dialog is enabled only for SQL System Administrators, Modeler System Administrators, and Database Administrators.
|
Using the Monitor Databases dialog
This section explains the various functionalities and features of this dialog.
The Monitor Databases dialog
To open the Monitor Databases dialog:
1. Open Model Explorer.
2. Right-click on the database instance and select Monitor Databases....
The Monitor Databases dialog opens and displays a list of databases with the related information. From this open dialog, you can press F1 to open this help page.
|
|
When you open the dialog, some databases may be auto-selected. This is an indication that those databases may have issues such as, orphan links, fragmentation or oversized log files. The list also displays those databases that require migration, although those databases are not selected. For databases that require migration, perform the steps listed here.
|
You can perform the following functions with this dialog:
Search for Databases — Only SQL Server Administrators have access to this feature. This button searches the SQL Server instance and lists all Modeler databases available in the selected instance. The list also displays the database metrics such as, the percentage of fragmentation of the database on the storage device, the number orphan links if any, the size of the log file, and the date when the database was last optimized. You can view only those databases that you have access to. The list also contains names of those databases that require migration to the latest database schema.
Optimize Indexes — Optimizes the indexes of the selected databases. The button is enabled only when the fragmentation (on the storage device) is more than 10%.
Shrink Logs — Shrinks the log file sizes of the selected databases. The button is enabled only if the log file size is more than 2 GB. When you click this button, the log file size is reduced to the minimum size set on the instance, which is usually 72 MB.
Remove Orphan Links — Removes any orphan links from the selected databases. The button is enabled only when there are existing orphan links in a database.
Optimize Selected — Performs all of the above operations (optimizes the indexes, shrinks the log files, and removes any orphan links) on the selected databases.
Admin Audit Logs — Opens the Admin Audit Logs dialog. Only Modeler System Administrators and SQL Server Administrators have access to this feature. For more information on this dialog, click here.
Close — Closes the Monitor Databases dialog.