jmoog (6/26/2012)

---

Hi Guys,

Can you please figure out the reason why insert with this table is sometimes slow. Some insert 2 ms, some insert 500 ms. Here is the schema

CREATE TABLE [dbo].[TT_TSAPIDataA](

[TempCallDataId] [int] IDENTITY(1,1) NOT NULL,

[SiteId] [tinyint] NOT NULL,

[ReferenceId] [smallint] NULL,

[CallId] [int] NOT NULL,

[ResultingCallId] [int] NULL,

[SourceIP] [char](15) NOT NULL,

[DestinationIP] [char](15) NOT NULL,

[ProtocolId] [tinyint] NULL,

[ApplicationId] [int] NULL,

[OperationValue] [varchar](50) NULL,

[SpecificEvent] [varchar](50) NULL,

[DNIS] [int] NULL,

[ANI] [varchar](20) NULL,

[CallingNumber] [varchar](20) NULL,

[CallingAddressType] [varchar](20) NULL,

[CalledNumber] [varchar](20) NULL,

[CalledAddressType] [varchar](20) NULL,

[DomainExtension] [int] NULL,

[Count] [tinyint] NULL,

[OriginationPort] [int] NULL,

[ConnectedNumber] [varchar](20) NULL,

[ConnectedNumber2] [varchar](20) NULL,

[ConnectedAddressType] [varchar](20) NULL,

[TrunkGroup] [smallint] NULL,

[TrunkMember] [smallint] NULL,

[Cause] [varchar](50) NULL,

[DateReceived] [datetime] NOT NULL,

[TimeZoneOffset] [smallint] NULL

CONSTRAINT [PK_TT_TSAPIDataA] PRIMARY KEY CLUSTERED

(

[TempCallDataId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[TT_TSAPIDataA] ADD CONSTRAINT [DF_TT_TSAPIDataA_DateReceived] DEFAULT (getutcdate()) FOR [DateReceived]

GO