Skip to Content

Database application menu

The following topics are at the first level in the KM menu command structure for the Database application instances. Click linked topics to drill down into the KM menu commands for the Database application instance.

Menu or menu command

Description

Add PATROL User to Database

Uses sp_adduser to add the PATROL user name associated with the instance to the list of user names for the database monitored by this instance
User name must have System Administrator privileges.
Note: Under normal circumstances, you do not need this menu command. PATROL for Microsoft SQL Server adds the Patrol user to databases at the time they are discovered so that it can monitor them. Occasionally, upon a restore of a backup database or in some other circumstances, such as moving a database from one SQL server to another, the database does not have the Patrol user. You would use this menu command to add the PATROL user under those circumstances.
Microsoft SQL Server does not allow you to add sa as a user of a database; sa is a reserved login name in SQL Server.

Menu of commands that perform database consistency checks (dbcc)

DEBUG

Toggles DEBUG on and off for menu commands globally and for each parameter individually

Object Space Monitor

Enables you to select which objects to monitor
The ObjectSizeColl parameter collects the data every four hours (default setting). Activate the Refresh Parameters command (below) to create the Objects application instance icon and obtain initial data.
The Object Space Monitor command is also available in the Server application menu under KM Admin.

Refresh Parameters

refreshes all of the database parameters
For more about this menu command, see Refreshing-parameters.

Menu of reports containing information about databases

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Microsoft SQL Server 9.5