패브릭 복제 확인 방법

use rtc

SELECT FE.Fqdn as 'FE서버', count(*) as '할당유저수' FROM Resource R with(nolock)
INNER JOIN ResourceDirectory RD ON RD.ResourceId = R.ResourceId
INNER JOIN RoutingGroupAssignment RGA ON RGA.RoutingGroupId = RD.RoutingGroupId
INNER JOIN FrontEnd FE ON FE.FrontEndId = RGA.FrontEndId
GROUP BY FE.Fqdn

 

각 프론트엔드 서버별 사용자 수가 적절하게 분배 되었는지 확인