jmoog (6/26/2012)
Table are use every sec. Yes there's index.some insert is 2 - 10 ms, some insert is big like 500 ms
It is difficult to say from my end.But as you tell that the table is used in every second it may be possible that some other query is creating the lock on the table or something is running behind or parallel to the insert statements.
Please use SQL profiler to check that and for a quick help get your DBA.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂