SQL fast INSERT without UPDATE

Question

We use a single audit table in the SQL Server 2008 database.

The architecture with one table works beautifully, is easily requested, takes into account changes in the scheme.

But this is a serious bottleneck for the entire database. All INSERTS and UPDATES must pass the audit chart.

We already use the NOLOCK HINT statements for SELECT.

Since there is no UPDATE in this table, are there any suggestions for improving the performance of INSERT statements?

Answer 1

Make sure you have the main clustered INT (or BIGINT) IDENTITY index in the table! And, preferably, no other indexes (if possible) - this will slow down the insertion.

, , INSERT - , "" .

SQL Server, :

( "" ), . , IAM/PFS , ( , ). (CL) .

, right , ( ), , (INT BIGINT) ( , , ).

, - /, 100% FILLFACTOR , SQL-.

Answer 2

, , :

• ,
• ,
• View sproc. , . PK .. FK .
• , : + .
• "" . . . / , join union "" "".

Answer 3

, , .