#Sql server client processing time update#

Output data is being sent by SQL Server with proprietary MS 'TDS protocol'.

Is the web-server in the same sub-net as the SQL server?Р”Р„re there routers/bridges etc.

Adding of allocated/specific NIC card/subnet between the servers (web-server and SQL Server).

As such, it has to be dealt with with network professionals (I am not the one). Your problem is definitely network related, based on your info.

Is there an SQL configuration parameter that restricts or limits data transfer speed between machines? We can see that the 'Client Processing Time' is equal to the total execution time.Р”Вoes anyone know what steps I can take to diagnose why the transfer of the actual data is taking a long time?

#Sql server client processing time update#

Rows affected by INSERT, DELETE, or UPDATE statements 0Р”В¬lient processing time 72441 ms (72 seconds)

Number of INSERT, DELETE and UPDATE statements 0 Here are the Client Statistics of the query, when it is ran from the remote box: Query Profile Statistics I get my first rows instantly, and then wait for over 1 minute for the batches of rows to come in. The rows come in chunks, and not all at once. (We have performance issues with all queries at the moment.)

I am testing with this very simple statement to illustrate that it's not an indexing problem or query-related problem. SELECT TOP (30000) *Р”Р‡rom any other box on the same network (connecting using SQL authentication or Windows Authentication), the same query takes 1 minute, 8 seconds. While connected to our production server (SQL Server 2008, very powerful machine), this SELECT statement takes 2 seconds, spitting back all fields (4 MB of data in total).