question

sanketgroup avatar image
sanketgroup asked

Find out which client IP and Query using highest network Bandwidth

Hi I want to know which clients (IP or Hostname) are taking highest bandwidth from server and by what query they are taking high bandwidth. Is there anyway to get it done in SQL? Thanx Sanket
networkspeedup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
There's no way I know of from SQL Server to measure network bandwidth. That's a measure you have to take elsewhere because SQL Server itself doesn't have control over or monitor network packets, etc. You could look at something like [ANTS Performance Profiler][1] to see the calls to the database and how much network resources they consume. But that's done externally to SQL Server. [1]: http://www.red-gate.com/products/dotnet-development/ants-performance-profiler/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
In addition.. If you can get a sample of the queries you can use "client statistics" within SSMS. This will show the bytes sent and received by the query.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.