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.