What are the challenges you face when working across database platforms? Take the survey
Options

Slow Data Generation

I am experiencing slow data generation. I have a simple table - 15 columns, 2 FK Constraints, no triggers or calculations. I want to generate 5 million rows. After 35 minutes, I have only 200k rows. 

I've modified the batch size, I've tried it on a local instance and an Azure DB instance, I've simplified the foreign keys to be manual, turned off verbose logging. All without success. The database is under no significant load, so it appears to be a bottleneck in SQL Data Generator.

Has anyone else experienced this? Any options to help speed this up?
Tagged:

Answers

  • Options
    Hi @BaronVonKumpf

    Thanks for reaching out to us regarding this. I'm sorry you are seeing this issue with SQL Data Generator.

    Please can you confirm what version of SQL Data Generator you are currently using? And on which version of SQL Server is the database in question?

    Also, does the generation process ever complete? 

    Finally, if you can re-enable verbose logging, reproduce the issue, and provide the resulting log file, that might help us to indicate what is causing the delay.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.