Hey,
We do 99.9% inserts. We have a C++ app that communicates with the DBs via ODBC.
Using Sql 2000, it works well. We have another faster server to test with Sql 2005. For some reason, 2005 does not come close to handling the inserts as well as 2000. I've done the statistics and other 2005 config changes. Both boxes are quads with hyper threading. I know it's not the box b/c the 2005 box ran great with Sql 2000.
Is there any reason Sql 2005 would not communicate with our app as well as Sql 2000 would? I'm running out of things to consider. I've done the MAX DOP, etc, it has not mattered. It doesn't compare. We do very rapid inserting.
Thanks!
If you are using same client stack against different servers (2005 vs. 2000), engine guys might find an answer to your question.
No comments:
Post a Comment