Database Resources menu


From the KM menu commands for the Server and the Database application instances, the Reports > Database Resources menu accesses the following menu commands:

Menu command

Description

DB File Info

Uses the sp_helpfile stored procedure to display information about a file used to store information about a database.

DB Options

Uses the sp_dboption stored procedure to display a list of the options set on a database.

Filegroup Info

Uses the sp_helpfilegroup stored procedure to display information about a filegroup.

Space Used

Uses the sp_spaceused stored procedure to display the amount of space used or the amount of space free for a database or table space.

 

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

BMC PATROL for Microsoft SQL Server 9.5