469,649 Members | 1,443 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,649 developers. It's quick & easy.

Monitor data per session - available?

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
Jul 20 '05 #1
3 1734
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
Jul 20 '05 #2
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
Jul 20 '05 #3
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
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Paul | last post: by
8 posts views Thread by Frnak McKenney | last post: by
1 post views Thread by HockeyTownUSA | last post: by
10 posts views Thread by mattmerc | last post: by
4 posts views Thread by Sarah Marriott | last post: by
reply views Thread by wingnut144 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.