Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  server side[?] query execution time

Author  Topic  rw30 Starting Member 3 Posts Posted - 2009-06-28 : 10:46:15 hi, I would like to know what is query execution time but without overhead added by : ---transferring data thru the network ---visualizing data rows in client application ---other things I didn't mention ;) example: I run a query select * from fac1 in SSMS buffers are cleared before each execution once I ran it at the machine where the server is installed, query execution time shown by SS Profiler [or at 'Messages' tab after executing SET STATISTICS TIME ON] is ~22secs when I ran same query at the machine connected to the server by the wireless network, query execution time is ~76 secs same query, same execution plan etc etc.... [and, of course, query plan says that cost of selection is very small when compared to table scan ] so the difference seems to be caused by network latency; situation would be the same if the query returns big amount of data, i.e. there would be some latency caused just by waiting for the rows to appear in SMSS window; is that possible to know query execution time not influenced by those factors ? regards, kk