插入是否有可能使用并行性?

在什么情况下可以插入一个简单的logging(表中有10列,其中两个是XML)使用并行?

CREATE TABLE [dbo].[PackageSessions]( [PackageSessionId] [int] IDENTITY(1,1) NOT NULL, [PackageId] [int] NOT NULL, [UserId] [int] NOT NULL, [StartDateTime] [datetime] NULL, [StopDateTime] [datetime] NULL, [Score] [float] NOT NULL, [ScoreMax] [float] NOT NULL, [CompletionStatus] [int] NOT NULL, [ReviewPlayerContextId] [int] NOT NULL, [PlayerContextId] [int] NOT NULL, [ReducedScore] [float] NOT NULL, [ReducedScoreMax] [float] NOT NULL, [PackageSnapShot] [xml] NULL, [InterfaceLanguageId] [int] NOT NULL, [Data] [xml] NULL, [PackageSessionLanguageId] [int] NOT NULL, CONSTRAINT [PackageSessions_PK] PRIMARY KEY CLUSTERED ( [PackageSessionId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] 

插入一个简单的直接logging,如:

 INSERT INTO PackageSessions VALUES (1, 2, 3, NULL, NULL, 1.0, 2.0, 3, 4, 5, 6.0, 7.0, NULL, 1, NULL, 2) 

永远不会并行。 SQL服务器检测到作业可以拆分的位置,比如说如果你在一个表上进行更新,它可能把表分成两半,并把每一半分成两个不同的处理器。 如果这个工作不能很容易地拆分,那么它就不会并行运行。

(架构纳粹注:表名应该是singluar)