we are facing this problem continously that whenever any store is uploading its data to HQ, HQ slows down tremendously. During that time if we open any report it doesn't show complete data. This frustrate most of the HQ user. Is this something to do with SQL Server setting or HQ setting.
We are using Quad core machine for HQ database server.