The problem is that the report never finish unless it's given a very short time window. I posted this in the Lync forum here and a very kind person who been in contact with Microsoft support posted the SQL script below.
The script creates two index that help speed up the stored procedure that fetch the data for the report.
Someone asked if this can be made more visibly so I created this blog / post. Enjoy!!
Please provide any feedback as this is my first blog / post about anything.
/*
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
Jackpotcity Casino - Goyang Tips
ReplyDeleteFind our Jackpotcity Casino Review - 블루 벳 먹튀 100% up to 에밀리벳리카즈 $1600. Play Slots, Blackjack, Roulette, Video Poker 아시안부키 - our 해외 토토 사이트 exclusive Jackpotcity Casino welcome bonus. 라이트닝바카라
Play exciting slots together with Rooster Rumble, Fortune Tiger and Rise of Apollo straight to your mobile devices. Slot Factory slots provide probably the most immersive mobile gaming with in style video games like Money Grows on Tree, Fishin' for Wins and Big Box Bonus. Luck 1xbet korean is on your facet with over three,600 exciting slot machines select from|to select from} throughout our three locations. The vibrant property also provides slots, blackjack, craps, roulette and a excessive limit expertise.
ReplyDelete