Lync 2013 Monitoring is great … well when it works 🙂

Today one customer wanted to open Response Group Usage Report and got nothing after 15 minutes on waiting.

The reason was a broken index in lcscdr database.

And the fix (Prefer it after full backup)

Run this query to rebuild the index:

/*
USE
[LcsCDR]
GO
DROP
INDEX [IX_SessionDetails_CorrelationId_SessionIdTime] ON [dbo].[SessionDetails]
GO
*/
CREATE
NONCLUSTERED INDEX
[IX_SessionDetails_CorrelationId_SessionIdTime]
ON [dbo].[SessionDetails]
(
            [CorrelationId] ASC,
            [SessionIdTime]
ASC,
            [ReplacesDialogIdTime]
ASC,
            [ReplacesDialogIdSeq] ASC,
            [CallFlag] ASC,
            [MediaTypes]
ASC,
            [User1ClientVerId]
ASC,
            [User2ClientVerId]
ASC,
            [SessionIdSeq]
ASC,
            [SessionStartedById]
ASC,
            [User1Id]
ASC,
            [User2Id]
ASC,
            [ReferredById]
ASC
)
INCLUDE (   [TargetUserId],
            [ResponseTime],
            [ResponseCode],
            [SessionEndTime]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go
/*
USE
[LcsCDR]
GO
DROP
INDEX [IX_SessionDetails_ReplacesDialogIdTime_SessionIdTime] ON
[dbo].[SessionDetails]
GO
*/
CREATE
NONCLUSTERED INDEX
[IX_SessionDetails_ReplacesDialogIdTime_SessionIdTime]
ON [dbo].[SessionDetails]
(
            [ReplacesDialogIdTime]
ASC,
            [SessionIdTime]
ASC,
            [ReplacesDialogIdSeq]
ASC,
            [CallFlag]
ASC,
            [MediaTypes]
ASC,
            [User1ClientVerId]
ASC,
            [User2ClientVerId]
ASC,
            [SessionIdSeq]
ASC,
            [SessionStartedById]
ASC,
            [User1Id]
ASC,
            [User2Id]
ASC,
            [CorrelationId]
ASC,
            [ReferredById]
ASC
)
INCLUDE
(   [TargetUserId],
            [ResponseTime],
            [ResponseCode],
            [SessionEndTime]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go