Slowness in Image Creation in v2.4

• 
  I'd be very interested in learning if this is reproducible too, either between different people, or just different times. Do you notice this taking reliably longer now, or is it intermittent? How large is the backup file now, roughly? (Just wondering if it has crossed some internal threshold somewhere.)

  owen.hall December 18, 2017 09:59

  - 0 +
• 
  I can run more tests, but without me starting a stop watch and watching is there any log that could be enabled that would capture the image creation?

  GarryB December 18, 2017 12:16

  - 0 +
• 
  Nowhere too accessible, now I look. I'll put a task up to improve our logging there, but in the meantime you can plow through SQL Clone's config database to find the information. First you need to find the operation that created your image.
  

  SELECT TOP 1000 *
    FROM SQLClone_Config.dbo.Operations
   WHERE Discriminator = N'ImageOperationEf'
   ORDER BY Timestamp DESC;
  

  
  Use that to find the Id of your image creation operation based on its timestamp (when the operation was created), then
  

  SELECT *
    FROM SQLClone_Config.dbo.OperationMessages
   WHERE OperationId = <YourId>;
  

  
  That should provide you with the start and end times of the operation.

  owen.hall December 18, 2017 17:14

  - 0 +
• 
  I have it running now and will compare the times to these last two runs and then a time before now that I can mine this data.

  GarryB December 18, 2017 17:53

  - 0 +
• 
  Hi Garryb,
  
  Testing locally I wasn't able to produce any slowness from 2.4 to previous versions 2.3 and 1.2.
  
  Is there anything special about your database? Mine is just the northwind DB pumped full of data to make it's size meaningful.

  Dan B December 19, 2017 15:13

  - 0 +

Add comment

Please sign in to leave a comment.