April 7, 2004 at 8:56 am
I am a developer, so excuse my lack of networking knowledge and misuse of terminology.
My company is developing VB 6 apps on top of SQL Server 7 running on Win2k. Occasionally, users will receive timeouts across the board. Looking at Event Viewer, we find a SQL error message stating that maximum license has been reached. We have a 75 license server, and are fairly confident that the problem is not that there are 75 users hitting the database. Our suspicion is an application connection is the issue.
We are confident that all VB apps are explicitly closing connections, but cannot find who are what is using up all of the licenses. We can tell when the error is occurring via the Event Viewer, but can't id the problem.
Not sure if this is related, but our network has been running very slowly due to some DNS issues.
Just curious if anyone has experienced anything similar. Or if there are any system tables that would provide statistics that would allow us to narrow down on possible problem sources, based on the time in which we know the problem occurred.
Thanks
April 7, 2004 at 9:07 am
You could run a select against the sysprocesses table to find out all connections to your server and then check for those that are active and how long they have been there, as well as the hostname that the connection has been made from.
April 7, 2004 at 11:56 am
75 license is only for 75 concurrent connections. Regardless if you have 5 or 10 people using it, if you are not closing your connection properly, you will have lots of open connections. To check to see if you have connection problem, open your application, pretend that you are using your application as intended to do, in the mean time, go back and check how many connection is open in your own host name. I am sure you could evenn do sp_who and then count up how many connection you have.
mom
April 8, 2004 at 2:38 pm
Check the license manager to see if the licenses have been explicitly assigned. If you're using Windows Authentication with CALS, it is quite possible that the license has been assigned to the Domain\User. You would need to delete those assignments in the license manager to free some up.
"All your database are belong to me"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply