ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข > ื“ืขืกื™ืคืขืจ ืฉืœื™ืกืœ ืื•ืŸ Page WaitResource ืื™ืŸ ื“ืขื“ืœื™ืึทืงืก ืื•ืŸ ืœืึทืงืก

ื“ืขืกื™ืคืขืจ ืฉืœื™ืกืœ ืื•ืŸ Page WaitResource ืื™ืŸ ื“ืขื“ืœื™ืึทืงืก ืื•ืŸ ืœืึทืงืก

ืื•ื™ื‘ ืื™ืจ ื ื•ืฆืŸ ื“ื™ ืืคื’ืขืฉื˜ืขืœื˜ ืคึผืจืึธืฆืขืก ื‘ืึทืจื™ื›ื˜ ืึธื“ืขืจ ืงืœื™ื™ึทื‘ืŸ ื“ื™ ื“ืขื“ืœืึทืง ื’ืจืึทืคืก ืฆื•ื’ืขืฉื˜ืขืœื˜ ื“ื•ืจืš SQL Server ืคึผื™ืจื™ืึทื“ื™ืงืœื™, ืื™ืจ ื•ื•ืขื˜ ื˜ืจืขืคืŸ ื–ืื›ืŸ ื•ื•ื™ ื“ืึธืก:

waitresource = "PAGE: 6:3:70133"

waitresource=โ€œKEY: 6:72057594041991168 (ce52f92a058c)โ€œ

ืžืืœ ืขืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ืžืขืจ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืื™ืŸ ื“ืขื ืจื™ื– ืงืกืžืœ ืื™ืจ ืœืขืจื ืขืŸ (ื“ืึทื“ืœืึทืง ื’ืจืึทืคืก ืึทื ื˜ื”ืึทืœื˜ืŸ ืึท ืจืฉื™ืžื” ืคื•ืŸ ืจืขืกื•ืจืกืŸ ื•ื•ืึธืก ื”ืขืœืคึผืก ืื™ืจ ื’ืขืคึฟื™ื ืขืŸ ื“ื™ ื ืึธืžืขืŸ ืคื•ืŸ ื“ื™ ื›ื™ื™ืคืขืฅ ืื•ืŸ ืื™ื ื“ืขืงืก), ืึธื‘ืขืจ ื ื™ื˜ ืฉื˜ืขื ื“ื™ืง.

ื“ืขืจ ื˜ืขืงืกื˜ ื•ื•ืขื˜ ื”ืขืœืคืŸ ืื™ืจ ื“ื™ืกื™ื™ืคืขืจ ื–ื™ื™.

ืึทืœืข ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ื•ื•ืึธืก ืื™ื– ื“ืึธ ืื™ื– ืื•ื™ืฃ ื“ื™ ืื™ื ื˜ืขืจื ืขื˜ ืื™ืŸ ืคืึทืจืฉื™ื“ืŸ ืขืจื˜ืขืจ, ืขืก ืื™ื– ื ืึธืจ ื–ื™ื™ืขืจ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜! ืื™ืš ื•ื•ื™ืœืŸ ืฆื• ืฉื˜ืขืœืŸ ืึทืœืฅ ืฆื•ื–ืึทืžืขืŸ - ืคึฟื•ืŸ DBCC PAGE ืฆื• hobt_id ืื•ืŸ ืฆื• ื“ื™ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ %% physloc%% ืื•ืŸ %% lockres%% ืคืึทื ื’ืงืฉืึทื ื–.

ืขืจืฉื˜ืขืจ, ืœืึธืžื™ืจ ืจืขื“ืŸ ื•ื•ืขื’ืŸ ื•ื•ื™ื™ืฅ ืื•ื™ืฃ PAGE ืœืึทืงืก, ืื•ืŸ ื“ืขืจื ืึธืš ืžื™ืจ ื’ื™ื™ืŸ ืฆื• KEY ืœืึทืงืก.

1) waitresource = "PAGE: 6:3:70133" = Database_Id: FileId: PageNumber

ืื•ื™ื‘ ื“ื™ื™ืŸ ืึธื ืคึฟืจืขื’ ืื™ื– ื•ื•ืืจื˜ืŸ ืื•ื™ืฃ ืึท ื‘ืœืึทื˜ ืฉืœืึธืก, SQL Server ื•ื•ืขื˜ ื’ืขื‘ืŸ ืื™ืจ ื“ื™ ืึทื“ืจืขืก ืคื•ืŸ ื“ืขื ื‘ืœืึทื˜.

ื‘ืจื™ื™ืงื™ื ื’ ืึทืจืึธืคึผ "PAGE: 6:3:70133" ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ:

  • ื“ืึทื˜ืึทื‘ืึทืกืข_ื™ื“ = 6
  • data_file_id = 3
  • ื‘ืœืึทื˜_ื ื•ืžืขืจ = 70133

1.1) ื“ืขืงืจื™ืคึผื˜ ื“ืึทื˜ืึทื‘ื™ื™ืก_ื™ื“

ืœืึธืžื™ืจ ื’ืขืคึฟื™ื ืขืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื ืึธืžืขืŸ ื ื™ืฆืŸ ื“ื™ ืึธื ืคึฟืจืขื’:

SELECT 
    name 
FROM sys.databases 
WHERE database_id=6;
GO

ื“ืึธืก ืื™ื– ืฆื™ื‘ื•ืจ DB WideWorldImporters ืื•ื™ืฃ ืžื™ื™ืŸ ืกืงืœ ืกืขืจื•ื•ื™ืจืขืจ.

1.2) ืื™ืจ ื–ื•ื›ื˜ ืคึฟืึทืจ ื“ื™ ื ืึธืžืขืŸ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืŸ ื˜ืขืงืข - ืื•ื™ื‘ ืื™ืจ ื–ืขื ื˜ ืื™ื ื˜ืขืจืขืกื™ืจื˜

ืžื™ืจ ื•ื•ืขืœืŸ ื ื•ืฆืŸ data_file_id ืื™ืŸ ื“ืขืจ ื•ื•ื™ื™ึทื˜ืขืจ ืฉืจื™ื˜ ืฆื• ื’ืขืคึฟื™ื ืขืŸ ื“ื™ ื˜ื™ืฉ ื ืึธืžืขืŸ. ืื™ืจ ืงืขื ื˜ ืคืฉื•ื˜ ื”ืึธืคึผืงืขืŸ ืฆื• ื“ืขืจ ื•ื•ื™ื™ึทื˜ืขืจ ืฉืจื™ื˜, ืึธื‘ืขืจ ืื•ื™ื‘ ืื™ืจ ื–ืขื ื˜ ืื™ื ื˜ืขืจืขืกื™ืจื˜ ืื™ืŸ ื“ืขืจ ื˜ืขืงืข ื ืึธืžืขืŸ, ืื™ืจ ืงืขื ืขืŸ ื’ืขืคึฟื™ื ืขืŸ ืขืก ื“ื•ืจืš ืœื•ื™ืคืŸ ืึท ืึธื ืคึฟืจืขื’ ืื™ืŸ ื“ืขื ืงืึธื ื˜ืขืงืกื˜ ืคื•ืŸ ื“ื™ ื’ืขืคึฟื•ื ืขืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก, ืคืึทืจื‘ื™ื™ึทื˜ืŸ data_file_id ืื™ืŸ ื“ืขื ืึธื ืคึฟืจืขื’:

USE WideWorldImporters;
GO
SELECT 
    name, 
    physical_name
FROM sys.database_files
WHERE file_id = 3;
GO

ืื™ืŸ ื“ื™ WideWorldImporters ื“ืึทื˜ืึทื‘ื™ื™ืก ื“ืึธืก ืื™ื– ืึท ื˜ืขืงืข ื’ืขืจื•ืคืŸ WWI_UserData ืื•ืŸ ืื™ืš ื”ืึธื‘ืŸ ืขืก ื’ืขื–ื•ื ื˜ ืฆื• C: MSSQLDATAWideWorldImporters_UserData.ndf. (ืื•ื™ืฃ, ื“ื• ื”ืืกื˜ ืžื™ืš ื’ืขื›ืืคื˜ ืฆื• ืฉื˜ืขืœืŸ ืคื™ื™ืœืก ืื•ื™ืคืŸ ืกื™ืกื˜ืขื ื“ื™ืกืง! ื ื™ื™ืŸ! ื“ืืก ืื™ื– ื’ืขื•ื•ืขืŸ ืื•ืžื‘ืืงื•ื•ืขื).

1.3) ื‘ืึทืงื•ืžืขืŸ ื“ื™ ื›ื™ื™ืคืขืฅ ื ืึธืžืขืŸ ืคึฟื•ืŸ DBCC PAGE

ืื™ืฆื˜ ืžื™ืจ ื•ื•ื™ืกืŸ ืึทื– ื‘ืœืึทื˜ #70133 ืื™ืŸ ื“ืึทื˜ืŸ ื˜ืขืงืข 3 ื’ืขื”ืขืจื˜ ืฆื• ื“ื™ WorldWideImporters ื“ืึทื˜ืึทื‘ื™ื™ืก. ืžื™ืจ ืงืขื ืขืŸ ืงื•ืงืŸ ืื™ืŸ ื“ื™ ืื™ื ื”ืึทืœื˜ ืคื•ืŸ ื“ืขื ื‘ืœืึทื˜ ืžื™ื˜ ื“ื™ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ DBCC ื‘ืœืึทื˜ ืื•ืŸ ืฉืคึผื•ืจ ืคืึธืŸ 3604.
ื‘ืึทืžืขืจืงื•ื ื’: ืื™ืš ื‘ืขืกืขืจ ืฆื• ื ื•ืฆืŸ DBCC PAGE ืื•ื™ืฃ ืึท ื’ืขื–ื•ื ื˜ ืงืึธืคึผื™ืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืึท ื‘ืึทืงืึทืคึผ ืขืจื’ืขืฅ ืื•ื™ืฃ ืืŸ ืื ื“ืขืจ ืกืขืจื•ื•ืขืจ, ื•ื•ื™ื™ึทืœ ื“ืึธืก ืื™ื– ืึทืŸ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ ื–ืึทืš. ืื™ืŸ ืขื˜ืœืขื›ืข ืงืึทืกืขืก, ื–ื™ ืงืขืŸ ืจืขื–ื•ืœื˜ืึทื˜ ืื™ืŸ ืึท ื“ืึทืžืคึผ ื–ื™ื™ึทืขื ื“ื™ืง ื‘ืืฉืืคืŸ (ืึทืคึผืคึผืจืึธืงืก. ืื™ื‘ืขืจื–ืขืฆืขืจ - ื“ืขืจ ืœื™ื ืง, ืœื™ื™ื“ืขืจ, ืคื™ืจื˜ ื™ื  ืขืจื’ืขืฆ ื ื™ื˜, ืึธื‘ืขืจ ืื•ื™ื‘ ืžืฉืคื˜ืŸ ืœื•ื™ื˜ ื“ื™ URL, ืžื™ืจ ื–ืขื ืขืŸ ื’ืขืจืขื“ื˜ ื•ื•ืขื’ืŸ ืคื™ืœื˜ืขืจื“ ื™ื ื“ืขืงืกื™ื–).

/* This trace flag makes DBCC PAGE output go to our Messages tab
instead of the SQL Server Error Log file */
DBCC TRACEON (3604);
GO
/* DBCC PAGE (DatabaseName, FileNumber, PageNumber, DumpStyle)*/
DBCC PAGE ('WideWorldImporters',3,70133,2);
GO

ืกืงืจืึธืœืœื™ื ื’ ื“ื•ืจืš ื“ื™ ืจืขื–ื•ืœื˜ืึทื˜ืŸ, ืื™ืจ ืงืขื ืขืŸ ื’ืขืคึฟื™ื ืขืŸ object_id ืื•ืŸ index_id.
ื“ืขืกื™ืคืขืจ ืฉืœื™ืกืœ ืื•ืŸ Page WaitResource ืื™ืŸ ื“ืขื“ืœื™ืึทืงืก ืื•ืŸ ืœืึทืงืก
ื›ึผืžืขื˜ ื’ืขื˜ืืŸ! ืื™ืฆื˜ ืื™ืจ ืงืขื ืขืŸ ื’ืขืคึฟื™ื ืขืŸ ื“ื™ ื˜ื™ืฉ ืื•ืŸ ืื™ื ื“ืขืงืก ื ืขืžืขืŸ ื ื™ืฆืŸ ื“ื™ ืึธื ืคึฟืจืขื’:

USE WideWorldImporters;
GO
SELECT 
    sc.name as schema_name, 
    so.name as object_name, 
    si.name as index_name
FROM sys.objects as so 
JOIN sys.indexes as si on 
    so.object_id=si.object_id
JOIN sys.schemas AS sc on 
    so.schema_id=sc.schema_id
WHERE 
    so.object_id = 94623380
    and si.index_id = 1;
GO

ืื•ืŸ ืื™ืฆื˜ ืžื™ืจ ื–ืขืŸ ืึทื– ื“ื™ ืฉืœืึธืก ื•ื•ืึทืจื˜ืŸ ืื™ื– ื’ืขื•ื•ืขืŸ ืื•ื™ืฃ ื“ื™ PK_Sales_OrderLines ืื™ื ื“ืขืงืก ืคื•ืŸ ื“ื™ Sales.OrderLines ื˜ื™ืฉ.

ื‘ืึทืžืขืจืงื•ื ื’: ืื™ืŸ SQL Server 2014 ืื•ืŸ ืฉืคึผืขื˜ืขืจ, ื“ื™ ื›ื™ื™ืคืขืฅ ื ืึธืžืขืŸ ืงืขื ืขืŸ ืื•ื™ืš ื–ื™ื™ืŸ ื’ืขืคึฟื•ื ืขืŸ ืžื™ื˜ ื“ื™ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ ื“ืžืึธ sys.dm_db_database_page_allocations. ืึธื‘ืขืจ ืื™ืจ ื”ืึธื‘ืŸ ืฆื• ืึธื ืคึฟืจืขื’ ื™ืขื“ืขืจ ื‘ืœืึทื˜ ืื™ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก, ื•ื•ืึธืก ืื™ื– ื ื™ืฉื˜ ื–ื™ื™ืขืจ ืงื™ืœ ืคึฟืึทืจ ื’ืจื•ื™ืก ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–, ืึทื–ื•ื™ ืื™ืš ื’ืขื•ื•ื™ื™ื ื˜ DBCC PAGE.

1.4) ืื™ื– ืขืก ืžืขื’ืœืขืš ืฆื• ื–ืขืŸ ื“ื™ ื“ืึทื˜ืŸ ืื•ื™ืฃ ื“ืขื ื‘ืœืึทื˜ ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ื‘ืœืึทืงื˜?

ื ื•, ื™ืึธ. ืึธื‘ืขืจ ... ื‘ื™ืกื˜ื• ื–ื™ื›ืขืจ ืึทื– ืื™ืจ ื˜ืึทืงืข ื“ืึทืจืคึฟืŸ ืขืก?
ืขืก ืื™ื– ืคึผืึทืžืขืœืขืš ืืคื™ืœื• ืื•ื™ืฃ ืงืœื™ื™ืŸ ื˜ื™ืฉืŸ. ืื‘ืขืจ ืขืก ืื™ื– ืžื™ืŸ ืคื•ืŸ ืงื™ืœ, ืึทื–ื•ื™ ื–ื™ื ื˜ ืื™ืจ ื”ืึธื˜ ืœื™ื™ืขื ืขืŸ ื“ืขื ื•ื•ื™ื™ึทื˜ ... ืœืึธืžื™ืจ ืจืขื“ืŸ ื•ื•ืขื’ืŸ %%physloc%%!

%%physloc%% ืื™ื– ืึทืŸ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ ืฉื˜ื™ืง ืคื•ืŸ ืžืึทื’ื™ืฉ ื•ื•ืึธืก ืงืขืจื˜ ืึท ื’ืฉืžื™ื•ืช ืื™ื“ืขื ื˜ื™ื˜ืขื˜ ืคึฟืึทืจ ื™ืขื“ืขืจ ืคึผืึธื–ื™ืฆื™ืข. ืื™ืจ ืงืขื ืขืŸ ื ื•ืฆืŸ %%physloc%% ืฆื•ื–ืืžืขืŸ ืžื™ื˜ sys.fn_PhysLocFormatter ืื™ืŸ SQL Server 2008 ืื•ืŸ ื”ืขื›ืขืจ.

ืื™ืฆื˜ ืึทื– ืžื™ืจ ื•ื•ื™ืกืŸ ืึทื– ืžื™ืจ ื’ืขื•ื•ืืœื˜ ืฆื• ืฉืœืึธืก ื“ืขื ื‘ืœืึทื˜ ืื™ืŸ Sales.OrderLines, ืžื™ืจ ืงืขื ืขืŸ ืงื•ืงืŸ ืื™ืŸ ืึทืœืข ื“ื™ ื“ืึทื˜ืŸ ืื™ืŸ ื“ืขื ื˜ื™ืฉ, ื•ื•ืึธืก ืื™ื– ืกื˜ืึธืจื“ ืื™ืŸ ื“ืึทื˜ืŸ ื˜ืขืงืข #3 ืื•ื™ืฃ ื‘ืœืึทื˜ #70133, ื ื™ืฆืŸ ื“ื™ ืึธื ืคึฟืจืขื’:

Use WideWorldImporters;
GO
SELECT 
    sys.fn_PhysLocFormatter (%%physloc%%),
    *
FROM Sales.OrderLines (NOLOCK)
WHERE sys.fn_PhysLocFormatter (%%physloc%%) like '(3:70133%'
GO

ื•ื•ื™ ืื™ืš ื’ืขื–ืื’ื˜, ืขืก ืื™ื– ืคึผืึทืžืขืœืขืš ืืคื™ืœื• ืื•ื™ืฃ ืงืœื™ื™ื ื˜ืฉื™ืง ื˜ื™ืฉืŸ. ืื™ืš ื”ืึธื‘ ืฆื•ื’ืขื’ืขื‘ืŸ NOLOCK ืฆื• ื“ืขืจ ื‘ืงืฉื” ื•ื•ื™ื™ึทืœ ืžื™ืจ ื ืึธืš ื”ืึธื‘ืŸ ืงื™ื™ืŸ ื’ืึทืจืึทื ื˜ื™ืจืŸ ืึทื– ื“ื™ ื“ืึทื˜ืŸ ื•ื•ืึธืก ืžื™ืจ ื•ื•ื™ืœืŸ ืฆื• ืงื•ืงืŸ ืื™ืŸ ืื™ื– ืคึผื•ื ืงื˜ ื“ื™ ื–ืขืœื‘ืข ื•ื•ื™ ื•ื•ืขืŸ ื“ื™ ืฉืœืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ื“ื™ื˜ืขืงื˜ืึทื“ - ืึทื–ื•ื™ ืžื™ืจ ืงืขื ืขืŸ ื‘ืขืฉืึธืœืขื ื˜ืึธืŸ ื’ืจืึธื‘ ืœื™ื™ืขื ืขืŸ.
ืึธื‘ืขืจ, ื”ื•ืจื™ื™, ื“ื™ ืึธื ืคึฟืจืขื’ ืงืขืจื˜ ืžื™ืจ ื“ื™ ื–ืขืœื‘ืข 25 ืจืึธื•ื– ืคึฟืึทืจ ื•ื•ืึธืก ืื•ื ื“ื–ืขืจ ืึธื ืคึฟืจืขื’ ื”ืึธื˜ ื’ืขืงืขืžืคื˜
ื“ืขืกื™ืคืขืจ ืฉืœื™ืกืœ ืื•ืŸ Page WaitResource ืื™ืŸ ื“ืขื“ืœื™ืึทืงืก ืื•ืŸ ืœืึทืงืก
ื’ืขื ื•ื’ ื•ื•ืขื’ืŸ PAGE ืœืึทืงืก. ื•ื•ืึธืก ืื•ื™ื‘ ืžื™ืจ ื•ื•ืืจื˜ืŸ ืคึฟืึทืจ ืึท ืฉืœื™ืกืœ ืฉืœืึธืก?

2) waitresource = "KEY: 6:72057594041991168 (ce52f92a058c)" = ื“ืึทื˜ืึทื‘ืึทืกืข_ื™ื“, HOBT_Id (ืžืึทื’ื™ืฉ ื”ืึทืฉ ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื“ืขืงืจื™ืคึผื˜ื™ื“ ื ื™ืฆืŸ %%lockres%% ืื•ื™ื‘ ืื™ืจ ื˜ืึทืงืข ื•ื•ื™ืœืŸ ื“ืึธืก)

ืื•ื™ื‘ ื“ื™ื™ืŸ ืึธื ืคึฟืจืขื’ ืคืจื•ื•ื•ื˜ ืฆื• ืฉืœืึธืก ืึท ืจืขืงืึธืจื“ ืื™ืŸ ื“ื™ ืื™ื ื“ืขืงืก ืื•ืŸ ื•ื•ืขืจื˜ ืคืืจืฉืคืืจื˜ ื–ื™ืš, ืื™ืจ ืขื ื“ื™ืงืŸ ืžื™ื˜ ืึท ื’ืึธืจ ืึทื ื“ืขืจืฉ ื˜ื™ืคึผ ืคื•ืŸ ืึทื“ืจืขืก.
ื‘ืจื™ื™ืงื™ื ื’ "6: 72057594041991168 (ce52f92a058c)" ืื™ืŸ ืคึผืึทืจืฅ, ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ:

  • ื“ืึทื˜ืึทื‘ืึทืกืข_ื™ื“ = 6
  • hobt_id = 72057594041991168
  • ืžืึทื’ื™ืฉ ื”ืึทืฉ = (ce52f92a058c)

2.1) ื“ืขืงืจื™ืคึผื˜ ื“ืึทื˜ืึทื‘ื™ื™ืก_ื™ื“

ื“ืึธืก ืึทืจื‘ืขื˜ ืคึผื•ื ืงื˜ ื“ื™ ื–ืขืœื‘ืข ื•ื•ื™ ื“ื™ ื‘ื™ื™ืฉืคึผื™ืœ ืื•ื™ื‘ืŸ! ื’ืขืคึฟื™ื ืขืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื ืึธืžืขืŸ ื ื™ืฆืŸ ื“ื™ ืึธื ืคึฟืจืขื’:

SELECT 
    name 
FROM sys.databases 
WHERE database_id=6;
GO

ืื™ืŸ ืžื™ื™ืŸ ืคืึทืœ ืขืก ืื™ื– ื ืึธืš ื“ื™ ื–ืขืœื‘ืข DB WideWorldImporters.

2.2) ื“ืขืงืจื™ืคึผื˜ ื”ืึธื‘ื˜_ื™ื“

ืื™ืŸ ื“ืขื ืงืึธื ื˜ืขืงืกื˜ ืคื•ืŸ ื“ื™ ื’ืขืคึฟื•ื ืขืŸ ื“ืึทื˜ืึทื‘ื™ื™ืก, ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื•ื™ืกืคื™ืจืŸ ืึท ืึธื ืคึฟืจืขื’ ืฆื• sys.partitions ืžื™ื˜ ืึท ืคึผืึธืจ ืคื•ืŸ ื“ื–ืฉื•ื™ื ืฅ ื•ื•ืึธืก ื•ื•ืขื˜ ื”ืขืœืคึฟืŸ ื‘ืึทืฉื˜ื™ืžืขืŸ ื“ื™ ื ืขืžืขืŸ ืคื•ืŸ ื“ื™ ื˜ื™ืฉ ืื•ืŸ ืื™ื ื“ืขืงืก ...

USE WideWorldImporters;
GO
SELECT 
    sc.name as schema_name, 
    so.name as object_name, 
    si.name as index_name
FROM sys.partitions AS p
JOIN sys.objects as so on 
    p.object_id=so.object_id
JOIN sys.indexes as si on 
    p.index_id=si.index_id and 
    p.object_id=si.object_id
JOIN sys.schemas AS sc on 
    so.schema_id=sc.schema_id
WHERE hobt_id = 72057594041991168;
GO

ืขืก ื“ืขืจืฆื™ื™ืœื˜ ืžื™ืจ ืึทื– ื“ื™ ื‘ืงืฉื” ืื™ื– ื’ืขื•ื•ืขืŸ ื•ื•ืืจื˜ืŸ ืื•ื™ืฃ ื“ื™ ืึทืคึผืคึผืœื™ืงืึทื˜ื™ืึธืŸ.ืงืึธื•ื ื˜ืจื™ืขืก ืฉืœืึธืก ื ื™ืฆืŸ ื“ื™ PK_Application_Countries ืื™ื ื“ืขืงืก.

2.3) ืื™ืฆื˜ ืึท ื‘ื™ืกืœ ืžืึทื’ื™ืฉ %%lockres%% - ืื•ื™ื‘ ืื™ืจ ื•ื•ื™ืœืŸ ืฆื• ื’ืขืคึฟื™ื ืขืŸ ืื•ื™ืก ื•ื•ืึธืก ืคึผืึธื–ื™ืฆื™ืข ืื™ื– ื’ืขื•ื•ืขืŸ ืคืืจืฉืคืืจื˜

ืื•ื™ื‘ ืื™ืš ื˜ืึทืงืข ื•ื•ื™ืœืŸ ืฆื• ื•ื•ื™ืกืŸ ื•ื•ืึธืก ืจื•ื“ืขืจืŸ ื“ื™ ืฉืœืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ืื•ื™ืฃ, ืื™ืš ืงืขื ืขืŸ ื’ืขืคึฟื™ื ืขืŸ ืื•ื™ืก ื“ื•ืจืš ืงื•ื•ืขืจื™ื ื’ ื“ื™ ื˜ื™ืฉ ื–ื™ืš. ืžื™ืจ ืงืขื ืขืŸ ื ื•ืฆืŸ ื“ื™ ืึทื ื“ืึทืงื™ืึทืžืขื ื™ื“ %%lockres%% ืคึฟื•ื ืงืฆื™ืข ืฆื• ื’ืขืคึฟื™ื ืขืŸ ืึทืŸ ืคึผืึธื–ื™ืฆื™ืข ื•ื•ืึธืก ื’ืœื™ื™ึทื›ืŸ ื“ื™ ืžืึทื’ื™ืฉ ื”ืึทืฉ.
ื‘ื™ื˜ืข ื˜ืึธืŸ ืึทื– ื“ื™ ืึธื ืคึฟืจืขื’ ื•ื•ืขื˜ ื™ื‘ืขืจืงื•ืงืŸ ื“ื™ ื’ืื ืฆืข ื˜ื™ืฉ, ืื•ืŸ ืื•ื™ืฃ ื’ืจื•ื™ืก ื˜ื™ืฉืŸ ื“ืึธืก ืงืขืŸ ื ื™ืฉื˜ ื–ื™ื™ืŸ ืฉืคึผืึทืก ืื™ืŸ ืึทืœืข:

SELECT
    *
FROM Application.Countries (NOLOCK)
WHERE %%lockres%% = '(ce52f92a058c)';
GO

ืื™ืš ื”ืื‘ ืฆื•ื’ืขืœื™ื™ื’ื˜ NOLOCK (ืื•ื™ืฃ ื“ืขืจ ืขืฆื” ืคื•ืŸ Klaus Aschenbrenner ืื•ื™ืฃ ื˜ื•ื•ื™ื˜ื˜ืขืจ) ื•ื•ื™ื™ึทืœ ื‘ืœืึทืงื™ื“ื–ืฉื™ื– ืงืขื ืขืŸ ื•ื•ืขืจืŸ ืึท ืคึผืจืึธื‘ืœืขื. ืžื™ืจ ื ืึธืจ ื•ื•ื™ืœืŸ ืฆื• ืงื•ืงืŸ ืื™ืŸ ื•ื•ืึธืก ืื™ื– ื“ืึธืจื˜ ืื™ืฆื˜, ืื•ืŸ ื ื™ืฉื˜ ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขืŸ ื“ืึธืจื˜ ื•ื•ืขืŸ ื“ื™ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืื ื’ืขื”ื•ื™ื‘ืŸ - ืื™ืš ื˜ืึธืŸ ื ื™ื˜ ื˜ืจืึทื›ื˜ืŸ ืึทื– ื“ืึทื˜ืŸ ืงืึธื ืกื™ืกื˜ืขื ืกื™ ืื™ื– ื•ื•ื™ื›ื˜ื™ืง ืคึฟืึทืจ ืื•ื ื“ื–.
ื•ื•ืึธื™ืœืึท, ื“ื™ ืจืขืงืึธืจื“ ืžื™ืจ ื’ืขืงืขืžืคื˜ ืคึฟืึทืจ!
ื“ืขืกื™ืคืขืจ ืฉืœื™ืกืœ ืื•ืŸ Page WaitResource ืื™ืŸ ื“ืขื“ืœื™ืึทืงืก ืื•ืŸ ืœืึทืงืก

ื“ืขืจืงืขื ื•ื ื’ ืื•ืŸ ื•ื•ื™ื™ึทื˜ืขืจ ืœื™ื™ืขื ืขืŸ

ืื™ืš ืงืขืŸ ื ื™ืฉื˜ ื’ืขื“ืขื ืงืขืŸ ื•ื•ืขืจ ืขืจืฉื˜ืขืจ ื“ื™ืกืงืจื™ื™ื‘ื“ ืคื™ืœืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื“ื™ ื˜ื™ื ื’ื–, ืึธื‘ืขืจ ื“ืึธ ื–ืขื ืขืŸ ืฆื•ื•ื™ื™ ืึทืจื˜ื™ืงืœืขืŸ ื•ื•ืขื’ืŸ ื“ื™ ืงืœืขื ืกื˜ืขืจ ื“ืึทืงื™ื•ืžืขื ื˜ืึทื“ ื˜ื™ื ื’ื– ื•ื•ืึธืก ืื™ืจ ืงืขืŸ ื•ื•ื™:

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’