Maximum Transactions

Is there a maximum number of transactions that SQL 2000 Standard can
handle at any given time?
Is this configurable?Standard answer: It Depends
It depends upon Hardware (CPU, memory), network traffic, size of the
transactions, database traffic, query plan, what color shoes you wear, etc.
Obviously a 8 CPU/64Gb/3.4Mhz server can handle quite a few more
transactions per second than a 1 CPU/1GB 1.7mhz server.
Now go take a 'common sense' pill. ;-)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"John Bailo" <jabailo@.texeme.com> wrote in message
news:_NmdnSjCQP6-XlrZnZ2dnUVZ_oidnZ2d@.speakeasy.net...
>
> Is there a maximum number of transactions that SQL 2000 Standard can
> handle at any given time?
> Is this configurable?
>|||Arnie Rowland wrote:
> Standard answer: It Depends
> It depends upon Hardware (CPU, memory), network traffic, size of the
> transactions, database traffic, query plan, what color shoes you wear, etc.
> Obviously a 8 CPU/64Gb/3.4Mhz server can handle quite a few more
> transactions per second than a 1 CPU/1GB 1.7mhz server.
> Now go take a 'common sense' pill. ;-)
>
Is there a way to see the current queued transactions?
And estimate room in the queue space for a given server?|||"John Bailo" <jabailo@.texeme.com> wrote in message
news:y-WdnckMabPZaVrZnZ2dnUVZ_uidnZ2d@.speakeasy.net...
> Arnie Rowland wrote:
> > Standard answer: It Depends
> >
> > It depends upon Hardware (CPU, memory), network traffic, size of the
> > transactions, database traffic, query plan, what color shoes you wear,
etc.
> >
> > Obviously a 8 CPU/64Gb/3.4Mhz server can handle quite a few more
> > transactions per second than a 1 CPU/1GB 1.7mhz server.
> >
> > Now go take a 'common sense' pill. ;-)
> >
> Is there a way to see the current queued transactions?
sp_who active will show you active transactions and any blocked ones.
> And estimate room in the queue space for a given server?
Again, not nearly enough info to go on. What are the size of your
transactions.
Lots of small ones vs lots of large ones will make a big difference.

max(tag) for pair of matched rows (was "Need help on query")

I've got a table of transactions which are linked up in pairs based on the column 'Ref'. 'F's are the identifiers of each transaction while 'S's points to the 'F' of its matching pair. I need to select all the transactions with the larger 'Tag' for each pair, can someone point me in the right direction? :confused:

Tag Ref Type
-- -- --
1 200 F
1 201 S
2 201 F
2 200 S
3 202 F
3 203 S
4 203 F
4 202 S
5 204 F
5 205 S
6 205 F
6 204 SIs this what you are after?

select t.tag, t.ref, t.type
from t
join (select max(tag)as tag, ref from t
group by ref) b
on t.tag = b.tag
and t.ref = b.ref

giving you the result set

6 205 F
6 204 S
4 203 F
4 202 S
2 201 F
2 200 S|||Yes it is, thanks!