Table are use every sec. Yes there's index.

some insert is 2 - 10 ms, some insert is big like 500 ms

Here is the insert command

NSERT INTO [TT_TSAPIDataA]

([SiteId]

,[ReferenceId]

,[CallId]

,[ResultingCallId]

,[SourceIP]

,[DestinationIP]

,[ProtocolId]

,[ApplicationId]

,[OperationValue]

,[SpecificEvent]

,[DNIS]

,[ANI]

,[CallingNumber]

,[CallingAddressType]

,[CalledNumber]

,[CalledAddressType]

,[DomainExtension]

,[Count]

,[OriginationPort]

,[ConnectedNumber]

,[ConnectedNumber2]

,[ConnectedAddressType]

,[TrunkGroup]

,[TrunkMember]

,[Cause]

,[DateReceived]

,[TimeZoneOffset])

VALUES

(@SiteId1,

@ReferenceId1,

@CallId1,

@ResultingCallId1,

@SourceIP1,

@DestinationIP1,

@ProtocolId1,

@ApplicationId1,

@OperationValue1,

@SpecificEvent1,

@DNIS1,

@ANI1,

@CallingNumber1,

@CallingAddressType1,

@CalledNumber1,

@CalledAddressType1,

@DomainExtension1,

@Count1,

@OriginationPort1,

@ConnectedNumber1,

@ConnectedNumber21,

@ConnectedAddressType1,

@TrunkGroup1,

@TrunkMember1,

@Cause1,

DATEADD(mi,@TimeZone,@DateReceived1), --@DateReceived

@TimeZone)

)

Hi,

No triggers on table. I am doing the direct insert in stored procedure. Here is the code. What do you think about the table structure? Is it good enough?

[usp_Insert]

(

...