5 Replies Latest reply on Sep 6, 2019 7:46 AM by Matthew Stromberg

    Smart Reporting - Mitigating Intensive Report Queries AR Database

    Matthew Stromberg
      Share This:

      Hi Everyone,

       

      We are currently running ITSM 9.1.03/Windows/SQL.  I have Smart Reporting question from the AR database perspective.  Recently a user ran a Smart Reporting report with a very intensive query against the production database, which pegged the CPU and greatly slowed performance.  Can anyone share experiences of how they mitigate these types issues from occurring (Non-process-related solutions)?  Note:  We are moving toward pointing Smart Reporting to a replicated DB, but in the meantime...Any tools used to monitor and kill these types of queries before impacting the database, DBAs performing certain tasks, etc.

       

      Thanks, in advance, for your input.

       

      Matt