Maximum number of configured user connections

[Anu]

Hi,

Environment:

I have a Sqlserver 6.5 production server used for web based applications
Compaq 5500 4 GIG RAM, 4 processor

Sql Memory config on that server is 1048576 (which is 2048 MB)
and the run value is 640000 (which is 1250 MB).
runvalue for user connections was 500

We have only 90 user connections may increase upto 100 depends on the connections. We don't have any overload on that server.

Error: I was seeing
"unable to connect maximum no. of 500 configured user connections are already connected" in the error log.

Action Taken:

I increased the user connections to 600
and rebooted the server. Immediately the same error I can see in the error log. But we have only 20 user connections at that time. I can able to connect.

Please advise me to get rid of this error.

Thanks,
Anu.

[Dilip Vyas]

Hi, Anu

I have gone thru yr problem, and i would like to check the numbers of
uses which was set in licence per server in control panel.

Regards
Dilip Vyas
SQL Server DBA
Reliance Petroleum Limited
Jamnagar - Gujarat - India

------------
Anu at 7/27/01 11:42:37 AM

Hi,

Environment:

I have a Sqlserver 6.5 production server used for web based applications
Compaq 5500 4 GIG RAM, 4 processor

Sql Memory config on that server is 1048576 (which is 2048 MB)
and the run value is 640000 (which is 1250 MB).
runvalue for user connections was 500

We have only 90 user connections may increase upto 100 depends on the connections. We don't have any overload on that server.

Error: I was seeing
"unable to connect maximum no. of 500 configured user connections are already connected" in the error log.

Action Taken:

I increased the user connections to 600
and rebooted the server. Immediately the same error I can see in the error log. But we have only 20 user connections at that time. I can able to connect.

Please advise me to get rid of this error.

Thanks,
Anu.

[Anu]

Thanks Dilip

Anu


------------
Dilip Vyas at 7/31/01 6:17:30 AM

Hi, Anu

I have gone thru yr problem, and i would like to check the numbers of
uses which was set in licence per server in control panel.

Regards
Dilip Vyas
SQL Server DBA
Reliance Petroleum Limited
Jamnagar - Gujarat - India

------------
Anu at 7/27/01 11:42:37 AM

Hi,

Environment:

I have a Sqlserver 6.5 production server used for web based applications
Compaq 5500 4 GIG RAM, 4 processor

Sql Memory config on that server is 1048576 (which is 2048 MB)
and the run value is 640000 (which is 1250 MB).
runvalue for user connections was 500

We have only 90 user connections may increase upto 100 depends on the connections. We don't have any overload on that server.

Error: I was seeing
"unable to connect maximum no. of 500 configured user connections are already connected" in the error log.

Action Taken:

I increased the user connections to 600
and rebooted the server. Immediately the same error I can see in the error log. But we have only 20 user connections at that time. I can able to connect.

Please advise me to get rid of this error.

Thanks,
Anu.

[Patrick]

The msg you got comes from SqlServer, my feeling is that this trouble is not tied to the license number.
Have you done a select count(*) from master..sysprocesses when the Pb. appears. then you will know exactly how many connections are supported by your server.
The number of users and the number of connections could be (is) different. By user we think human people but SqlServer thinks connection. For instance one human user using a VB application could freeze three or more connections.
Because you are in a web context some users could stay connected even when they are not till working. Then (if necessary) store their context in table, and if they are there since a long time 'last_batch' column, kill their connections.
Cheers
Patrick


------------
Anu at 7/27/01 11:42:37 AM

Hi,

Environment:

I have a Sqlserver 6.5 production server used for web based applications
Compaq 5500 4 GIG RAM, 4 processor

Sql Memory config on that server is 1048576 (which is 2048 MB)
and the run value is 640000 (which is 1250 MB).
runvalue for user connections was 500

We have only 90 user connections may increase upto 100 depends on the connections. We don't have any overload on that server.

Error: I was seeing
"unable to connect maximum no. of 500 configured user connections are already connected" in the error log.

Action Taken:

I increased the user connections to 600
and rebooted the server. Immediately the same error I can see in the error log. But we have only 20 user connections at that time. I can able to connect.

Please advise me to get rid of this error.

Thanks,
Anu.