all groups > sql server connect > november 2003 >
You're in the

sql server connect

group:

Max number of instances of a login



Max number of instances of a login Dave
11/5/2003 6:09:07 AM
sql server connect: Hello, can someone please tell me what is the max number
of instances a single login can have open and running a
query at the same time ? Basically i want to know if a
user logs into a website and runs a query using a web
login called 'weblogin' and at the same time more users
try to execute the same query from the same web site using
the same web login, will both queries run at the same time
using the same ID, or does the second request have to wait
until the first is complete to start? Trying to determine
if i am going to have to create many separate logins to
allow many people to run the same query as the same time.

Re: Max number of instances of a login Andrew
11/5/2003 3:44:58 PM
Hi,

As long as your queries do not block each other, by accessing the same data
and attempting to gain an exclusive lock on that data, your queries will all
be able to run at the same time using the same username. Exclusive locks are
generally related to updating information, so if your queries are purely
SELECT's, you'll be okay.

Regards, Andrew

[quoted text, click to view]

RE: Max number of instances of a login rboyd NO[at]SPAM onlinemicrosoft.com
11/5/2003 8:18:29 PM
There is no limit to the number of times a login can be used to connect to
SQL Server simultaneously. All the queries by the respective logins will be
run concurrently.

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button