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