Running ETL Process against Compressed Database

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, fionag

Running ETL Process against Compressed Database

Postby Kadams » Wed Nov 21, 2012 11:03 pm

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.
Kadams
 
Posts: 1
Joined: Wed Nov 21, 2012 10:55 pm

Postby eddie davis » Fri Nov 23, 2012 12:04 pm

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Storage Compress 6

Who is online

Users browsing this forum: No registered users and 0 guests