1. Start
SSSM and create a database (or restore a version of AdventureWorks db)
2. Create 10 000 tables with 20 columns each and each table should have a primary key
3. Start
ApexSQL Audit UI and go to the
Before-after tab
4. Add the instance where you created the DB for auditing, select that DB and click on
Add5. The Before-after section of the UI freezes and the logs are showing a timeout message for retrieving table and column data
Expected result: A database can be added for Before-after auditing regardless of the number of primary keys (and indexes) that are present in the DB