IIS SQL Connectivity

[rgelfand]

I have a web c# application running on iis 7.5 which connects to sql server 2014 db. The db connections are not persistent needing separate connection for each db request. When a number of db requests are significantly increased, it takes much longer to process them. For example, between 12 and 1pm, on average there are 2600 db requests. Each request, takes 10 minutes to process. However, between 1 and 2 pm, there are 5000 db requests. Each request, takes 40 minutes to process.

What can be done to improve the speed at which the db requests are processed?

Thanks in advance

Continue reading...