Out of Space.

QuezadaQuezada Posts: 5 New member
edited April 6, 2020 5:50PM in Data Masker for SQL Server
Hi, i just want to ask if there is any recomendation about HD space, i'm working with huge tables and always get out of space, by the way i'm restricted in space of the Hard drive.

Any Recomendation/Ssolution?

Best Answer

  • PlantBasedSQLPlantBasedSQL Posts: 187 Gold 4
    Hi @Quezada thank you for your post.
    May I please get a bit more information about the setup you're working with?
    Do you have Data Masker installed on your local machine, an application server or the SQL Server that hosts the database being masked?
    Which machine is running out of HD space?
    Are you running Masking rules, or Insertion rules and generating new data?
    Is the Database in Simple Recovery mode?
    Have you tried altering the batch commit size for the substitution rules?
    Happy to try and help if possible! Thank you very much!

Answers

  • QuezadaQuezada Posts: 5 New member
    edited April 7, 2020 4:13PM
    dOCTOClone thank you for your Answer
    Data Masker and the server because is for Test purposes right now
    I'm Running Masking Rules
    the DB is in Simple Recovery Mode
    i'm not sure, i split the rule of 20 Millions row to a lot of rules of 500K rows, is that correct? or i missunderstando your question?

    BTW sorry for my English skills, is not my natural Language.
  • QuezadaQuezada Posts: 5 New member
    dOCTOClone thank you for your Answer
    Data Masker and the server because is for Test purposes right now
    Same Machine
    I'm Running Masking Rules
    the DB is in Simple Recovery Mode
    I didn't try altering the batch, can you give me directions for this please?
    Hope you can help me more, thank you and meanwhile i'm going to try to alter the batch
  • QuezadaQuezada Posts: 5 New member
    dOCTOClone thank you for your Answer
    Data Masker and the server because is for Test purposes right now
    Same Machine
    I'm Running Masking Rules
    the DB is in Simple Recovery Mode
    I didn't try altering the batch, can you give me directions for this please?
    Hope you can help me more, thank you and meanwhile i'm going to try to alter the batch
  • Hi @Quezada thank you for your reply (and apologies for the delay in my reply).
    Have you had any success with this process now? Has altering the batch size helped at all?
    If you're happy to, you can send me your logs (as output by Data Masker) - chris.unwin@red-gate.com and I'll be happy to take a look for you!
    Thank you very much - kindest regards!
Sign In or Register to comment.