SQL Anywhere database - SQL Anywhere (DBSRV50) limit users

Author

SQL Anywhere (DBSRV50) limit users

John K

2005-06-13, 3:23 am

SQL Anywhere server 5.504

Using dbsrv50 (unsupported, i know!) Is it possible to limit the number of
concurrent users connecting?

eg dbsrv50 -c20M - maxconcurrentconnect
ions=5

--

Regards,

John

Joshua Savill

2005-06-13, 9:23 am

John,

When you say concurrent connections, are you referring to multiple
connections from a single machine? Or are you referring to concurrent
requests in the database?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"John K" <John.kingan@tiscali.co.uk> wrote in message
news:42ad463e$1@foru
ms-1-dub...
> SQL Anywhere server 5.504
>
> Using dbsrv50 (unsupported, i know!) Is it possible to limit the number of
> concurrent users connecting?
>
> eg dbsrv50 -c20M - maxconcurrentconnect
ions=5
>
> --
>
>
> Regards,
>
> John
>
>

John K

2005-06-13, 9:23 am

In the database. IE one connection from each machine, maximum of five
machines!

Thanks

John.

"Joshua Savill" <jsavill@ianywhere.com> wrote in message
news:42ad9235@forums
-1-dub...
> John,
>
> When you say concurrent connections, are you referring to multiple
> connections from a single machine? Or are you referring to concurrent
> requests in the database?
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
>
> "John K" <John.kingan@tiscali.co.uk> wrote in message
> news:42ad463e$1@foru
ms-1-dub...
>
>

Joshua Savill

2005-06-13, 9:23 am

John,

dbsrv50 -gn 5 will set the database server to use 5 working threads. The
default number is 20 working threads in the database server. This will only
allow 5 concurrent requests in the database at a given time.

Concurrent requests are not based on the number of connections to the
database, but rather number of concurrent transactions the database can
process. Reducing the number of concurrent transactions could decrease
performance, but at the same time decrease the potential for blocking.

If you're looking to limit the number of connections to the database, then I
recommend you license the database for 5 users. This will cause a license
exceed error message if more than 5 users attempt to connection.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"John K" <John.kingan@tiscali.co.uk> wrote in message
news:42ad975a$1@foru
ms-2-dub...
> In the database. IE one connection from each machine, maximum of five
> machines!
>
> Thanks
>
> John.
>
>
>
> "Joshua Savill" <jsavill@ianywhere.com> wrote in message
> news:42ad9235@forums
-1-dub...
>
>

John K

2005-06-14, 7:23 am

"If you're looking to limit the number of connections to the database, then
I
recommend you license the database for 5 users. This will cause a license
exceed error message if more than 5 users attempt to connection."

Can you please expand on this. When i install the clients i simply choose
per-seat licence. Is this what you are referring to?

Thanks In advance,

John.

"Joshua Savill" <jsavill@ianywhere.com> wrote in message
news:42ad9981$1@foru
ms-1-dub...
> John,
>
> dbsrv50 -gn 5 will set the database server to use 5 working threads. The
> default number is 20 working threads in the database server. This will
> only allow 5 concurrent requests in the database at a given time.
>
> Concurrent requests are not based on the number of connections to the
> database, but rather number of concurrent transactions the database can
> process. Reducing the number of concurrent transactions could decrease
> performance, but at the same time decrease the potential for blocking.
>
> If you're looking to limit the number of connections to the database, then
> I recommend you license the database for 5 users. This will cause a
> license exceed error message if more than 5 users attempt to connection.
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "John K" <John.kingan@tiscali.co.uk> wrote in message
> news:42ad975a$1@foru
ms-2-dub...
>
>

Chris Keating $iAnywhere Solutions$

2005-06-14, 9:23 am

You cannot install more that you are licensed for in a per seat licensing
model. If you have 5 per seat licenses, you can only install 5 copies of
the client software. Are you trying to limit the number of connected users
to less then the number of installed seats?

BTW I think that you may be wanting a concurrent license.

"John K" <John.kingan@tiscali.co.uk> wrote in message
news:42aebbc7$1@foru
ms-1-dub...
> "If you're looking to limit the number of connections to the database,
> then I
> recommend you license the database for 5 users. This will cause a license
> exceed error message if more than 5 users attempt to connection."
>
>
> Can you please expand on this. When i install the clients i simply choose
> per-seat licence. Is this what you are referring to?
>
> Thanks In advance,
>
> John.
>
>
> "Joshua Savill" <jsavill@ianywhere.com> wrote in message
> news:42ad9981$1@foru
ms-1-dub...
>
>

John K

2005-06-14, 9:23 am

My customers can download the client s/w themselves. I want to setup the db
server so that it simply rejects any new connections when the maximum are
connected.

Thanks again,

John.

"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:42aed412@forums
-2-dub...
> You cannot install more that you are licensed for in a per seat licensing
> model. If you have 5 per seat licenses, you can only install 5 copies of
> the client software. Are you trying to limit the number of connected users
> to less then the number of installed seats?
>
> BTW I think that you may be wanting a concurrent license.
>
>
> "John K" <John.kingan@tiscali.co.uk> wrote in message
> news:42aebbc7$1@foru
ms-1-dub...
>
>

Chris Keating $iAnywhere Solutions$

2005-06-14, 11:23 am

SA5 has no mechanism, as far as I remember, to restrict the number of
connections other than if the engine is licensed as concurrent connections.
Per seat licensing is not restricted in SA5 except by paper.

"John K" <John.kingan@tiscali.co.uk> wrote in message
news:42aee76c$1@foru
ms-1-dub...
> My customers can download the client s/w themselves. I want to setup the
> db server so that it simply rejects any new connections when the maximum
> are connected.
>
> Thanks again,
>
> John.
>
>
> "Chris Keating (iAnywhere Solutions)"
> < Spam_NoThanks_keatin
g@iAnywhere.com> wrote in message
> news:42aed412@forums
-2-dub...
>
>

Sponsored Links