Conditional -- ?

What does "conditional" mean as a command? sp_who2 reports this for
some sessions, along with "insert" etc.

Thanks,
Jim Geissman(jim_geissman@.countrywide.com) writes:
> What does "conditional" mean as a command? sp_who2 reports this for
> some sessions, along with "insert" etc.

An IF or WHILE statement. Typically with a query in the condition, like
IF EXISTS(SELECT ...). If this query is long-running, or the longest
running in a stuck loop, CONDITIONAL is likely to turn up.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, Erland!

Erland Sommarskog wrote:
> (jim_geissman@.countrywide.com) writes:
> > What does "conditional" mean as a command? sp_who2 reports this for
> > some sessions, along with "insert" etc.
> An IF or WHILE statement. Typically with a query in the condition, like
> IF EXISTS(SELECT ...). If this query is long-running, or the longest
> running in a stuck loop, CONDITIONAL is likely to turn up.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Concurrent connections/sessions for SQL 2000

How many concurrent sessions can SQL 2000 take?
thanks
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:c2a701c489f7$b69bd590$a501280a@.phx.gbl...
> How many concurrent sessions can SQL 2000 take?
Theoretically maximum is 32,767 user connections. Actual number will vary
based on edition of SQL Server 2000 installed and hardware in use.
Steve

Concurrent connections/sessions for SQL 2000

How many concurrent sessions can SQL 2000 take?
thanks"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:c2a701c489f7$b69bd590$a501280a@.phx.gbl...
> How many concurrent sessions can SQL 2000 take?
Theoretically maximum is 32,767 user connections. Actual number will vary
based on edition of SQL Server 2000 installed and hardware in use.
Steve|||Steve,
how about for SQL 2000 Enterprise?
the reason I am asking is because I had an issue where we
were getting asp errors/access denied during heavy traffic
to our web servers/db servers.
Our web server and db server are on 2 sep. machines.
Pbviously, the web server connects to the db server.
The web server is on wind.2003.
anyways, that specific day, we got heavy traffic and some
of the connections were timing out. I looked at the SQL
processes in Enterprise Manager and saw that lots of
proccesses were sleeping, so i am not sure what to make of
this. I looked at perfmon and saw that the hardware was up
to spec with no issues...
any ideas? is this a app/coding issue?
thanks

>--Original Message--
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:c2a701c489f7$b69bd590$a501280a@.phx.gbl...
>Theoretically maximum is 32,767 user connections. Actual
number will vary
>based on edition of SQL Server 2000 installed and
hardware in use.
>Steve
>
>.
>