Seeing blocking activities in [LiteSpeedLocal] [LogShippingHistory] table when logshipping backup/restore taking place.
blocking statement exmaple:
use [LiteSpeedLocal]
DELETE FROM LogShippingHistory
WHERE PlanID = N'{233DFCBC-4821-41AE-A752-3161AA9EC359}'
AND DATEDIFF (mi, LogTimeStamp, GETDATE ()) >
(SELECT HistoryRetentionPeriod FROM LogShippingSubscriber WHERE PlanID = N'{233DFCBC-4821-41AE-A752-3161AA9EC359}')
Too much log shpping backup restore running at the same time.
Create the following index on the LogShippingHistory table.
USE [LiteSpeedLocal]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[LogShippingHistory] ([PlanID])
INCLUDE ([LogTimeStamp])
GO
6.5 version later. Index should be in placed.