June 18, 2004 at 2:11 am
Hi
I've 2 sqlsvr 7.0
On Svr A, I maked a linkserver "Link_A", connect Svr B
On Svr B, I had a table "ABC(ID,Name)" on DB (Test)
recount > 1000 records
I connect to svr A and run the following:
"update Link_A.TEST.dbo.abc set Name = 'my name' where ID = 123"
Why, it's run too slow ?
Regards
June 21, 2004 at 8:00 am
This was removed by the editor as SPAM
June 21, 2004 at 9:28 am
Hi, could you test the following
1. How much time does it take for this statement to be executed locally on server B
2. What is the network protocol that you are using? Named Pipes may take time establishing a connection
3. How is the network connection? How much time does it take to copy a file between 2 servers
4 How are you doing on memory on both servers?
Regards,Yelena Varsha
June 26, 2004 at 1:25 am
1. How much time does it take for this statement to be executed locally on server B
-> On server B, it do immediately.
2. What is the network protocol that you are using? Named Pipes may take time establishing a connection
-> I used TCP/IP
3. How is the network connection? How much time does it take to copy a file between 2 servers
-> I used dial-up line and Ras (remote access service) to connect between 2 servers
4 How are you doing on memory on both servers?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply