Hello,
I have a large database table running on SQL Server 8.0. It currently has nearly 98 million records on it's ways to 125 million. I am doing inserts as quickly as the server can handle it, but after a while the server simply refuses to process the insert statements. According to SQL Management Studio, the insert statements are being loaded and marked as runnable, but they are never added to the database. SQL Server doesn't stop working during this time; I am still able to issue queries as usual, but the inserts are not being processed from the script. The command timeout is 30 seconds, so once it starts failing it waits 30 seconds before trying another insert, but it will consistently fail for days at a time.
Does anybody know what causes this? Does SQL Server have some kind of restriction so that it block a certain connection after so many queries have been issued?
By the way, I'm doing 10,320,000 inserts from the same SQL connection from within VB.NET
Thanks,
poe