Data Collection not working after installing SP2

• gerben.scherpenzeel

  SSC Enthusiast

  Points: 156

  More actions

  October 7, 2019 at 2:01 pm

  #3686683

  We patched an SQL Server 2016 installation with SP2. For this installation, Data Collection was activated with the default System Data Collection Sets. However, after the patching, the collection job for the Server Activity failed with the following message:

  Message

  Executed as user: <xxx>. The step did not generate any output. Process Exit Code -1073741819. . NOTE: The step was retried the requested number of times (3) without succeeding. The step failed.

  After some testing with user created sets, we found out that the culprit was an entry in the Performance Counters Collection Item:

  <PerformanceCounters Objects="Server Work Queues" Counters="Queue Length" Instances="*" />

  When this counter is removed from the default definition for the Server Activity data collection set, it works again.

  However, this counter works without any issues when looked at in the Perfomance Monitor.

  So, now we are left with the following questions:

  • why is this performance counter giving this issues?
  • how do we solve this, so the Server Activity System Data Collection Set will work again?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 8, 2019 at 2:10 pm

  #3687004

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

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