Wednesday, March 7, 2012

login statistics

I am wondering if there is an sp in mssql server that is
equivalent to the sybase sp_reportstats.
This sp prints out the current accounting totals for all
logins, as well as each login's individual statistics and
percentage of the overall statistics.
eg
loginname, cpu, percent of cpu, I/O percent I/OHi,
Have a look into the procedure SP_WHO2 and the master..sysprocesses system
table.
Thanks
Hari
MCDBA
"Bola" <anonymous@.discussions.microsoft.com> wrote in message
news:18e0701c41bc5$9da48a50$a401280a@.phx
.gbl...
> I am wondering if there is an sp in mssql server that is
> equivalent to the sybase sp_reportstats.
> This sp prints out the current accounting totals for all
> logins, as well as each login's individual statistics and
> percentage of the overall statistics.
> eg
> loginname, cpu, percent of cpu, I/O percent I/O

No comments:

Post a Comment