Posted by Erland Sommarskog on 04/12/06 00:42

(wangzhi0417@gmail.com) writes:
> I want to write a application monitering program to collect the SQL
> Server 2000 performance data,
> such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it
> , In Oracle , there are the v$ views and DBA view , which I can find
> the information I interested, the question is , is there a similar suit
> of view in SQL Server 2000 to provide the performance information ?
> Thank you very much, I will be mad by this question, for I have googled
> all the day , but in vain

Look at the table sysperfinfo.

In SQL 2005 this changes drastically. SQL 2005 exposes a lot more
information of this kind.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]