Number of scheduled or custom presentation reports

If you create a large number of scheduled reports to run each night (more than 10) or use a large number of custom presentation reports (more than 10) each day, this can affect reporting performance. In particular, the following 3 reports place high demands on system resources:

  • Top n External Recipients by Message Volume
  • Top n External Recipients by Message Size
  • Top n Data Loss Prevention Violations by Volume

If you meet these usage profiles, consider investing in more hardware resources for your reporting system: more RAM, faster disks, faster CPUs, and higher-end versions of SQL Server and Windows that support more hardware.