100% i agree with you, but the thing is also not data loads.

To curb this, i requested a data count, after every table re-load, and the difference between a slow...

Thanks for the quick reply guys...

@@Jason..

- Parallelism YES! I have noticed up to 90 process SPID's, the Machine is a 16 Core box, but when we tried to play around...

Hi thanks for the reply...

100%, the initialization was done via a sql script on SSMS. I also specified on publication to initialize from backup (if this is not enable the...

WOW, i can't believe i have over looked that! I have deleted all replication jobs. Now its just a matter of monitoring!

Thanks bud!!!

Hi

The Db is currently in the full recovery model and transaction log backukps are run every 30min. The problem is that the log is not being cleared after the log...