This project is read-only.

Missing indices on AuditHeader?

Jul 22, 2014 at 7:53 PM
When I'm doing inserts on my tables the performance drops dramatically with each insert (~1,000 records/insert).

A bit of testing and analysing of the execution plan suggest that the issue is two missing indices on table AuditHeader:
CREATE NONCLUSTERED INDEX [IX_AuditHeader_TableName] ON [Audit].[AuditHeader ([TableName] ASC)
CREATE NONCLUSTERED INDEX IX_AuditHeader_TableName_PrimaryKeys_RowVersion
ON Audit.AuditHeader (TableName)
INCLUDE ([PrimaryKey], [PrimaryKey2], [PrimaryKey3], [PrimaryKey4], [PrimaryKey5], [RowVersion]);
Is this a bug or is my AA installation not working properly?
Jul 29, 2014 at 9:46 AM
Has anyone else had this problem?

I have also created an issue for this:

The performance drops dramatically with just a few thousand rows so there must be a fundamental problem with my setup or the AA triggers, no?