Server Information menu
From the KM menu commands for the Server application instance, the Reports > Server Information menu accesses the following menu commands:
Menu command | Description |
|---|---|
Lock Info | Displays the lock status for the processes you enter |
Open Transactions | Displays information about the oldest open transaction in each database. This command requires System Administrator or Database Owner privileges. |
Server Configuration Params | Displays the name of the parameters and the minimum and maximum config_value and run_value settings related to sp_config |
Server Memory Allocation | Displays a complete breakdown of memory allocation |
Server Options | Displays a report on the options available for the selected server |
sp_who | Displays information about the users who are currently logged on to the selected server |
Suspect Databases | Displays the suspect databases, if any |
Other Server Information | Displays information about remote Microsoft SQL Servers and SQL Server attributes used by the Open Database Connectivity (ODBC) driver |