Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sysperfinfo

Status
Not open for further replies.
7280

7280

MIS
Apr 29, 2003
331
IT
Hi,
I was asked to give the following performance information about some sql databases:
- DB Response Time (msec)
- Workthrough

So I started looking at "SQL Server Online books" and I found the sysperfinfo table.
I queried it and found some info like "Transactions/sec" in the counter_name column.
But there isn't a detailed information about cntr_value column. It doesn't seem a reasonable value for my application. I thought that value was an "average" of transactions/sec since startup, but it seems a counter of the number of transactions from startup.

Please help. How can I find those info?

Thanks.
 
Status
Not open for further replies.

Similar threads

vadimg
  • Locked
  • Question
No SQL counters in perfmon and sysperfinfo is empty
Replies
3
Views
46
grimwyre
grimwyre

Part and Inventory Search

Sponsor

Back
Top