I have a process that uses BULK INSERT
to push two CSV files into SQL tables, so I can join their data with another table I have. The data coming from the CSV files generates tables about 100,000 rows each. When the process is done these tables are truncated. This whole process is running on a DB that was created just for that (no other activity).
After running this for a while in one minute cycles, the whole server becomes VERY slow. It looks like this activity is taking some resource and not releasing it. Even though the bulk insert and the join together take just about 5 seconds each time.