March 1, 2005 at 3:21 am
Hi,
I am wanting to know more about SQL Server 2000 CALS. We have an application that using SQL Server 2000 and we are trying to test what happens when SQL Server runs out of CALS. We set up a SQL Server with 2 CALS. 3 people then connected to DB through our App we also connected through some Query Analyzer sessions too. SQL Server allowed all the connections even though there were more than 2 devices connected to the DB.
There was nothing in the SQL Server Logs or in the Eventvwr.
I checked some other message boards and SQL is supposed to refuse any more connections when the number of CALS has been reached.
Any ideas???
Thanks,
Stuart
March 1, 2005 at 3:45 am
The bog standard install of SQL comes with 5 CALS, one of which is supposed to be the server itself.
If your app is web based then you should be using per processor mode.
March 1, 2005 at 4:31 am
Hi,
In the SQL Licensing in Control Panel we have set the number of CALS to be 1 and still we can connect loads of things to it. Does it include sleeping connections as a connection? If I do an SP_WHO it show a lot of the connections are sleeping. I also tried connecting from more than 5 different machines and it still allows the connections, although some of the other connections may be sleeping?
Thanks,
Stuart
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply