Slow Data Generation
BaronVonKumpf
Posts: 1 New member
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?
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
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.
Dan Jary | Redgate Software
Have you visited our Help Center?