|
|
The following data is available in the Double-Take Reporting Service tables. Each time data is collected, it is written to a new row in the table. You can link data together using time stamps and unique IDs to see how data and states change over time.
The following data is available in the Server table.
ServerGUID
The unique ID Double-Take assigns to the server
Timestamp
The date and time the server data was collected
Name
The name of the server
Status
The status of the server
The following data is available in the Job table.
JobId
The unique ID that Double-Take assigns to the job
Timestamp
The date and time the job data was collected
SourceUniqueID
The unique ID Double-Take assigns to the job's source server
TargetUniqueID
The unique ID Double-Take assigns to the job's target server
SourceHostUri
The source's URI (uniform resource identifier)
TargetHostUri
The target's URI (uniform resource identifier)
Name
The name that Double-Take assigned to the job. You may have modified the job name.
Workload
The type of workload the job is using
Type
The job type. This value equates to the Job Type column in the top right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
CreatorUserName
The name of the user that created the job
Health
The high level health, or state, of the job. This value equates to the colored icons seen in the first column in the top right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
HighLevelState
The overall state of the job. This value equates to the Activity column in the top right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
LowLevelState
The low level state of the job. This value equates to the Additional Information field in the bottom right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
TargetState
The state of the data on the target. This value equates to the Target data state field in the bottom right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
CanEdit
Indicates if the job can currently be edited
CanDelete
Indicates if the job can currently be deleted
CanStart
Indicates if the job can currently be started
CanStop
Indicates if the job can currently be stopped
CanPause
Indicates if the job can currently be paused
CanFailover
Indicates if the job can currently be failed over
CanFailback
Indicates if the job can currently be failed back
CanRestore
Indicates if the job can currently be restored
CanReverse
Indicates if the job can currently be reversed
CanUndoFailover
Indicates if a failed over job can currently be undone
The following data is available in the Connection table.
ManagedConnectionId
The incremental counter used to number connections. The number is incremented when a connection is created. It is also incremented by internal actions, such as an auto-disconnect and auto-reconnect. The lowest available number (as connections are created, stopped, deleted, and so on) will always be used. The counter is reset to one each time the Double-Take service is restarted.
JobId
The unique job ID associated with this connection
Timestamp
The date and time the connection data was collected
SourceUniqueID
The unique ID Double-Take assigns to the job's source server
TargetUniqueID
The unique ID Double-Take assigns to the job's target server
BandwidthCollar
The bandwidth limiting that has been set or the keyword Unlimited if no bandwidth limit has been set
CompressionEnabled
Indicates if data is being compressed before it is sent to the target
CompressionLevel
The level of compression
DiskQueueBytes
The amount of disk space being used to queue data on the source
InitialMirrorComplete
Indicates if the initial mirror has been completed
MirrorBytesRemaining
The total number of mirror bytes that are remaining to be sent from the source to the target
MirrorBytesSent
The total number of mirror bytes that have been transmitted to the target
MirrorBytesSkipped
The total number of bytes that have been skipped when performing a difference or checksum mirror. These bytes are skipped because the data is not different on the source and target.
MirrorBytesTransmitted
The total number of compressed mirror bytes that have been transmitted to the target. If compression is disabled, this will be the same as MirorBytesSent. .
MirrorOpsQueued
The total number of mirror operations in the queue
MirrorPermillage
The percentage of the mirror that has been completed
MirrorState
The state of mirroring. This value equates to the Mirror Status column in the top right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
PeerMemoryLow
Indicates if the target is running low on memory based on the Amount of system memory to use setting on the target server's queue properties. See Double-Take queue for details.
ReplicationBytesQueued
The total number of replication bytes in the source queue
ReplicationBytesSent
The total number of replication bytes that have been transmitted to the target
ReplicationBytesTransmitted
The total number of compressed replication bytes that have been transmitted to the target. If compression is disabled, this will be the same as ReplicationBytesSent. .
ReplicationOpsQueued
The total number of replication operations in the queue
ReplicationState
The state of mirroring. This value equates to the Replication Status column in the top right pane on the Manage Jobs page. See the managing and controlling jobs topic for any job type for additional details.
Restoring
Identifies if the connection is actively restoring
SourceAvailable
Identifies if the target was able to communicate with the source server
SourceEngineAvailable
Identifies if the target was able to communicate with Double-Take on the source
SourceMachineName
The name of the server associated with this connection
StartTime
The date and time the connection was initiated
TargetAvailable
Identifies if the source was able to communicate with the target server
TargetEngineAvailable
Identifies if the source was able to communicate with Double-Take on the target
TargetRoute
The IP address identifying the route to the target
TargetMachineName
The name of the target server associated with this connection
TargetQueueBytes
The number of bytes queued on the target
TargetState
The state of the target
TotalBytesSent
The total number of mirror and replication bytes that have been transmitted to the target
TotalBytesTransmitted
The total number of compressed mirror and replication bytes that have been transmitted to the target. If compression is disabled, this will be the same as TotalBytesSent. .
TotalOpsQueued
The total number of mirror and replication operations that are in the source queue
TransmissionMode
Indicates if data is actively being transmitted to the target
SourceClusterResourceState
The state of the Double-Take Source Connection resource, if it is being used by a cluster-aware job on a Double-Take source cluster
Server table