Problem: Sanchay Post :every transection takes too much of time to proceed. The counter operators are fed up due to this. Shrink the databases, cleared log files of sanchay databases. Also used create recreate index utility, still, such problem is as it is.

BPRO : make it fast

Solution: You may try this
Use BPLOG
GO
truncate table dcl.user_tran_master_log_table
truncate table dcl.user_tran_child_log_table
GO
Use POST
truncate table dcl.print_sticker
GO
Use BPRO
truncate table dcl.form_preserve_table
GO
Use SODBNAME
truncate table dcl.chq_closure_detls
GO[For SO databases in HO]
Use Master
GO
DBCC Shrinkdatabase ('BPLOG',10)
DBCC Shrinkdatabase ('POST',10)
DBCC Shrinkdatabase ('BPRO',10)
DBCC Shrinkdatabase ('SODBNAME',10)[For SO databases in HO]
GO
Dump transaction BPRO with no_log
Dump transaction BPLOG with no_log
Dump transaction POST with no_log
Dump transaction SIGN with no_log
Dump transaction SOSB with no_log
Dump transaction SODBNAME with no_log[For SO databases in HO]

Please run query one by one .....
After this Sanchay post BPRO database size will srink to smaller .

Transaction will become more fast .

Thanks MR.PRASIT KUMAR MUKHERJEE CIRCLE SYSTEM ADMINISTRATOR,WB CIRCLE  (POSTED BY ME ABHIJIT CHANDA,SA KRISHNANAGAR HO,WB CIRCLE)

courtsey:http://sapostaliporeho.blogspot.in