MSSQL overload – Simultaneous Connections

One of the main reasons people may experience performance issues is a database experiencing a large amount of simultaneous connections to a single database. For our shared services the average number of simultaneous connections should never exceed 25 requests for each database. There are a few steps you can take to help yourself control the amount of connections you have coming into your server. As the developer you should look at these 3 steps to help you stay under the request limit:

  1. Inside your websites, do not allow users to input data during transactions. Have all data imported before the transaction begins.
  2. Make sure all 3rd party plugins or applications are always kept up to date.
  3. Review your database and look to optimize it using the recommendations provided by Microsoft here.

If your database exceeds the number of 25 hosted on our shared servers your account will receive a Terms of Service Violation for MSSQL server overload ticket. If you are hit with one of these tickets there are a few things you can do to resolve it and bring your account back to normal standings.

Important tips on how to resolve too many connections to your server:

  • The first step you should take to resolve this is to ensure that your database is working normally. Launch your application and make sure it opens and closes all connections correctly. Immediately following your usage, your .NET connection pool will handle everything.
  • If you have a single table with a lot of records, it might be better to split your table into multiple tables allowing your site to move smoother.
  • Review the amount of time each transaction on your site takes to complete. Make sure that your applications are not reading the same database information more than once. If your application does need to read information more then once, cache it by storing it in as a variable or as an array. Either of those variations can be read to save usage on your database.
  • Limit the number of marketing campaigns you have directly targeting your database driven website. If you are looking to use marketing for your site, look for ways to have your campaigns land on html splash pages. That way you can target your traffic to specific pages while not pushing the boundaries of your database driven site.
  • Review your transfer logs for IPs that are connecting too often to your sites. Review the IP addresses and if they are trying to harm your account you have the ability to block them from your account. For more information on blocking IP addresses from your account review our article here.

After running through the above steps and you are still experiencing a large amount of connections you will need to look at updating your account to one of our Cloud servers. For more information on our Cloud services please review our services at Cloud Solutions.

Was this article helpful?

Yes (14)
No (0)

We're sorry you didn't find this article very helpful. Please help us improve it by leaving your feedback below.