hi
how can i measure the inbound/outbound traffic of a certain db?
(bytes sended / received)
thankx
mike schwarz
You can use SQL Server profiler to measure the stats on a specific DB, but
you won't be able to measure bytes sent / received. Open up Profiler on a
test machine so you can view all the available counters without slowing down
your production server. You can measure transactions, RPC calls,
NTUserNames, etc. But only Performance Monitor measures bytes sent/received
and since it's a Windows Tool, not a SQL tool, you won't be able to do it by
database unless you have a machine that has only SQL on it and only one
database in that instance.
Also, check Books Online for more Profiler information.
Hope that helps.
"Mike Schwarz" wrote:
> hi
> how can i measure the inbound/outbound traffic of a certain db?
> (bytes sended / received)
> thankx
> mike schwarz
>
>
|||thankx... not helping much... maybe i will write something for my own
listening on port 1433 and sniffnig some packages out
thankx
"Catadmin" <Catadmin@.discussions.microsoft.com> schrieb im Newsbeitrag
news:04E1D671-2A98-479A-A938-DEB842BB3F60@.microsoft.com...
> You can use SQL Server profiler to measure the stats on a specific DB, but
> you won't be able to measure bytes sent / received. Open up Profiler on a
> test machine so you can view all the available counters without slowing
down
> your production server. You can measure transactions, RPC calls,
> NTUserNames, etc. But only Performance Monitor measures bytes
sent/received
> and since it's a Windows Tool, not a SQL tool, you won't be able to do it
by[vbcol=seagreen]
> database unless you have a machine that has only SQL on it and only one
> database in that instance.
> Also, check Books Online for more Profiler information.
> Hope that helps.
>
> "Mike Schwarz" wrote:
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment