高利用率小区查询顽固超忙小区查询指令

cctv0168

-----顽固超忙小区查询指令
declare @begin_time smalldatetime,  
  @end_time smalldatetime
set @begin_time = '2014-02-19 00:00:00'  
set @end_time = '2014-02-23 23:00:00'  
  
select TCH.小区,COUNT(*) 出现次数  
from MT_STAT.dbo.GSM_小时_CELL_TCH TCH with (nolock)  
left join MT_CONF.dbo.ST_小区综合信息 info with (nolock) on info.OMC中网元名称 = TCH.小区  
where TCH.时间 between @begin_time and @end_time  
and TCH.[每线话务量] >= 0.8  
and  TCH.[载波数] >= 10   
group by TCH.小区  

------高利用率小区查询
declare @begin_time smalldatetime,@end_time smalldatetime

set @begin_time = '2014-02-21 00:00:00'
set @end_time = '2014-02-27 23:00:00'

select TCH.小区,COUNT(*) 出现次数
from MT_STAT.dbo.GSM_小时_CELL_无线利用率 TCH with (nolock)
where TCH.时间 between @begin_time and @end_time
and TCH.无线利用率 >= 150
group by TCH.小区