var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: frequent insert & delete table in multi-processing env
Any suggestion how to improve the performance for frequent insert & delete table in multi-processing env? e.g prevent deadlock, blocking ... etc
Make sure that the queries run as smoothly as possible, with as little IO as possible, and with short transactions.
So this means making sure that indexes, etc. are "correct" for your environment.
Use showplan, statistics IO, etc to tune both the inserts/updates/deletes and any select queries.
Depending on the system you may also want to tune the log IO size, the ULC cache, etc. sp_sysmon can give you some hints on these issues, and of course the P&T Manual...