title: how do i change the priority of a session ID connected to my server?
body: <p>I am running sql server 2008 on a windows 7 64 bit machine.</p>
  
  <p>I am running a query at the same time as another session ID, and I would like to lower the priority of the other session ID because my process is more critical.</p>
  
  <p>The other process is an SSIS package that is running.</p>
  
  <p>Is it at all possible to change the priority of the processes while the jobs are running?</p>
  
  <p>Is it possible to change the priority of a specific USER ID?</p>