Posted by kwdavids on 01/30/06 16:23
Not auto-grow (too small), nothing in the SQL Server logs. No de-frag.
I run Norton Anti-Virus, but disabling it had no effect.
What I did find through server tracing, is that for some reason (which
I haven't been able to discover yet), each time the secondary DataSet
is being opened, there is another connection to the database. So the
problem might be "every few thousand connections". I'm building a test
bed application to try to simulate what's going on in the larger
program.
[Back to original message]
|