Performance monitoring/tracing -- sql server new users

Stan
1/3/2005 12:35:04 PM

I was tring to get the performance stats like CPU time per transaction, IO
per transaction, etc. I tried SQL Profiler, but the event "SQL Transaction"
tracks all transaction begin/commit/rollback and doesn't capture the resource
used by the transaction. Is there any other ways of tracing the per
transaction stats in SQL Server?

Nitin
1/4/2005 11:59:09 AM

That comes in the next screen,

[quoted text, click to view]

John Gallardo [MSFT]
1/27/2005 5:52:01 PM

Have you tried using perfmon? SQL registers many performance counters in
there. You might find what you are looking for.

--
John Gallardo
SQL Server Engine
Microsoft Corp
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Performance monitoring/tracing