Hello
I have one destination table.In that table I am inserting records.During Insertion I am using Open Transaction and Commit.
Approx 1700000 Transaction I need to insert so which things I need to take care during insertion in production.
I need to do it for couple of tenant
Anything related to Transaction Log
Anything related to Database Recover Model
Anything related to Stats
Anthing TempDB
Autogrow
Approx Memory


