SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:39 PM
| ||||
| ||||
 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      |
|
02-28-2008, 05:39 PM
| |||
| |||
| Re: Monitor data per session - available? Erland Sommarskog <sommar@algonet.se> wrote in news:Xns93E5EFFB099AEYazorman@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 |
|
02-28-2008, 05:43 PM
| |||
| |||
| Re: Monitor data per session - available? Pablo Sanchez (honeypot@blueoakdb.com) writes: > Erland Sommarskog <sommar@algonet.se> wrote in > news:Xns93E5EFFB099AEYazorman@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, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
|
02-28-2008, 05:44 PM
| ||||
| ||||
| Re: Monitor data per session - available? Erland Sommarskog <sommar@algonet.se> wrote in news:Xns93EAE79435FA0Yazorman@127.0.0.1: > Pablo Sanchez (honeypot@blueoakdb.com) writes: >> Erland Sommarskog <sommar@algonet.se> wrote in >> news:Xns93E5EFFB099AEYazorman@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 |
Linear Mode
