Originally Posted by Fkewl
I'm pretty sure your MSDE is the bottleneck here. Since it can only have 2 (or 4 or, well, below 10) connections to the DB at the same time
You should see an improvement if your switch to a real database engine
cool, thats what I figured, it seems like the MSDE is the bottleneck, the machine is a quad processor with plenty of ram and hd space, so its not running out of room or anything, hopefully the DB2 migration wont be as hard as our test server is.