Data Generation hangs

The simplest way to populate your database with test data.

Data Generation hangs

Postby facklec » Thu Aug 15, 2013 6:19 pm

I'm trying to create a large database (50 gigs) for testing purposes. I can't seem to get one particular table to load. It will hang at 0%, 10% and now 100%. I think it depends on how many records I'm trying to generate. At 1.5 million it hangs at 0%. I let it run for 12 hours and it didn't seem to do anything. At 1000 rows it's hanging at 100%. At 100 it succeeds. There is a unique non-clustered index that I thought would help to drop but it's being used by other tables for foreign key constraints so I can not drop it. I've successfully generated a 5 gig database but I'm stuck trying to generate this larger one. BTW, "Cancelling" never works.
Posts: 5
Joined: Wed Jun 26, 2013 6:36 pm
Location: Olympia, WA

Postby Brian Donahue » Mon Aug 19, 2013 10:35 am


I think we may have to get back you by email on this one. Obviously data generation times depend on the types of generators and the database schema (maybe triggers are running during the update). Having the cancel button not responding is a bit worrying though.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests