Red Gate forums :: View topic - Running ETL Process against Compressed Database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Storage Compress 6
SQL Storage Compress 6 forum

Running ETL Process against Compressed Database

Search in SQL Storage Compress 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Kadams



Joined: 21 Nov 2012
Posts: 1

PostPosted: Wed Nov 21, 2012 11:03 pm    Post subject: Running ETL Process against Compressed Database Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Fri Nov 23, 2012 12:04 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group