We are running a Windows Server 2003 r2 x64 with SQL Server 2005 (Production Server) on it. Our software provider usually access to our server to fix/update/add features to our systems (Service/Contractor Software). They were backing up the entire database (47 GB) while we were working. We experienced a very slow performance, which is not normal. They compressed the database into 6 parts (rar files) of a total of 4GB all 6 rar files on an external hard drive attached to the server. Then they were uploading them to they servers/computer for testing purposes.

They said that it might slow down the server while they were compressing the database. After the compression process finish, uploading compressed files should have little to no effect.

It is currently utilizing 0.5% of your LAN and 3% of your WAN upload bandwidth, and is uploading to us at 150KB/s (1.2Mbps). I'm doubtful this has any effect, but it is currently underway and should be done in about 3 hours.

I think his statement is not correct because in this scenario they are other factors such as memory ram, page files, I/O and transactions/connection to SQL server. SQL server is using 14 GB of 16 GB of the server's memory ram. The C drive has 27 GB free space. There are like 379 connection to SQL server.

So, my question is, is he right? I'm not 100% sure. The other thing is that it was done on a production server and in peak times.

Thank you,

  • What exactly is the problem you're trying to solve? – joeqwerty Sep 25 '14 at 16:52
  • What ancient software... – Falcon Momot Sep 29 '14 at 20:28

Yes, both will have a potential impact on your performance. How much is impossible to tell without monitoring your server. Compression is CPU and RAM intensive, they are right about that. And you are right; network throughput is not the only factor to take into consideration when copying files. How your server is affected depends on how they are copying the files, though.

You should schedule maintenance times with them so that this type of activity does not occur during your peak usage times. Not only will it have less of an effect on your users but the maintenance will also take less time since it is in contention with your user load.

Not the answer you're looking for? Browse other questions tagged or ask your own question.