I would like to know the expert comments on the usage of service broker in a trigger in SQL server to move data. My question is would it affect the performance of my application if i have more concurrent users in the environment. Where is the place I should look into?