Masking very slow in SQL clone, compared to app running

glennsharrock

I can run the masking set in the application it takes around 20 mins, but when I run the masking set when creating an image it took over 1 hour? No other activity on the server, both the SQL Clone server and the DB Server used.
(SQL Clone v5.3.27.4396)

TheMaskedData

Hey @glennsharrock - just a couple of questions as this is very curious...

When you run Data Masker against the instance, is Masker installed on that same server as the instance it's pointed against? Are you using the same install of DM when invoking independently and against the image?

Are you running any other preparations against the Image whilst creating it? Any custom SQL Scripts or anything?

If you've got logs handy for both runs (and want to just remove the top bits with server names) then I (and probably the RG folks too) would be jolly interested to see them

DM Logs outside Clone > The Misc. Setup Tab - Data Masker - Product Documentation (red-gate.com) "Directory for Log Files"

DM Logs inside Clone > SQL Clone Dashboard > Activity > Find the Image Creation Activity > Logs

KR

glennsharrock

I think issue is ok. getting different results when running