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  SQL Server 2000 Forums  SQL Server Development (2000)  ASP Querying linked servers

Author  Topic  rhankin Starting Member 5 Posts Posted - 2005-07-21 : 07:10:46 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??