June 27, 2009 at 11:51 am
I have a small company which does business on the web -- our app is hosted on a VPS server with a SQL Server back end on a shared DB server.
Most of the time, our traffic is not very high. However, occasionally we have an "event" in our application (it's a long story), during which several hundred users must log on and perform a task.
When this happens, we see quite a few of the following errors:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings.....
I have worked to fine-tune the queries taking place in the pages that our users are accessing, and have also taken steps to minimize the number of connections being used by the app during this time. However, we're still not able to get through our load-testing without encountering these errors.
I was hoping someone might have some suggestions -- I've been using SQL Server for a couple years now but admittedly not as an "advanced" user, nor am I an expert administrator.
Thanks!
June 27, 2009 at 10:11 pm
Hello,
Can you post the full Error Message, including Error Number and State? (With a bit of luck it will be in the Event Log, if nowhere else).
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply