Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Get Live Help
You have selected a product bundle. Can you please select the individual product for us to better serve your request.*
There is not a technical support engineer currently available to respond to your chat. For prompt service please submit a request using our service request form.
The following articles may solve your issue based on your description.
This collection provides detailed statistics for each lock.
The total number of deadlocks for the lock type.
A Deadlock occurs when multiple SQL Server sessions request conflicting locks in such a way that two locks are blocked by one another.
The summary of all lock requests, both for new locks and lock conversions.
The number of lock requests per second that timed out, including requests for NOWAIT locks.
The name of the lock type.
Total Wait Time (seconds)
The total lock wait time for the lock type.
The total number of wait events for the selected lock type.
This collection provides a list of locks used within a SQL Server instance, grouped by the lock type, mode, and status.
The server process ID of the current user process.
The time the session was created.
SQL Server Login name.
The database that is being used by the current process.
The index that is being used by the current process (if any).
The name of the currently locked object.
The number of locks that share the same object and type.
The type of the resource that is currently being locked (Database, Table, Page, Row, Extent and so on).
The kind of lock that is being applied to the resource (Shared, Exclusive, Update, IntentShared, IntenExclusive and so on).
The status of the lock can be one of the following:
This collection specifies the Log shipping tree and the primary and secondary servers' file location and operations.
The SQL process ID of the process that ran the query.
The row identifier.
The current primary server.
The name of the server (primary server for the parent node, and secondary server for all subsequent child nodes).
Refers to either of the following databases:
An indicator of an error that occurred.
The maximum allowed time (in minutes) before a Log Shipping alert occurs.
This parameter can refer to either of the following values:
The alert displayed in the Error Log drilldown if the threshold is exceeded.
Threshold Alert Enabled
The alert displays only if it is enabled.
Last Change Type
The type of the activity that resulted in the log shipping’s most recent change of state (Backup, Copy or Restore).
Last Backup Filename
The name of the file that was most recently backed up.
Last Backup Last Updated
The time at which the most recent backup operation was carried out.
During an outage, no alerts will occur when thresholds are exceeded (for both the parent and child nodes).
If this field is blank, no outage will take place.
Backup In Sync
Indicates either of the following backup statuses:
The last time a log transaction backup occurred in the primary server.
Last Copied Filename
The last backup file that was copied to the secondary server.
Last Copied Last Updated
The time when the backup file was most recently copied from the primary to the secondary server.
Last Loaded Filename
The name of the backup file that was most recently restored to the secondary server.
Last Loaded Last Updated
The time when the backup file was most recently restored to the secondary server.
The date when the transaction log backup file was most recently copied to the secondary server.
Indicates whether copying is enabled.
Indicates whether loading is enabled.
Load in Sync
The load synchronization can have either of the following statuses:
The date of the last restored transaction log load file to the secondary server.
Primary Server Time
The current timestamp at the primary server.
Secondary Server Time
The current timestamp at the secondary server.
Monitor Server Time
The current timestamp at the monitored server.
The collection shows Log Shipping Errors.
The session ID for the backup/copy/restore/job.
An incremental number indicating the correct order of information for errors that span multiple records.
The date and time at which the record was created.
The name of the server.
The name of the database.
The type of log shipping job.
0 = Backup.
1 = Copy.
2 = Restore.
Agent Type Description
The description of the Agent Type.
The source of the Error Message.
If no Error for last hour - OK.
If an error found on the last 15 minutes - ERROR.
If there is an error between last hour and last 15 minutes nothing would be raised so the last error status should remain.
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The document was helpful.
I easily found the information I needed.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
Upgrade to IE 11 Click here
Upgrade to Chrome Click here
If you continue in IE8, 9, or 10 you will not be able to take full advantage of all our great self service features.