I am executing remote query from Server "A" to server "B" . When I am monitoring progress of query on server "B" from sysprocesses table , it always show CPU & Physical_io as ZERO . How can i make sure that my query is running ? Its status is "Runnable " . But it should show me physical_io .

Please help me .

-- Anonymous, May 31, 2002

Answers

Shrinivas,

I'd start by catching the statement which one SQL Server is submitting to the other. You can see that in showplan, or (possibly) catch it with SQLTrace.

Hope this helps,

Eric

-- Anonymous, June 20, 2002