Base type: Orion.APM.ApplicationItem
Summary: This entity presents SQL database.
| Name | Type | Notes |
|---|---|---|
| DatabaseID | System.Int32 | The unique integer representation of SQL database. |
| ServerDatabaseID | System.Int32 | The unique integer representation of SQL server database. |
| OperationalState | System.Int32 | The integer value that contains the database operational state (Online, Restoring, Recovering,Recovery pending, Suspect, Emergency, Offline and Copying). |
| Collation | System.String | The string value that contains the database collation. |
| RecoveryModel | System.Int32 | The integer value that contains the database recovery model. |
| CompatibilityLevel | System.Int32 | The integer value that contains the database compatibility level. |
| LastBackup | System.DateTime | The date of last database backup. |
| TimeStamp | System.DateTime | The date of last poll for database. |
| DatabaseSize | System.Int64 | The long value that contains the database size. |
| TransactionLogSize | System.Int64 | The long value that contains the database log size. |
| Description | System.String | The string value that indicates database entity description. |
| Status | System.Int32 | The status of an database. |
| StatusDescription | System.String | The database status description. |
| DetailsUrl | System.String | URL to database details page. Used in alerting. |
| WebUri | System.String | The string value that specifies the database details page URL. It is used by Network Atlas. |
| ItemType | System.String | The type of application item. |
| AutoCloseOn | System.Boolean | The flag reflecting the value of database is_auto_close_on option. |
| ItemID | System.Int32 | |
| ApplicationID | System.Int32 | |
| Name | System.String | |
| ItemType | System.String | |
| Status | System.Int32 | |
| StatusDescription | System.String | |
| StatusLED | System.String | |
| UnManaged | System.Boolean | Default='false'. |
| UnManageFrom | System.DateTime | |
| UnManageUntil | System.DateTime | |
| DetailsUrl | System.String | |
| Image | System.String | |
| AncestorDisplayNames | System.String[] | |
| AncestorDetailsUrls | System.String[] | |
| StatusIconHint | System.String | |
| DisplayName | System.String | |
| Description | System.String | |
| InstanceType | System.Type | |
| Uri | System.String | |
| InstanceSiteId | System.Int32 | Default='0'. |
| FileGroups | Orion.APM.SqlDatabaseFileGroup | Defined by relationship Orion.APM.SqlDatabaseFileGroups (System.Hosting) |
| Files | Orion.APM.SqlDatabaseFile | Defined by relationship Orion.APM.SqlDatabaseFileDatabase (System.Hosting) |
| DatabaseStatus | Orion.APM.SqlDatabaseStatus | Defined by relationship Orion.APM.SqlDatabaseHostsStatus (System.Hosting) |
| Indexes | Orion.APM.SqlIndex | Defined by relationship Orion.APM.SqlDatabaseIndexes (System.Hosting) |
| Queries | Orion.APM.SqlQuery | Defined by relationship Orion.APM.SqlDatabaseQueries (System.Hosting) |
| Tables | Orion.APM.SqlTable | Defined by relationship Orion.APM.SqlDatabaseTables (System.Hosting) |
| SqlDatabaseMirroring | Orion.APM.SqlDatabaseMirroring | Defined by relationship Orion.APM.SqlDatabaseHostsSqlDatabaseMirroring (System.Hosting) |
| SqlDatabaseAlert | Orion.APM.SqlDatabaseAlert | Defined by relationship Orion.APM.SqlDatabaseAlertReferencesSqlDatabase (System.Reference) |
| SqlServer | Orion.APM.SqlServerApplication | Defined by relationship Orion.APM.SqlServerHostsSqlDatabase (System.Hosting) |
| SqlApplicationAlert | Orion.APM.SqlServerApplicationAlert | Defined by relationship Orion.APM.SqlServerApplicationAlertReferencesSqlDatabase (System.Reference) |