Monitor data per session - available?

[Pablo Sanchez]

Hiya!

I've combed the SQL Server 2000 online help but I don't see anything
akin to Sybase ASE's 'montor' views - equivalent to Oracle's V$
views. The views are performance views which contain per session
information such as:

- SPID
- number of logical read/write and physical read I/Os accumulated
thus far
- CPU accumulated
- Memory

etc.

Does anyone know if I can snarf that data from SQL Server 2000?

Thx!
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com

[Pablo Sanchez]

Erland Sommarskog <so****@algonet.se> wrote in
news:Xn**********************@127.0.0.1:

What's wrong with sysprocesses?

In the 'olden' days (Sybase 4.x/10.x) the values weren't valid. Are
they considered valid nowadays?

Thx!
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com

[Erland Sommarskog]

Pablo Sanchez (ho******@blueoakdb.com) writes:

Erland Sommarskog <so****@algonet.se> wrote in
news:Xn**********************@127.0.0.1:

What's wrong with sysprocesses?

In the 'olden' days (Sybase 4.x/10.x) the values weren't valid. Are
they considered valid nowadays?

Sorry for the delay, but I tried to consult with my MVP colleagues and
the Microsoft people, if I would get any response.

I can't vouch for that all these values are extremely valid, but then
again, I don't think you will find anything better.

The ones on memory and CPU may be OK. Logical reads is a problem, because
with the new query strategies in SQL 7 and SQL 2000, the value reflected
by logical reads in SET STATISTICS IO may not always be accurate. And if
it's not accurate there, it is not likely to be accurate in sysprocesses
either. Still the value you see is probably good indication.

Of course, you can also use the performance monitor, but I don't think
you will find per-spid values there.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Pablo Sanchez]

Erland Sommarskog <so****@algonet.se> wrote in
news:Xn**********************@127.0.0.1:

Pablo Sanchez (ho******@blueoakdb.com) writes:

Erland Sommarskog <so****@algonet.se> wrote in
news:Xn**********************@127.0.0.1:

In the 'olden' days (Sybase 4.x/10.x) the values weren't valid.
Are they considered valid nowadays?
Sorry for the delay, but I tried to consult with my MVP colleagues
and the Microsoft people, if I would get any response.

'preciate that _very_ much.
[ sage info snipped ]

Thank you for the data Erland. FWIW, Sybase ASE has gone the way of
Oracle and now provides in-memory views of the metrics. Perhaps SQL
Server will soon follow.

Later!
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com