Showing posts with label bandwidth. Show all posts
Showing posts with label bandwidth. Show all posts

Wednesday, March 21, 2012

Measuring Bandwidth used by SQL server

Does anyone know how one can measure the network bandwidth used by sql
server on a per database level? Is there any 3rd party tools available that
anyone is aware of. Any ideas would be appreciated.
Thanks,
-RyanMy 2 cents:
I don't think you're going to be able to measure it on a db level. However,
to measure sql server's bandwidth you'd need a network sniffer, isolate the
sql server traffic (be careful of what network libraries you're using, if
only TCP/IP then count packets on TCP port 1433) and do some accounting...
HTH
Argenis
"Ryan" <ryanz(nospam)@.nospamiqmetrix.com> wrote in message
news:OfcaPQ89DHA.3792@.TK2MSFTNGP09.phx.gbl...
> Does anyone know how one can measure the network bandwidth used by sql
> server on a per database level? Is there any 3rd party tools available
that
> anyone is aware of. Any ideas would be appreciated.
> Thanks,
> -Ryan
>sql

Measuring Bandwidth used by SQL server

Does anyone know how one can measure the network bandwidth used by sql
server on a per database level? Is there any 3rd party tools available that
anyone is aware of. Any ideas would be appreciated.
Thanks,
-RyanMy 2 cents:
I don't think you're going to be able to measure it on a db level. However,
to measure sql server's bandwidth you'd need a network sniffer, isolate the
sql server traffic (be careful of what network libraries you're using, if
only TCP/IP then count packets on TCP port 1433) and do some accounting...
HTH
Argenis
"Ryan" <ryanz(nospam)@.nospamiqmetrix.com> wrote in message
news:OfcaPQ89DHA.3792@.TK2MSFTNGP09.phx.gbl...
> Does anyone know how one can measure the network bandwidth used by sql
> server on a per database level? Is there any 3rd party tools available
that
> anyone is aware of. Any ideas would be appreciated.
> Thanks,
> -Ryan
>