Configuring the Analysis Services Query Log still supported in SQL 2017/2019 ?

• Pierrot

  SSC-Addicted

  Points: 440

  More actions

  May 25, 2020 at 8:18 am

  #3757179

  Option seems to be still available, but I don't get it working. Latest documentation from MS seems to be for version 2005.

  Any suggestions ?

• Mr. Brian Gale

  SSC-Insane

  Points: 24871

  More actions

  May 25, 2020 at 5:16 pm

  #3757269

  Is this what you are looking for:

  https://docs.microsoft.com/en-us/analysis-services/instances/log-operations-in-analysis-services?view=asallproducts-allversions

  The above is all just my opinion on what you should do. 
  As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
  I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.