Images are slow to build in SQL Clone v3.1.1.15815

newbieDBA

Hello All, 

The creating of images has started to get a lot slower today (for 30 mins to over an hour) for a single 80 GB database.
It's a brand new image being generated from a full backup and differential backup, so there is no contention with resources on the server or from the database itself.

Any thoughts on what could cause this ?
Are there any recommended indexes or stats that should be updated on the SQLClone database before image creation happens ?

ChrisHurley

Hi,

Do you know what version you were upgrading from, and does your database use a large number of files (particularly due to FILESTREAM filegroups)? There was a change in 3.1.0 to move a permissions-changing operation that was being done during every clone creation to occur once during image creation, which could cause imaging to be slower but cloning to be faster.

The SQL Clone config database itself shouldn't affect the performance of the image or cloning process as it's only used for storing metadata about the system.

Thanks,

Chris

newbieDBA

The database itself is just a single MDF / LDF with no extra file groups created above the default Primary. 

I'll continue to monitor and see what else we get performance wise in the coming days.

Thanks for the reply and and info anyway Chris.

LBolo

Hello - I was wondering if you had any updates on your issue with this.  We are experiencing the same thing, but we are on 3.1.8.17860.  Things started out taking 5-10 minutes and after a few months they are up to 1 1/2 hours.  We can't seem to pinpoint what would be causing this.  
We battled this for a long time, and then we had a Power Outage (and a generator fail) that took down our data center for short time, and after we brought the SAN back up, the jobs were back to 5-10 minutes.  That was in May, and now in October everything is taking hours vs minutes. 
Had you had any luck figuring out your issue?
Thanks.