Sunday, March 7, 2010

Checking Bandwidth to SQL Server

Once in a while the bandwidth to a remote SQL Server accounts for poor performance. In some odd cases, the problem can be tracked down to someone accidently dropping a 10BaseT switch or hub in a route that is otherwise 1000BaseT. This can be very hard to detect because your machine to the internet shows the speed of the first link and not the speed across the entire link.


There is an easy way to do this if you have a big table on your SQL Server. Open SSMS, connect to the database execute Shift-Alt-S (Query / Show Client Statistics) . Execute a Select * From {tablename} and look at the Client Statistics tab. Do a division of

  • bytes received from server/client processing time

to give you a rough estimate. Two examples are shown below:


which results in 136


which results in 11207


  • The first case was hitting a SQL Server over a 3G link.
  • The second case was hitting a database on the local network.

A nice simple way of checking bandwidth end-to-end.

No comments:

Post a Comment