I have about eight transactions servers accessing one MS SQL database. Every second, all transactions server will make a query to SQL Server. 90% of the time, the MS SQL server is distributing same result sets to all transactions servers. However, when number of transactions increase, SQL Server unable to cope with the request and dead lock begins to appear. I discovered that the query link to quite number of tables and retriving about 40+ fields. So, the query become slower and slower when number of transactions increase. I would like to find out anyone has any idea to set the SQL server to execute the query every second and push the result set to all the transaction servers. Is there any component to perform the job?