PDA

View Full Version : Load Based Handover performance monitoring



electron
2010-12-29, 09:10 PM
Hi Friends,


How we can measure the performance of Load based HO after feature activation on a cell or RNC level?



Thanks

scientist
2010-12-29, 09:23 PM
Hi Friends,


How we can measure the performance of Load based HO after feature activation on a cell or RNC level?



Thanks

SELECT
DATE_ID,

((sum(pmNoOutIratCcSuccess)/sum(pmNoOutIratCcAtt))*100) as PS_IRAT_HOSR,
((sum(pmNoSuccessOutIratHoSpeech)/sum(pmNoAttOutIratHoSpeech))*100) as IRAT_HOSR_Speech,
((sum(pmNoSuccessOutSbHoSpeech)/sum(pmNoAttOutSbHoSpeech))*100) as LOC_BASE_HOSR


FROM DC.DC_E_RAN_GSMREL_DAYBH
where date_id>=getdate()-35
group by date_id
ORDER BY DATE_ID ASC

electron
2010-12-29, 09:33 PM
SELECT
DATE_ID,

((sum(pmNoOutIratCcSuccess)/sum(pmNoOutIratCcAtt))*100) as PS_IRAT_HOSR,
((sum(pmNoSuccessOutIratHoSpeech)/sum(pmNoAttOutIratHoSpeech))*100) as IRAT_HOSR_Speech,
((sum(pmNoSuccessOutSbHoSpeech)/sum(pmNoAttOutSbHoSpeech))*100) as LOC_BASE_HOSR


FROM DC.DC_E_RAN_GSMREL_DAYBH
where date_id>=getdate()-35
group by date_id
ORDER BY DATE_ID ASC

Can you please give me the counters?


Thanks