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:
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.
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.