Sql server agent: Allow service to interact with desktop

• roblew 15918

  Ten Centuries

  Points: 1059

  More actions

  March 9, 2015 at 10:04 am

  #305594

  Hi

  Just wondering if anyone has much information on this, what sort of things would it interact with to justify having this ticked as the sqlserver.exe seems to be consuming all the CPU constantly and some suggestions have said that having this ticked can cause a performance issue.

• udaynov17

  SSC Eights!

  Points: 832

  More actions

  March 9, 2015 at 2:53 pm

  #1782708

  Check this.

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a6fd7f30-cabd-4cda-a117-ad9a862ea5a6/sqlservrexe-is-continually-eating-more-memory?forum=sqldatabaseengine

• roblew 15918

  Ten Centuries

  Points: 1059

  More actions

  March 10, 2015 at 4:42 am

  #1782835

  Thanks but that is about memory not CPU and the link to the desktop

• udaynov17

  SSC Eights!

  Points: 832

  More actions

  March 11, 2015 at 10:55 am

  #1783395

  Please look into this

  http://www.mssqltips.com/sqlservertip/2454/how-to-find-out-how-much-cpu-a-sql-server-process-is-really-using/