5

I have 2 windows 7 machines on a very high security domain one acting as a server, the other as a client.

Each box has a SQL Server Express 2005 database and application "A", however I'm only using one of them to store data (the server), the client machine just uses application "A" and a system data source to connect to the server machines database.

My problem is that applciation "A" is acting funny, I'd like to see how long its taking for the data to come from the Server machines database, to the client machine.

I'd normally just ping the server from the client, but due to the restrictive GPO on this high security domain, I cant...

There are obviously firewall exceptions to allow the connectivity to travel from Server -> Client. Is there a query I can run from the client machine to give me a response time/any other useful data?

Improve this question

1 Answer 1

Reset to default
4

I think you could run a query from SQL Server Management Studio from the machine that you can connect from and run the query with client statistics. That won't be exactly the same as a ping but you can see the server execution time (time from request sent from client to time server starts to send response back) and the client processing time (time from when the server starts to send to when the client receives it). That is why it isn't a ping because client execution time includes that network time and the time on the client to process.

I'd run a fairly simple query with a handful or so of rows returned. And maybe a slightly more complex query with more rows. You should also run each of these a few times in a row to eliminate any other slowdowns with the query.

Again, this won't really be a "ping" but it can at least show you some information and you can use this to trend information over time as well by running the same queries and looking at the info.

To look at client statistics - from within the query window of SSMS, go to Query and then select Include Client Statistics. You'll see the details in the Client Statistics tab of the results.

If you could also run SSMS queries on the actual server itself and run the same queries you can look at the difference in these times for the same queries and that should give a rough approximation of the impact of network latency perhaps.

Improve this answer
1
  • 1
    And I think the real answer is probably that you request permission to access proper network statistics, if you are experiencing network issues or worried that you are. The networking team should be monitoring this for you or at least be able to look at better tools than ping or my approach above to determine network latency issues. Commented Nov 26, 2012 at 4:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.