The process that is running at the time the autogrowth event is triggered has to wait. If that process times out, the autogrowth event is rolled back and the next...

Having thought some more about your suggestion while I am sure they are good suggestions I don't think they can account for our problems other than the reusing the database...

By page splits - I mean fragmentation. However, you are using a HEAP which cannot be defragmented. If you do not update on a regular basis, I would recommend adding...

I will look into changing the autogrow configuration.

I am not familiar with instant initialization so I will have to look that up.

The table has two indexes (both Non-Unique, Non-Clustered):

1....