question

I have TCP/UDP listener Windows service which insert incoming records into a table (Rawtable). I have another windows service which split data and store records into three tables (Daytable, Weektable,Monthtable (ReportJantable ,ReportFebtable etc.) using Rawtable. Currently data get stored into Daytable, Weektable and ReportSeptable. Now ReportsMaytable have data which inserted in may-2017 months which is not rarely use but when I run below query:- select * into temp from ReportsMaytable where datetime between '1 May 2017' and '10 May 2017' then above services get paused. also when we try backup my database still services get paused