December 12, 2012 at 6:40 pm
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
December 14, 2012 at 5:06 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply