Running ETL Process against Compressed Database

Kadams

Hi,

I have been testing our ETL process against the compressed database and the uncompressed database to verify performance and so far ETL against the compressed database is taking up to 4x longer to run. Is this to be expected?

I was under the impression that the compressed database would perform as well or better than the uncompressed database.

Eddie D

Hi, Thank you for your post into the forum and sorry that you have encountered a problem.

A support call has been created for you, the call reference is F0067031.

Can you please send an e-mail to support@red-gate.com with the above call reference number in the subject field? In your e-mail can you please confirm the following information and attach the requested HyperBac files?

Details of the ETL Process you are performing? OS version of your server? Number of CPU's and Cores, and Memory on the machine? SQL Server version? Copies of the HyperBac Status.dat, openstatus.dat and hyperbac.conf files, default location - C:\Program Files (x86)\Red Gate\HyperBac\bin? Copy of the HyperBac Service.log and any other error log files, default location - C:\Program Files (x86)\Red Gate\HyperBac\logs? Event viewer capture from the time of the error? Performance Monitor snapshot too if possible, to get an idea of memory usage, CPU etc?

Once we receive the requested information, we will be able to offer advice and hopefully identify a cause of the performance degradation.

Many Thanks
Eddie