Infrastruktur blog

Globeteam hjælper virksomheder med at styrke deres forretning gennem en velfungerende infrastruktur og tilbyder både strategisk rådgivning, teknisk bistand og implementering. Her på bloggen deler Globeteams erfarne infrastruktur eksperter de vigtigste nyheder og trends inden for it-infrastruktur og giver tips og konkret vejledning i relation til deres arbejde med forskellige produkter og løsninger.




Du kan se flere indlæg fra Globeteams infrastruktur konsulenter på deres LinkedIn side her og læse mere om de ydelser, infrastruktur teamet tilbyder, på Globeteams hjemmeside her

Skype for Business – RGS Reports – BUG

Af Thomas Juhl Olesen, Globeteam Infrastruktur.

I have recently seen this issue at 2 different customer sites – both with back-end SQL – (Formerly known as Enterprise Edition)

One was inplace upgraded the other one migrated to a clean installed Skype for Business side-by-side pool

The Response Group Usage Report is failing – it is trying for a very long time until finally timeout.

The solution is to recreate the index [IX_SessionDetails_CorrelationId_SessionIdTime] on [dbo].[SessionDetails]

I found this posted on a technet forum also – and indeed it seems to work fine :)

Run this as a new query against the LcsCDR database in SQL Management Studio

/*
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

Then wait a few minutes and retry the Response Group usage report.

rgsd

Optimer din forretning og dine it-investeringer

Er du interesseret i at vide mere om Globeteams ydelser, og hvordan vi kan hjælpe netop din forretning?