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
Wednesday, March 7, 2012
login statistics
Labels:
accounting,
current,
database,
isequivalent,
login,
microsoft,
mssql,
mysql,
oracle,
prints,
server,
sp_reportstats,
sql,
statistics,
sybase,
totals
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment