Database Status (DatabaseStatus )

Shows the status of the database.

  • If the Database status is ONLINE, the value of DatabaseStatus parameter will be set to 0 indicating OK status.
  • If the Database is running in SINGLE_USER mode, value of DatabaseStatus parameter will be set to 1 indicating WARN status.
  • If the Database status is OFFLINE/SUSPECT, value of DatabaseStatus parameter will be set to 2 indicating ALARM status.

Note

The Database Status attribute in BMC ProactiveNet Performance Management is referred as DatabaseStatus parameter in BMC PATROL.

Default parameter attributes

Attribute

Default value

BMC PATROL properties

Application class

Command type

PSL

Platform

Microsoft Windows

Icon style

Graph

Unit

Status

Border range

0-2

Alarm1 range

1

Alarm2 range

2

Scheduling (poll time)

Not applicable

Active at installation

Yes

Parameter type

Consumer

Value set by

BMC ProactiveNet Performance Management properties

Monitor type

SQL Server Databases

Key Performance Indicator

No

Monitor for abnormalities

No

Graph by default

No

Availability

Yes

Response time

No

Normal distribution

Yes

Statistical

No

 

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