Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server stats

Author  Topic 

lebedev
Posting Yak Master

126 Posts

Posted - 2002-07-02 : 14:49:27
I am trying to display some SQL Server statistics from my application. I want to be able to query system tables to retrieve such information as which clients made which RPC calls, how much network traffic was generated by a particular request, how long it took to execute a query, etc.
Can anyone tell me what system tables I should look at or provide me with links that could help me.
thanks

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-07-02 : 15:18:58
You might try configuring a SQL Profiler trace to capture that data and read the results of the trace in your application.

Jonathan Boott, MCDBA
Go to Top of Page
   

- Advertisement -