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?