SQL Advanced Threat Protection taking CPU resources

• Lou

  SSCrazy

  Points: 2929

  More actions

  November 26, 2021 at 7:30 pm

  #3957313

  Hi Experts,

  I’m in charge of a SQL Server in an Azure Virtual Machine. There is an extended event running permanently, and it uses two events, sp_cache_hits and sp_cache_missed.

  The extended event session is called Advanced Threat Protection for Queries.

  I can see in the Performance Dashboard that this session is taking a lot of  CPU time, and I’m having CPU issues with this server because it is one of the first wait states.

  I wonder if it is a Good Idea to have an extended event session running forever, not considering the hypothetical benefits.

   

  Have you any idea of Advanced Threat Protection merits?

  Thank you for your answer.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 27, 2021 at 8:10 pm

  #3957475

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.