商云前台销售结算慢

请核实后台是否有日结或处理数据导致前台卡顿，若没有进行相关操作，测试断网销售是否卡顿，若断网正常，尝试将服务器重启后测试，若重启后问题依旧，请修复索引和自增列后测试，修复时建议前台断网销售：
--修复自增列语句：
use hbposv8     ----分店改为hbposv8_branch
go
declare @tablename varchar(100)
declare  test_cur cursor for
select object_name(id) from syscolumns 
where status=128
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin   
   DBCC CHECKIDENT (@tablename, RESEED)   
   fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go
---修复索引
use hbposv8     ----分店改为hbposv8_branch
go
declare @tablename varchar(100)
declare  test_cur cursor for
select object_name(id) from sysobjects 
where type ='U'
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin   
   DBCC DBREINDEX(@tablename)
   fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go