SQL Server - Insert too slow into table

Question

My table have 47 columns without data, No index, no triger, no constraints, no foreign keys. Just simple. But speed insert is ~50 row/s. Too slow! I have tried many times in different times

Please help me how to check and find really problem in my case. Thanks bros!

The problem is not sql server. How do you insert these rows? — Gerard H. Pille, Jan 12 '21 at 07:51
https://stackoverflow.com/questions/20969624/data-loading-is-slow-while-using-insert-update-step-in-pentaho you're not alone. Check the advice you find there. — Gerard H. Pille, Jan 12 '21 at 08:08
Transaction? Bulk insert/BCP? TVP? What have you tried? What storage do you have? — Charlieface, Jan 12 '21 at 08:59

score 0 · Answer 1 · answered Jan 13 '21 at 03:00

0

Thanks all for support. I was restart database and the problem has been resolved.

answered Jan 13 '21 at 03:00

VietnamDataEngineer

161
3

SQL Server - Insert too slow into table

1 Answers1