Article View: comp.sys.next.misc
Article #2894Re: Sybase - Concept of a User
From: andrew
Date: Thu, 08 Oct 1992 23:34
Date: Thu, 08 Oct 1992 23:34
36 lines
2190 bytes
2190 bytes
In article <1992Oct7.173705.2171@deepthought.uucp> Neil Greene <deepthought!neil@ms.uky.edu> writes:
>I was told a long time ago that Sybase may internally limit the number of
>simultaneous users based on the license agreement. (i.e. - a 5 user
>license will only allow 5 users to access the database at the same time.)
>
>I was also told that Sybase uses 3 of the 5 users from the Limited Server
>Edition for internal processes (database writer, etc.). Leaving only 2
>users available. Can someone clarify this, is this true??
Not true. In fact, it appears as if you can have _six_ simultaneous
users running on the limited server:
1> sp_who
2> go
spid status loginame hostname blk dbname cmd
------ ---------- ------------ ---------- --- ---------- ----------------
1 sleeping andrew imladris 0 bbs AWAITING COMMAND
2 sleeping sa 0 master NETWORK HANDLER
3 sleeping sa 0 master MIRROR HANDLER
4 sleeping sa 0 master CHECKPOINT SLEEP
5 sleeping andrew imladris 0 bbs AWAITING COMMAND
6 sleeping andrew imladris 0 bbs AWAITING COMMAND
7 sleeping andrew imladris 0 bbs AWAITING COMMAND
8 sleeping andrew imladris 0 bbs AWAITING COMMAND
9 runnable andrew imladris 0 bbs SELECT
(9 rows affected, return status = 0)
andrew
--
andrew@cubetech.com | "We shall not cease from exploration
Andrew Loewenstern | And the end of our exploring
Cube Technologies, Inc. | Will be to arrive where we started
| And know the place for the first time." -T.S. Eliot
Technical Details
Message-ID:
<1992Oct8.233439.661@cubetech.com>Path:
arc1-ca.pugleaf.net!sparky!uunet!tcsi.com!iat.holonet.net!uupsi!psinntp!cubetech.com!imladris!andrewReferences:
<1992Oct7.173705.2171@deepthought.uucp>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.misc Path: arc1-ca.pugleaf.net!sparky!uunet!tcsi.com!iat.holonet.net!uupsi!psinntp!cubetech.com!imladris!andrew From: andrew@cubetech.com Subject: Re: Sybase - Concept of a User Message-ID: <1992Oct8.233439.661@cubetech.com> Organization: Cube Technologies, Inc. References: <1992Oct7.173705.2171@deepthought.uucp> Date: Thu, 8 Oct 1992 23:34:39 GMT Lines: 36