How to Identify Bottlenecks in the BAM Database
To identify bottlenecks in the BAM database, perform the following steps:
Ensure that the Active Instances count is not climbing.
Ensure that the SQL-Agent Service is running.
If OLAP Analysis is configured ensure that the BAM_AN_ job is running at periodic intervals.
Ensure that BAM_DM_ (Data Maintenance) job is scheduled to run at periodic intervals.