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 Add.
5. 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
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center