I have an asp page which queries a stored procedure to return a recordset. The procedure queries a local table and table on a linked server. The linked server is another sql instance on the same machine. When I run the procedure from Query analyser the result is returned in 1 second. When I run from an asp page it returns in around 90 seconds. On my test server (A considerably slower machine) the procedure queries a local table and a linked server. The linked server is the same that is queried on live. This means it is querying an instance on a physically different machine yet the web page returns almost instantly. I would expect the live system to be faster. It has more memory per instance, better processing and does not require any network transfer for the server link. I have checked Task manager while the query runs and both instances are running above 30% cpu during the query. We run an ERP system on this server and it rarely goes above 20% cpu normally. Has anyone else had this issue where 2 instances on the same machine have such a hard time talking to eachother??