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
Showing posts with label party. Show all posts
Showing posts with label party. 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
>
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
>
Subscribe to:
Posts (Atom)