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
GO
DROP INDEX ON .
GO
*/

CREATE NONCLUSTERED INDEX ON .
(
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC
)
INCLUDE (   ,
            ,
            ,
            ) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON
go

/*
USE
GO
DROP INDEX ON .
GO
*/

CREATE NONCLUSTERED INDEX ON .
(
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC,
            ASC
)
INCLUDE (   ,
            ,
            ,
            ) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON
go
 

Archives