I am using an application that does a lot of inserts. One stored
procedure is being repeatedly called to execute these inserts about
1000 times per second peak.
The application reuses only one connection and it looks like it cant
process more than about 500 calls per second. When additional
instances of this application are being run, then they will produce a
total throughput of up to an average of 1500 calls per second.
Does someone know where the bottleneck is? Should the applications use
a connection pool or is it maybe simply a matter of sql server 2000
Thanks for any hint.