Base type: System.Entity
Summary: This entity presents SQL database. Used in alerting.
| Name | Type | Notes |
|---|---|---|
| ApplicationID | System.Int32 | The unique integer representation of parent application. |
| DatabaseID | System.Int32 | The unique integer representation of SQL database. |
| DatabaseName | System.String | The string value that contains database name. |
| Collation | System.String | The string value that contains the database collation. |
| OperationalState | System.Int32 | The integer value that contains the database operational state (Online, Restoring, Recovering,Recovery pending, Suspect, Emergency, Offline and Copying). |
| RecoveryModel | System.Byte | The integer value that contains the database recovery model. |
| CompatibilityLevel | System.Byte | The integer value that contains the database compatibility level. |
| LastBackup | System.DateTime | The date of last database backup. |
| DatabaseSize | System.Int64 | The long value that contains the database size. |
| DatabaseFreeSpace | System.Int64 | The long value that contains the database free space. |
| DatabaseFreeSpaceInPercents | System.Int64 | The percentage representation of free database space. |
| TransactionLogSize | System.Int64 | The long value that contains the database log size. |
| TransactionLogFreeSpace | System.Int64 | The long value that contains the transaction log free space. |
| TransactionLogFreeSpaceInPercents | System.Int64 | The percentage representation of free transaction log space. |
| Status | System.Int32 | The status of an database. |
| DisplayStatus | System.String | The status of an database. |
| DatabaseTimeStamp | System.DateTime | The date of last poll for database. |
| MirroringState | System.Int32 | The mirroring state of an database. |
| DaysFromLastBackup | System.Int32 | Number of days passed since last database backup. |
| DisplayName | System.String | |
| Description | System.String | |
| InstanceType | System.Type | |
| Uri | System.String | |
| InstanceSiteId | System.Int32 | Default='0'. |
| SqlApplicationAlert | Orion.APM.SqlServerApplicationAlert | Defined by relationship Orion.APM.SqlServerApplicationAlertHostsSqlDatabaseAlert (System.Hosting) |
| SqlDatabase | Orion.APM.SqlDatabase | Defined by relationship Orion.APM.SqlDatabaseAlertReferencesSqlDatabase (System.Reference) |