KB 340105: ACS Query and Report performance is slow
ACS query and report performance can be degraded by a variety of factors.
Issue: Queries and Reports ran against the Online ACS Audit Database timeout or take considerably long to run and may cause performance spikes on database
Symptoms: Query and Report response time is degraded after initial installation or over time.
Cause: There can be multiple causes associated with poor query and report performance
Scope: Any ACS environment
Product/s: Security Auditing
Resolution
Confirm ACS is healthy and database accessible then investigate and resolve underlying performance constraints
ACS Partitions not being Indexed properly, see Microsoft KB 949969 Unindexed partitions play a huge role on the performance of queries ran against the audit database and is commonly seen on environments using SQL Standard or Shared Resources. Insufficient Memory on Database Server, we recommend 16-32GB Insufficient filter policy or grooming practices Running SSRS on Database Server, always recommend Remote SSRS over Local install Using a 32-bit vs 64-bit SQL Engine Excessive # of Partitions in DB or overall Size of DB Query to generic or targeted at inproper view; only use the view you need: dvAll, dvAll5, dvHeader Underlying ACS health issues
For assistance investigating performance issues please contact support at support@securevantage.com
|
|
|
|