Hi,

We have an ASP.NET 2 application that does some quite intensive work
in order to present data to the users.  A particular function gathers
a lot of data from the database and as the objects are quite fine
grained it makes thousands of stored procedure calls.  When under no
load the performance is fine, but when a few users use this at once
then the performance declines.  With around 4 users executing this
intensive function at once, using performance monitor we see around
40% CPU usage but massive levels of context switching (~300 000/sec).
I understand that context switching increases with the number of
threads, but it doesn't seem to me that this web server is under
particular load (it's a fairly well spec'd server with dual-processor,
dual-core).  If the CPU was maxed out I would just assume that the
server couldn't cope with the load that we are putting it under, but
it's not so it appears we are hitting some other server limit.  Can
anyone give me any pointers about what could be causing such huge
context switching values?

Thanks,
Rob