Copy data from Server1 to Server2 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy data from Server1 to Server2

Hi, I have a complecated view that exist on Server1 .
The view being executed on Server2 :
Stored procedure does select from Server1.DB.dbo.View Then result of that select being inserted into table on Server2. The probroblem that view return 370 000 records. And while execution of that rutine ( every 1 hour) I notice locking : PACEIOLATCH_SH
CXPACKET What would be the best approach to resolve locking? or to bring that amount of data to Server2?
Should I go with replication ( on an other hand it’s only one view!)
I did tried DTS package – same locking.
Why not use DTS between the servers to insert the data? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I did tried it : moved data from server1.view to server2- same locking.
Did you tried replication.
KBAhttp://support.microsoft.com/Default.aspx?kbid=822101 for study and information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>