patternsqlMinor
SQLConnections 100 + instance problem in database
Viewed 0 times
problemdatabaseinstance100sqlconnections
Problem
I am using a SQL Server Database in my CRM Project. It is not Microsoft CRM, it is a simple BPO website that 100+ users used to work on. Sometimes there are more than 100 users logged in, and works properly. However it gives me an error
Our Windows admin said this:
Our Windows shared Servers allow up to 150 connections MAX at a time. Your database alone was using 100 SQL connections. Even the busiest sites and SQL servers in our farm do not come even close to this amount of connections being made to the SQL Server.
Below are the logs of your connections:
```
91 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
92 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
93 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
94 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
95 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
96 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
97 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
98 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
99 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
102 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
104 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
105 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
106 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
108 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
109 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
112 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
113 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
114 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
115 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
116 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
117 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
118 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
119 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
120 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
121 0 sleeping mydb PSS003 0 mydb AW
Server page not responding after 1-2 minutes and everything stops working. After some time it again continues working. Our Windows admin said this:
Our Windows shared Servers allow up to 150 connections MAX at a time. Your database alone was using 100 SQL connections. Even the busiest sites and SQL servers in our farm do not come even close to this amount of connections being made to the SQL Server.
Below are the logs of your connections:
```
91 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
92 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
93 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
94 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
95 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
96 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
97 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
98 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
99 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
102 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
104 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
105 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
106 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
108 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
109 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
112 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
113 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
114 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
115 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
116 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
117 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
118 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
119 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
120 0 sleeping mydb PSS003 0 mydb AWAITING COMMAND 0
121 0 sleeping mydb PSS003 0 mydb AW
Solution
What connection log is this? SQL can handle thousands of connections at a time without issue. What makes you think that it's the database which is causing the problem? Can you connect to the database and issue commands with SQL Management Studio? If so then it isn't the database and it is probably a problem with the app.
Context
StackExchange Database Administrators Q#15894, answer score: 5
Revisions (0)
No revisions yet.