SQL Server and other applications

• sqltimd

  SSC Enthusiast

  Points: 109

  More actions

  September 10, 2003 at 12:48 pm

  #473523

  quote:

  ---

  It happens, I know it's happened to me. All you can do is document and voice your concerns as a CYA and deal with it the best you can.

  Let us know when it comes in and we may be able to help. One nice thing would be to set the memory for SQL so the allocation / deallocation isn't taking overhead.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

  ---

  Is there a way to give the SQL Server service a higher priority (in terms of CPU usage) than other apps?

  If so, that might help...

  -- Tim

• Thomas Rushton

  SSC-Insane

  Points: 22649

  More actions

  September 11, 2003 at 6:11 am

  #473686

  quote:

  ---

  Is there a way to give the SQL Server service a higher priority (in terms of CPU usage) than other apps?

  ---

  Yes.

  In Enterprise Manager, right-click the server and select "Properties". On the "Processor" tab, check the "Boost SQL Server priority on Windows".

  Alternatively use:

  sp_configure 'priority boost', 1
  
  

  Thomas Rushton
  blog: https://thelonedba.wordpress.com