title: Preference by user SQL Server
body: <p>I have a question about performance on my SQL Server over Axapta ERP.</p>
  
  <p>At this moment we have a multiple queries over ERP, RSS, and others. These queries do not negatively impact the performance, but we have a specific query in web app developed in node.js which does affect our ERP directly. The problem is, the forms in ERP are displaying the data very slowly when other queries (web app) are executing at the same time.</p>
  
  <p>My question: is there are some method to give priority to some queries by user for example? Similar as QOS but for SQL?</p>
  
  <p>I think it is not possible because I never heard anything about it, but one person told me that it is possible.</p>
  
  <p>Thanks a lot! :)</p>