I am setting up link servers from one of my production server which installed SQL 2008 and link to SQL 2000 Server (remote server). I have created the link-server as below
General => Using Microsoft OLE DB Provider for SQL Server Link Server Name - TEST Product Name - Remote_ServerName Data Source - Remote_ServerName
Security => Be Made using this security context user id - xxx password - xxx
Server Option => All False except Data Access, RPC, RPC OUT, Use Remote Collation are True.
I have already setup same settings on 4 other productions server and I have no performance problem.
Anybody can tell me why that is too slow on my New Production Server. Network Problem??
**I have already use profiler and it said Duration - 107016 to run the stored procedure and other servers are only 506 on SAME QUERY/SCRIPT.