The cross-server join in your view could be a concern. If the 2 tables are large, the select may experience time-out. Take a look of the execution plan of the...