Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
Добрый день

Прошу помощи, поскольку не знаю в какую сторону копать.

Досталась в наследство старая база, в одной из таблиц попросили увеличить размер поля с varchar(2000) до varchar(8000)

После этого через несколько месяцев база начала виснуть. sp_who показывает что виновником является запрос, который обращается к данной таблице. sp_lock показывает что процесс который залочил остальных накладывает порядка 150 -200 блокировок на страницы......

В какую сторону копать?
26 окт 18, 10:01    [21715674]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
Да, версия сервера

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)
Mar 19 2015 12:32:14
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
26 окт 18, 10:02    [21715676]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 30801
Алексей
Досталась в наследство старая база, в одной из таблиц попросили увеличить размер поля с varchar(2000) до varchar(8000)

После этого через несколько месяцев база начала виснуть. sp_who показывает что виновником является запрос, который обращается к данной таблице. sp_lock показывает что процесс который залочил остальных накладывает порядка 150 -200 блокировок на страницы......
Вообще принципиально при увеличении размера поля ничего не меняется.

Так что скорее всего, блокировки не связаны с этим изменением.

Единственно, после изменении поля, и при интенсивных апдэйтах значений, могла появиться фрагментация таблицы, так что можно попробовать её отребилдить.
26 окт 18, 10:14    [21715687]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
alexeyvg,

Вы имеете ввиду пересоздать?
26 окт 18, 10:21    [21715691]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 30801
Алексей
alexeyvg,

Вы имеете ввиду пересоздать?
Например, можно пересоздать кластерный индекс, если он есть.
Если нет - создать и удалить.
26 окт 18, 10:26    [21715701]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
alexeyvg,

Спасибо попробую
26 окт 18, 10:39    [21715719]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
StarikNavy
Member

Откуда: Москва
Сообщений: 2375
Алексей,

"я позавчера съел мороженное, а сегодня машина не заводится".
давайте план запроса, структуру таблицы и индексов
26 окт 18, 11:13    [21715754]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
StarikNavy,

Полностью согласен. Реальную таблицу показать не могу (руководство не разрешило), подготовлю фейковую для примера
26 окт 18, 11:30    [21715782]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
StarikNavy,

Структура таблиц и индексов

+
CREATE TABLE [dbo].[Item](
	[F0] [int] IDENTITY(1,1) NOT NULL,
	[F1] [varchar](64) NULL,
	[F2] [int] NOT NULL,
	[F3] [int] NOT NULL,
	[F4] [int] NOT NULL,
	[F5] [smallint] NOT NULL,
	[F6] [int] NOT NULL,
	[F7] [smalldatetime] NULL,
	[F8] [int] NOT NULL,
	[F9] [int] NOT NULL,
	[F10] [smalldatetime] NULL,
	[F11] [int] NOT NULL,
	[F12] [varchar](50) NULL ,
	[F13] [int] NULL ,
	[F14] [char](1) NOT NULL,
	[F15] [char](1) NOT NULL,
	[F16] [varchar](200) NULL,
	[F17] [smalldatetime] NULL,
	[F18] [varbinary](85) NULL,
	[F19] [int] NOT NULL,
	[F20] [char](3) NOT NULL ,
	[F21] [varchar](1) NULL,
	[F22] [varchar](1) NULL,
	[F23] [varchar](500) NULL,
	[F24] [varchar](500) NULL,
	[F25] [varchar](1) NULL,
	[F26] [varchar](1) NULL,
	[F27] [varchar](1) NULL,
	[F28] [varchar](1) NULL,
	[F29] [char](1) NOT NULL,
	[F30] [varbinary](85) NOT NULL,
	[F31] [smalldatetime] NOT NULL,
	[F32] [varbinary](85) NOT NULL,
	[F33] [smalldatetime] NOT NULL,
	[F34] [char](1) NULL,
	[F35] [char](1) NULL,
	[F36] [varchar](50) NULL ,
	[F37] [varchar](30) NULL,
	[F38] [varchar](30) NULL,
	[F39] [varchar](30) NULL,
	[F40] [smalldatetime] NULL,
	[F41] [smallint] NULL,
	[F42] [int] NULL,
	[F43] [int] NULL,
	[F44] [int] NULL,
	[F45] [int] NULL,
	[F46] [int] NULL,
	[F47] [varchar](50) NULL,
	[F48] [bit] NULL,
	[F49] [smalldatetime] NULL,
	[F50] [varchar](8000) NULL,
	[F51] [int] NULL,
	[F52] [varchar](30) NULL,
	[F53] [varchar](30) NULL,
	[F54] [varchar](2000) NULL,
	[F55] [varchar](300) NULL,
	[F56] [uniqueidentifier],
	[F57] [int] NOT NULL,
	[F58] [int] NOT NULL,
	[F59] [int] NOT NULL,
	[F60] [int] NOT NULL,
	[F61] [int] NOT NULL,
	[F62] [tinyint] NULL,
	[F63] [varchar](100) NULL,
	[F64] [varchar](1500) NULL,
	[F65] [varchar](3000) NULL,
	[F66] [varchar](1500) NULL,
	[F67] [varchar](3000) NULL,
	[F68] [smalldatetime] NULL,
	[F69] [tinyint] NULL,
	[F70] [varchar](100) NULL,
	[F71] [smalldatetime] NULL,
	[F72] [smalldatetime] NULL,
	[F73] [smallint] NULL,
	[F75] [int] NULL,
	[F76] [varchar](2050) NULL,
	[F78] [tinyint] NOT NULL,
	[F79] [int] NULL,
	[F80] [int] NULL,
	[F81] [int] NULL,
	[F82] [datetime] NULL,
 CONSTRAINT [PK_339902] PRIMARY KEY CLUSTERED 
(
	[F0] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE NONCLUSTERED INDEX [IX_1] ON [dbo].[Item]
(
	[F15] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_2] ON [dbo].[Item]
(
	[F15] ASC,
	[F29] ASC
)
INCLUDE ( 	[F0],
	[F33],
	[F69]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_3] ON [dbo].[Item]
(
	[F31] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_4] ON [dbo].[Item]
(
	[F33] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_5] ON [dbo].[Item]
(
	[F9] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_6] ON [dbo].[Item]
(
	[F75] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO



CREATE NONCLUSTERED INDEX [IX_7] ON [dbo].[Item]
(
	[F19] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_8] ON [dbo].[Item]
(
	[F44] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_9] ON [dbo].[Item]
(
	[F57] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_10] ON [dbo].[Item]
(
	[F58] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_11] ON [dbo].[Item]
(
	[F59] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_12] ON [dbo].[Item]
(
	[F60] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_13] ON [dbo].[Item]
(
	[F61] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_14] ON [dbo].[Item]
(
	[F14] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_15] ON [dbo].[Item]
(
	[F4] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO



CREATE NONCLUSTERED INDEX [IX_16] ON [dbo].[Item]
(
	[F79] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_17] ON [dbo].[Item]
(
	[F29] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_18] ON [dbo].[Item]
(
	[F45] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_19] ON [dbo].[Item]
(
	[F7] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_20] ON [dbo].[Item]
(
	[F17] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE UNIQUE NONCLUSTERED INDEX [IX_21] ON [dbo].[Item]
(
	[F56] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_22] ON [dbo].[Item]
(
	[F1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_23] ON [dbo].[Item]
(
	[F3] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO



CREATE NONCLUSTERED INDEX [IX_24] ON [dbo].[Item]
(
	[F5] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_25] ON [dbo].[Item]
(
	[F42] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_26] ON [dbo].[Item]
(
	[F11] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_27] ON [dbo].[Item]
(
	[F37] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_28] ON [dbo].[Item]
(
	[F38] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_29] ON [dbo].[Item]
(
	[F2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_30] ON [dbo].[Item]
(
	[F6] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dict1](
	[G1] [int] IDENTITY(1,1) NOT NULL,
	[G2] [varchar](900) NOT NULL,
	[G3] [varchar](900) NULL,
	[G4] [char](1) NOT NULL,
	[G5] [char](1) NOT NULL,
	[G6] [varbinary](85) NOT NULL,
	[G7] [smalldatetime] NOT NULL,
	[G8] [varbinary](85) NOT NULL,
	[G9] [smalldatetime] NOT NULL,
	[G10] [varchar](100) NULL,
	[G11] [varchar](100) NULL,
	[G12] [varchar](50) NULL,
	[G13] [varchar](50) NULL,
	[G14] [bit] NULL,
	[G15] [int] NULL,
	[G16] [char](1) NOT NULL,
	[G17] [int] NOT NULL,
	[G18] [uniqueidentifier] ROWGUIDCOL  NULL,
	[G19] [bit] NULL,
	[G20] [tinyint] NULL,
	[G21] [varchar](900) NULL,
	[G22] [varchar](900) NULL,
	[G23] [varchar](900) NULL,
	[G24] [bit] NULL,
 CONSTRAINT [PK_0554E0BE] PRIMARY KEY CLUSTERED 
(
	[G1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [C_1] UNIQUE NONCLUSTERED 
(
	[G2] 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

CREATE NONCLUSTERED INDEX [IX_31] ON [dbo].[Dict1]
(
	[G4] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE  NONCLUSTERED INDEX [IX_32] ON [dbo].[Dict1]
(
	[G17] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_33] ON [dbo].[Dict1]
(
	[G14] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_34] ON [dbo].[Dict1]
(
	[G16] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dict2](
	[H1] [int] IDENTITY(1,1) NOT NULL,
	[H2] [nvarchar](254) NOT NULL,
	[H3] [nvarchar](254) NOT NULL,
	[H4] [nvarchar](254) NOT NULL,
	[H5] [nvarchar](254) NOT NULL,
	[H6] [int] NOT NULL,
	[H7] [int] NOT NULL,
	[H8] [char](1) NOT NULL,
	[H9] [varbinary](85) NOT NULL,
	[H10] [smalldatetime] NOT NULL,
	[H11] [varbinary](85) NOT NULL,
	[H12] [smalldatetime] NOT NULL,
	[H13] [varchar](254) NULL,
	[H14] [varchar](254) NULL,
	[H15] [varchar](50) NULL,
	[H16] [varchar](50) NULL,
	[H17] [varchar](50) NULL,
	[H18] [smalldatetime] NULL,
	[H19] [tinyint] NULL,
	[H20] [int] NULL,
	[H21] [uniqueidentifier] ROWGUIDCOL  NULL,
	[H22] [tinyint] NULL,
	[H23] [varchar](254) NULL,
 CONSTRAINT [PK__87GFB8D] PRIMARY KEY CLUSTERED 
(
	[H1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_35] ON [dbo].[Dict2]
(
	[H8] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_36] ON [dbo].[Dict2]
(
	[H10] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_37] ON [dbo].[Dict2]
(
	[H15] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_38] ON [dbo].[Dict2]
(
	[H11] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_39] ON [dbo].[Dict2]
(
	[H12] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_40] ON [dbo].[Dict2]
(
	[H19] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_41] ON [dbo].[Dict2]
(
	[H7] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_42] ON [dbo].[Dict2]
(
	[H2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_43] ON [dbo].[Dict2]
(
	[H6] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE  NONCLUSTERED INDEX [IX_44] ON [dbo].[Dict2]
(
	[H20] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_45] ON [dbo].[Dict2]
(
	[H1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


Сообщение было отредактировано: 26 окт 18, 15:02
26 окт 18, 15:01    [21716212]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
aleks222
Member

Откуда:
Сообщений: 855
Да, круто. Подразделение ФСБ или внешняя разведка?

Алексей
В какую сторону копать?

В сторону "показать проблемный запрос".
Только... настоящий.
26 окт 18, 15:16    [21716231]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
StarikNavy,

Виновник блокировок согласно sp_who2

Select 
dbo.Item.[F0],
dbo.Item.[F1],
dbo.Item.[F7],
dbo.Item.[F17],
dbo.Item.[F33],
dbo.Item.[F38],
dbo.Item.[F50],
dbo.Item.[F64],
dbo.Item.[F82],
dbo.Dict1.[G2],
dbo.Dict2.[H2]

from dbo.Item 
Inner  JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]
Inner  JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]
Where NOT(dbo.Item.[F1] Like '%/%/%') AND 
dbo.Item.[F50] IS not NULL
 AND
 (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')


План выполнения запроса
+
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.6220.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="635.468" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="12.8437" StatementText="Select &#xD;&#xA;dbo.Item.[F0],&#xD;&#xA;dbo.Item.[F1],&#xD;&#xA;dbo.Item.[F7],&#xD;&#xA;dbo.Item.[F17],&#xD;&#xA;dbo.Item.[F33],&#xD;&#xA;dbo.Item.[F38],&#xD;&#xA;dbo.Item.[F50],&#xD;&#xA;dbo.Item.[F64],&#xD;&#xA;dbo.Item.[F82],&#xD;&#xA;dbo.Dict1.[G2],&#xD;&#xA;dbo.Dict2.[H2]&#xD;&#xA;&#xD;&#xA;from dbo.Item &#xD;&#xA;Inner HASH JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]&#xD;&#xA;Inner HASH JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]&#xD;&#xA;Where NOT(dbo.Item.[F1] Like '%/%/%') AND &#xD;&#xA;dbo.Item.[F50] IS not NULL&#xD;&#xA; AND&#xD;&#xA; (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')" StatementType="SELECT" QueryHash="0xEB65DAA4B90E18A2" QueryPlanHash="0xC458E8463AE8F27B">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="24" MemoryGrant="57600" CachedPlanSize="104" CompileTime="11" CompileCPU="11" CompileMemory="680">
            <RelOp AvgRowSize="1537" EstimateCPU="0.0344309" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="12.8437">
              <OutputList>
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="2724" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Parallelism>
                <RelOp AvgRowSize="1537" EstimateCPU="0.170218" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.8093">
                  <OutputList>
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                  </OutputList>
                  <MemoryFractions Input="0.579147" Output="1" />
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                  </RunTimeInformation>
                  <Hash>
                    <DefinedValues />
                    <HashKeysBuild>
                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                    </HashKeysBuild>
                    <HashKeysProbe>
                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                    </HashKeysProbe>
                    <RelOp AvgRowSize="1285" EstimateCPU="0.0328878" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Bitmap Create" NodeId="2" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="12.3651">
                      <OutputList>
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                      </RunTimeInformation>
                      <Bitmap>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Bitmap1010" />
                          </DefinedValue>
                        </DefinedValues>
                        <HashKeys>
                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                        </HashKeys>
                        <RelOp AvgRowSize="1285" EstimateCPU="0.0328878" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="12.3651">
                          <OutputList>
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                          </RunTimeInformation>
                          <Parallelism PartitioningType="Hash">
                            <PartitionColumns>
                              <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                            </PartitionColumns>
                            <RelOp AvgRowSize="1285" EstimateCPU="0.319126" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.3322">
                              <OutputList>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                              </OutputList>
                              <MemoryFractions Input="1" Output="0.420853" />
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                              </RunTimeInformation>
                              <Hash>
                                <DefinedValues />
                                <HashKeysBuild>
                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                </HashKeysBuild>
                                <HashKeysProbe>
                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                </HashKeysProbe>
                                <RelOp AvgRowSize="837" EstimateCPU="0.031923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Bitmap Create" NodeId="5" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="11.8387">
                                  <OutputList>
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                  </RunTimeInformation>
                                  <Bitmap>
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Column="Bitmap1009" />
                                      </DefinedValue>
                                    </DefinedValues>
                                    <HashKeys>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                    </HashKeys>
                                    <RelOp AvgRowSize="837" EstimateCPU="0.031923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="11.8387">
                                      <OutputList>
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                      </RunTimeInformation>
                                      <Parallelism PartitioningType="Hash">
                                        <PartitionColumns>
                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                        </PartitionColumns>
                                        <RelOp AvgRowSize="839" EstimateCPU="0.0134717" EstimateIO="11.7691" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Clustered Index Scan" NodeId="7" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="11.7825" TableCardinality="146821">
                                          <OutputList>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="23" ActualRows="134" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="11" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="1" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="21" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="24" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="18" ActualRows="97" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="20" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="22" ActualRows="108" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="12" ActualRows="97" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="17" ActualRows="105" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="5" ActualRows="93" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="19" ActualRows="102" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="6" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="16" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="15" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="13" ActualRows="109" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="14" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="10" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="9" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="4" ActualRows="95" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="7" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="8" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="3" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="2" ActualRows="155" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[Stand]" Schema="[dbo]" Table="[Item]" Index="[PK_339902]" IndexKind="Clustered" />
                                            <Predicate>
                                              <ScalarOperator ScalarString="[Stand].[dbo].[Item].[F15]='Д' AND [Stand].[dbo].[Item].[F29]&lt;&gt;'A' AND [Stand].[dbo].[Item].[F50] IS NOT NULL AND NOT [Stand].[dbo].[Item].[F1] like '%/%/%'">
                                                <Logical Operation="AND">
                                                  <ScalarOperator>
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F15" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="'Д'" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="NE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F29" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="'A'" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="IS NOT">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Logical Operation="NOT">
                                                      <ScalarOperator>
                                                        <Intrinsic FunctionName="like">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="'%/%/%'" />
                                                          </ScalarOperator>
                                                        </Intrinsic>
                                                      </ScalarOperator>
                                                    </Logical>
                                                  </ScalarOperator>
                                                </Logical>
                                              </ScalarOperator>
                                            </Predicate>
                                          </IndexScan>
                                        </RelOp>
                                      </Parallelism>
                                    </RelOp>
                                  </Bitmap>
                                </RelOp>
                                <RelOp AvgRowSize="465" EstimateCPU="0.0857282" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20077" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.17441">
                                  <OutputList>
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="23" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="8" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="22" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="20" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="21" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="9" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="10" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="7" ActualRows="53" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="4" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="18" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="24" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="17" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="19" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="11" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="6" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="5" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="12" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="14" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="16" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="13" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="15" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="1" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="3" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="2" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                  </RunTimeInformation>
                                  <Parallelism PartitioningType="Hash">
                                    <PartitionColumns>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                    </PartitionColumns>
                                    <RelOp AvgRowSize="465" EstimateCPU="0.00185348" EstimateIO="0.0868287" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20077" LogicalOp="Index Scan" NodeId="9" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0886822" TableCardinality="20077">
                                      <OutputList>
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="11" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="7" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="9" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="12" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="20" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="17" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="22" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="16" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="3" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="1" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="4" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="10" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="19" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="21" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="8" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="5" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="6" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="2" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="18" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="23" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="24" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="14" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="13" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="15" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                      </RunTimeInformation>
                                      <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Index="[C_1]" IndexKind="NonClustered" />
                                        <Predicate>
                                          <ScalarOperator ScalarString="PROBE([Bitmap1009],[Stand].[dbo].[Dict1].[G1],N'[IN ROW]')">
                                            <Intrinsic FunctionName="PROBE">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Column="Bitmap1009" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Const ConstValue="N'[IN ROW]'" />
                                              </ScalarOperator>
                                            </Intrinsic>
                                          </ScalarOperator>
                                        </Predicate>
                                      </IndexScan>
                                    </RelOp>
                                  </Parallelism>
                                </RelOp>
                              </Hash>
                            </RelOp>
                          </Parallelism>
                        </RelOp>
                      </Bitmap>
                    </RelOp>
                    <RelOp AvgRowSize="269" EstimateCPU="0.0912245" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="36395" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.273995">
                      <OutputList>
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="22" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="21" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="24" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="23" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="12" ActualRows="82" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="5" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="11" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="2" ActualRows="99" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="8" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="19" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="20" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="18" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="17" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="16" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="15" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="14" ActualRows="95" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="13" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="7" ActualRows="102" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="1" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="6" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="4" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="9" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="10" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="3" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                      </RunTimeInformation>
                      <Parallelism PartitioningType="Hash">
                        <PartitionColumns>
                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                        </PartitionColumns>
                        <RelOp AvgRowSize="269" EstimateCPU="0.00334929" EstimateIO="0.179421" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="36395" LogicalOp="Index Scan" NodeId="12" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.182771" TableCardinality="36395">
                          <OutputList>
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="24" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="19" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="1" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="21" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="20" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="23" ActualRows="71" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="14" ActualRows="82" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="22" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="17" ActualRows="120" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="10" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="11" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="6" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="9" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="8" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="12" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="18" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="15" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="2" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="7" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="13" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="5" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="3" ActualRows="117" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="4" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                          </RunTimeInformation>
                          <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Index="[IX_42]" IndexKind="NonClustered" />
                            <Predicate>
                              <ScalarOperator ScalarString="PROBE([Bitmap1010],[Stand].[dbo].[Dict2].[H1],N'[IN ROW]')">
                                <Intrinsic FunctionName="PROBE">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Bitmap1010" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="N'[IN ROW]'" />
                                  </ScalarOperator>
                                </Intrinsic>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </Parallelism>
                    </RelOp>
                  </Hash>
                </RelOp>
              </Parallelism>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>


Сообщение было отредактировано: 26 окт 18, 15:36
26 окт 18, 15:16    [21716232]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
aleks222
Member

Откуда:
Сообщений: 855
Алексей
Select 
dbo.Item.[F0],
dbo.Item.[F1],
dbo.Item.[F7],
dbo.Item.[F17],
dbo.Item.[F33],
dbo.Item.[F38],
dbo.Item.[F50],
dbo.Item.[F64],
dbo.Item.[F82],
dbo.Dict1.[G2],
dbo.Dict2.[H2]

from dbo.Item 
Inner  JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]
Inner  JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]
Where NOT(dbo.Item.[F1] Like '%/%/%') AND 
dbo.Item.[F50] IS not NULL
 AND
 (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')




Чего тут загадочного?
Условия where сканируют ВСЮ таблицу. Индексы отдыхают.
Все нормально - так и должно быть.

ЗЫ.
Сколько строк dbo.Item подпадает под условие (dbo.Item.[F15]='Д')?
26 окт 18, 15:22    [21716245]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
aleks222,

Чуть более 25000
26 окт 18, 15:26    [21716254]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
aleks222,

То что запрос написан через одно место, это понятно.

До некоторых пор он работал нормально. Теперь при вызове этого запроса из Access (насколько я понимаю по трассировке) все виснут, а обладатель запущенного запроса преспокойно работает.

При этом sp_lock показывает большое количество Shared блокировок на страницу. А sp_who2 показывает несколько строк в которых показан этот запрос.
26 окт 18, 15:29    [21716256]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
aleks222,

И не знаю теперь что с этим делать.
26 окт 18, 15:30    [21716258]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
aleks222
Member

Откуда:
Сообщений: 855
Алексей
aleks222,

То что запрос написан через одно место, это понятно.

До некоторых пор он работал нормально. Теперь при вызове этого запроса из Access (насколько я понимаю по трассировке) все виснут, а обладатель запущенного запроса преспокойно работает.

При этом sp_lock показывает большое количество Shared блокировок на страницу. А sp_who2 показывает несколько строк в которых показан этот запрос.


1. Access, по умолчанию, открывает запрос в режиме "Динамический набор данных".
Вам точно нужна возможность редактировать 25 000 строк разом?

2. Какой тип подключения использует Access у вас?
26 окт 18, 15:38    [21716267]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Алексей
Member

Откуда: Москва
Сообщений: 361
aleks222,

ODBC, если я правильно понял вопрос. здесь используется Access 2003, 2007
26 окт 18, 16:36    [21716352]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
Massa52
Member

Откуда:
Сообщений: 373
Алексей,
Это было давно. У нас начались проблемы с аксессом 2003(mdе) при переходе с SQL 2000 на 2005.
Некоторые(я уже не помню точно какого типа) запросы, которые нормально отрабатывали на 2000 на 2005 зависали намертво.
Выкрутились только через вьюшки.
27 окт 18, 02:07    [21716689]     Ответить | Цитировать Сообщить модератору
 Re: Блокировки после изменения размера поля  [new]
aleks222
Member

Откуда:
Сообщений: 855
Алексей
aleks222,

ODBC, если я правильно понял вопрос. здесь используется Access 2003, 2007


По симптомам - у вас висит недофетченная выборка.

Уточним, на всякий случай:

1. Клиент Access просто открывает форму с источником данных в виде вашего запроса, подключенного через ODBC ?
2. Или вы врукопашную чего-то там в коде VBA открываете?
27 окт 18, 05:57    [21716705]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить