Time it takes a query to go over network

• SQL Hamster

  Ten Centuries

  Points: 1059

  More actions

  December 12, 2012 at 6:40 pm

  #272029

  Hi all,

  Can SQL Server Profiler show how long a SQL query takes to go over a network to arrive at the SQL Server? In my case, the SQL query is sent from a Sharepoint front end server to a SQL Server on a different server. I know Profiler can measure how long a query takes to execute, but does it have any way of tracking network time? Is there an event I can look at that helps with determining network transit time for the actual request to hit the SQL Server? I guess the other side to my question is there a way to tell how long the return results over the network portion takes?

  I'm also looking at wait stats, especially Async_Network_IO. I read some about it, it seems to have to do with the network being slow. I'm guessing this stat would give me a general sense of how fast requests and responses are but not specific to a query.

  Thank you,

  J

• Hemant.R

  Ten Centuries

  Points: 1286

  More actions

  December 14, 2012 at 5:06 am

  #1568647

  hi ,

  i think this will you in some manner

  http://www.sqlservercentral.com/Forums/Topic1142189-392-1.aspx

  have check net response using ping -t