There is a DTS package running in development, SIT and UAT. In every environment, all SQL servers have the same linked server setup and the technical similarities are the same. DTS takes different amounts of time to execute the package. It should take approximately 3 hours for the package to be run on those tables which are accessed through the linked server. Does the index become a server cache?
no
Each link / target server will have its own position of fragmentation, index state and number of rows can affect performance.
In addition, does each linked server have the same (like collation compatible?) Which can affect the queries.
Finally (unless I do not edit with more stuff), you have network traffic, server load, local index / statistics etc. Just, you will not get almost constant results ... If I ever did, I would wonder what I did for the 3-hour package ...
Comments
Post a Comment